I think a little more information is probably needed. I personally don't know if 400 active connections is a problem but I would guess it wouldn't be so long as...

I believe you are basically after the following. If you have a limited number of colors you can avoid the #temp table and dynamic SQL version and require only the...

I'm affraid I can't see your hard drive. Mind fixing your link to point to a public site or posting a text version of it? Rename "Error.jpg" on your desktop (and...

We use SQL Server authentication here so I can't really help you out anymore. Could another reader please feel free to jump in?

The only suggestion I would have would be...

As I layed in bed this morning not wanting to get up I came up with the following. Note that this involves maintaining individual connections for each user for the...

Sweet! I'm a hero!

::flexes::

By my understanding if you wish to track comprehensive actions taken by the user within SQL Profiler then you simply need seperate logins. If you follow Thorek's route and add...

I'm thinking the error at step 3 was a result of the following snippet I pulled from the SQL Server Books Online for sp_addlinkedsrvlogin:

true for useself is invalid for a Windows...

I think it is complaining about the table name being a variable. I've always used dynamic SQL with this sort of thing.

exec( 'GRANT EXECUTE ON ' + @storedprocname + '...

If the above is really your setup then a simple while loop is all you are after. We created the following function to do exactly that. Given a comma delimeted...

_WA_Sys_ are for statistics which apparently need to be stored in sysindexes, but aren't actually indexes. The Internet claims there are books online to explain it although I haven't looked....

I haven't tried this in the job context, but I've noticed in our VB world that if I call SP 1 that performs an exec on SP 2 that internally...

If you CAN tollerate dynamic SQL the following should do it. Unfortunately it uses a true temp table as well since it has to survive the scope change into the...

You should probably review and watch:

http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=132614

FYI, my original first post started out asking if the columns were fairly consistent or highly variable but that got dumped on me and...