There is no way to determine this after the fact. If you are getting deadlocks, use the hints above to setup a trace and look for them.

Rather than search for the city name, what about searching for the state and then adding the comma before it?

Get the performance plan from Query Analyzer. CTRL-K should turn it on. Run your query and then look at the performance plan. It will clue you in to the sections...

Be sure this SMS account has rights to connect to SqL Server. It logs in like any other user of SQL Server.

See the other thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=138256

You might try the compare tools from Red Gate and Apex SQL to see if they handle this.

I believe the autoval column in syscolumns has a value for identity coluymns.

Escape it by doubling them up.

select * from table1 where name like '%''%'

The user might own things that the role wouldn't.

There isn't a way to limit by user, only by total connections.

That is strange. Under what account does the DTS package run? Is is a sysadmin? Is your DB owned by sa? Does this happen if you run them interactively instead...

I'm not sure what you mean by shares. As far as logins, search sp_help_revlogin on MSDN and you can use that script to move logins for SQL 7 and 2000.

Nice complement and indeed I get lots of questions submitted, well not lots, but probably 1 of 10 is submitted. However, most people don't want to get credit because of...

I'm not sure what you mean? You can go back and answer the old questions.

We're also getting a book ready with previous questions of the day for sale. Look for...

Thanks, and since I'm posting, it worked, sort of