Odd, are you running the same queries through when running profiler and the server-side trace?

Yes, unequicocally, yes.

As GSquared has said, it helps you automate maintenance and monitoring tasks, and if there is a problem you need to know it to diagnose the...

I tend to be on the "limit access" side of this equation. I believe that users should rarely be granted direct access to tables, but access should be controlled...

You would use CREATE ROLE, the use GRANT to assign the necessary permissions, then use sp_addrolemember to add the user to the role.

Neither is very good as doing any conversion on a column will at best use an index scan. The best solution is to store data in a properly typed...

Done.

Do you have any errors in the event log?

If you don't have any Foreign Keys defined you could do "Truncate Table CleanLeads" as the first statement. That is usually faster than a delete when you want to...

Congrats, but of course exactly what I'd have expected for you, barring the one negative comment.;-)

I typically do not use the fixed database roles as they tend to be more open than just granting Create Table, Create Procedure, Create View. I'd usually create my...

according to BOL is looks like you are out of luck

To use Database Diagram Designer it must first be set up by a member of the db_owner role (a role...

It looks to me like in 2005 you can only grow or shrink, and not control whether you get wider or taller. I think you are out of luck....

You need to be wary of global temp tables. Is there any possibility of multiple requests occurring concurrently? If there is one will fail on the create table...

Could be parameter sniffing.

I had to ask as I'd had this problem in the distant past. Let's see, have you tried OPENQUERY? Can you connect from a .NET application using the...