When you move your database from one server (A) to another server ( B), you will definitely face login failure issues from Application ( front end).

Like you said, you...

Works only in SQL Server 2005 , doesn't work in 2000.

file size mentioned is very low, including growth rate.

This is what I do now, I open two instances, one I use for Dts and other I use for query.

Thanks,

Thanks homebrew ,

I guessed its because of DTS packages... Its really wierd though, it means when ever you are working on DTS packages you cannot use SSMS query window ????...

Executed : exec sp_helprotect 'dbo.profiler'

Result : "Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291

There are no matching rows on which to report."

Conclusion : What is this ?

Note :...