- keep in mind sp_change_users_login should be executed with a connection to the troubled database !!

- if it returns no rows, all users are mapped ! So the

- if...

maybe this solution is also worth comparing to the other plans and execution times

SELECT

-- distinct is not...

Like Antares686 said, profiler is mostly used for troubleshooting, so you only add the overhead for a controled period of time. In this...

- exec sp_helpsrvrolemember @srvrolename = 'sysadmin'

(Is builtin\administrators not removed ?)

- use your_troubled_db

   EXEC master..xp_logininfo @acctname = 'youruser',@option = 'all'

- keep your profiler running ! so you can see growth is stopped.

- contact your coworker again to monitor his application in detail (profiler) and ask her/him if something has...

- start a sqlprofiler trace to find out what's going on !

- to shrink tempdb, you'll have to stop/start sqlserver. It will cleanup the db and start with the original...

9.00.3186 Cumulative update package 3 for SQL Server 2005 Service Pack 2

http://support.microsoft.com/default.aspx/kb/939537 released 2007-08-20

And it's a place where (by default) there exist no stupid questions.

(exceptions may occur  )

You can...

- which OS are you using ? W2003, XP, ... ?

- did you have a look at :

 - http://support.microsoft.com/kb/925001 ?

 - http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=246883

If you want to trace in batch, you need to trace to a file !

Afterward you can load the file to a given (empty) table using :

-- HOW TO: Programmatically...

with simple recovery, a transcation is marked to be overwritable (in the transaction log file) once it is committed or rolled back.

You need to make log-backups to keep your transaction logs from...