Viewing 15 posts - 1 through 15 (of 15 total)
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...
November 3, 2009 at 7:54 am
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...
January 29, 2008 at 2:43 am
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...
July 7, 2005 at 4:34 am
I only answered the question to see other peoples reactions. I was missing this answer NARCISSISM though.
December 17, 2004 at 1:50 am
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...
December 9, 2004 at 1:39 am
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...
November 4, 2004 at 1:37 am
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,...
November 3, 2004 at 2:02 am
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
October 19, 2004 at 1:48 am
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...
September 21, 2004 at 2:20 am
Are you short on new questions?
The answer was given as part of yesterday's answer.
September 2, 2004 at 1:58 am
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...
August 25, 2004 at 1:08 am
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...
August 24, 2004 at 7:33 am
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...
August 12, 2004 at 1:54 am
There is a bug when you use regional options than don't use . as decimal symbol.
Chris
June 30, 2004 at 1:51 am
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...
July 8, 2003 at 1:27 am
Viewing 15 posts - 1 through 15 (of 15 total)