The real way is to use the Dedicated Administrator Connection. You need to be on the physical box and member of sysadmin, and you can use either sqlcmd or Management...

You conclude that you should do the UPDATE first. "The best strategy is to attempt the update."

But with any SQL Server question, it depends :). In a heavy transaction...

I agree, more on source control integration, thanks.

We use Speed SQL IDE Pro from Imceda, which I think is the best database tool for integrating source control. Does anybody know...

I only answered the question to see other peoples reactions. I was missing this answer NARCISSISM though.

Quote: "sets oConfigValue to the value of this parameter... " this is not entirely true. You assign the ConfigValue object to oConfigValue, then you can set the CurrentValue property...

Uh, that was a tricky question . Worth 2 points it couldn't be the obvious answer, so I had to scrutinize the code, but ended...

You will have to check for errors after every statement (that migth break your code)

Here is an example that works for most cases:

Update SomeTable Where Key = @Param

Select @Err = @@ERROR,...

This should do the trick

insert Results

select name, Count(ObjectID) as Cnt from SP_COUNTS

inner join sysobjects on ObjectID = ID

group by ObjectID, name

The Results table has two columns Name and Cnt

A more clear explanation is that the result is the index it self. The data is retrieved from the index, not the table, since your a not requesting other data than...

Are you short on new questions?

The answer was given as part of yesterday's answer.

I've previously tried it on my own body, so I know my answer HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft \MSSQLServer\MSSQLServer\LoginMode is correct.

You must have made the question late at night, since you also...

What happens to the connection? Connection pooling takes place when the connection string is the same, which it will be when using windows authentication. I would guess the connection stays the...

True, but that kind of defeats the purpose of the clustered index, as you are not likely to do searches on the ID, specially not range searches. You should cluster on...

There is a bug when you use regional options than don't use . as decimal symbol.

Chris

Why not use SQL-DMO? With this component you can create SQL Enterprise Manager like applications, with out going for the systemtables. Just add a reference to Microsoft SQLDMO Object Library.

And...