Correct even I'm aware of only Profiler in SQL 2000. Don't know if MS has come up with something in SQl 2005.

M.

please replace SMILEYS with ')'

M.

Hey All,

Finally, I have written this script to find orphan logins....please validate and let me know if anythings needs to be handled...Thanks! M.

usage: EXEC tempdb..usp_orphanlogins

--------------------------------------------------

IF exists (SELECT * FROM dbo.sysobjects WHERE...

Thanks everyone for your responses.

Igori- I’m working on your suggestion…i’m writing a T-SQL which would generate a report of Orphan Logins.

Yes, session settings/data/indexes are identical. As far as stats are concerned, i updated them on the poor performing database (but it didn't help). We are taliking about a query. I...

Thanks for your reply.

I ran update stats against database 'B' but to no use. Query plan still not making use of parallelism.

DBCC updateusage is...

One thing more...I'm still analyzing the health of indexes on both databases...but i doubt there will be any difference.

Even we installed W2K3 SP1 last weekend on our prodcution servers and got the servers rebooted and @@servername is working fine w/o any probs.

We didn't use sp_dropserver and sp_addserver..