Could you post the procedures and the details of the deadlock graph?

Dynamic SQL. Build up the create table statement as you un through the cursor, then execute the statement. Something like the following (rough pseudo-code)

SET @Creation = 'CREATE TABLE MYTable ('

Fetch...

From http://www.sommarskog.se/grantperm.html

SqlContext.WindowsIdentity.Name will return domain and Windows user name, if the user logged in through Windows authentication. For an SQL login, WindowsIdentity is Null, so access to...

Short answer, in an order determined by the execution plan that the optimiser comes up with. that order may vary with server load, data volumes and other factors.

It's possible that...

ExecuteNonQuery is the .Net method to execute a command and not return any results.

Alternatives are ExecuteScalar, ExecuteReader and ExecuteXMLReader. (At least in .Net 2.0)

If you do a select from that table with the same where clause, do you get any rows back?

Unrelated to your question, but serious anyway. Are you aware that your code is...

833 is indicative of a overloaded IO subsystem or a misbehaving IO filter driver (like an anti virus)

Are the drives local, NAS or SAN?

Run performance monitor on the server during...

The local variables work because the query optimiser can't sniff their values when it compiles the proc, hence it will generate an average-case plan, optimised for no particular values

Possibly, but it is not simple. Would require that your master call out to the command prompt and run SQLCMD, passing it the files to run. Something like this might work...

The best strategy depends greatly on the queries that you use. Some points

Put seperate indexes on seperate columns when queries use different columns. an index on 2 columns ColA, ColB...

With 5 GB memory on the server (that's a rather weird amount) I'd probably set min to 3.5 and max to 4, providing there are no other apps that run...

Down here (South Africa) an average-good salary for a DBA with 4 years experience is around R360k/year. At current exchange rates, that's about $50k/year.

We've also got major shortage of skilled...

Thanks

Guess I'm too used to forums where when writing a reply, the entire thread is visible.

Sweet. I like how it is now.

Maybe now Notification Services: Administration won't get posts on everything under the sun... *g*

3604 directs output to the client, 3605 directs it into the error log.

I don't think 3605 is necessary. 1204 on its own writes deadlock info into the error log. We...