I think your idea can help. Thanks! Frank.

Right, but I want to prepare a script for production server, so don;t want to do it using EM. Is there any direct method without droping Table and Column?

Take the TL backup, de-attach the DB, move TL file to other folder (don;t delete) and try attaching the DB without the TL file. System should create new TL file....

Still waiting for any response.:)

Any one with any opinion??

Provide the DATABASE_NAME, following statements will do the rest.

backup log DATABASE_NAME with truncate_only

go

DBCC SHRINKDATABASE (DATABASE_NAME, 10)

go

Database is around 450MB in size.

I watched long queries using profiler in peak hours, max query time noted is 31 secs.

I am still nowhere!!

If Page Faults is one of the reason of eating memory, how it can be rectified??

These no's are far below than ours :O.

At 446112K of memory consumption by SQLSERVR.EXE, page faults are 114665K.

We have upgraded our DB server to 2 xion processors and 2GIG...

While investidating SQL behaviour on consuming all available RAM, DBCC memorystatus show following results:

Stolen 45606

OS Reserved 1680

OS Committed 1647

OS In...

Yes.. its about user. Client particularly specified our DB user name. How can otherwise he know DB user?

Anyway I asked for error screen shot to re-confirm.

YES.. I did..Can we do something to avoid this situation.??

I have used Global Temporary Tables instead of using a table in production DB and then go for TRUNCATE TABLE.

Scope of global temp table can span on multiple objects and...

While using DTS, select copy views and tables from source database, then select excel sheet to import and click TRANSFORM for column mappings. You can simply ingore source and destination...

CafeMar1.. Your idea could be another choice as to Keep single online DB for all clients and indvidual offline DB's for each client, DTS package would move the data to...