Viewing 15 posts - 1 through 15 (of 17 total)
Don't forget if you need the @@ROWCOUNT as well you need to use a SELECT not a SET.
Classic newbie error:
UPDATE ... Transaction...
SET @Err_Save = @@ERROR
SET @Row_Save = @@ROWCOUNT
@Row_Save will always...
November 6, 2003 at 4:29 am
All I really need is something that will establish a connection and record any failures or errors in a log file. Maybe it would be necessary to add a non-impacting...
July 15, 2003 at 12:08 pm
There is no "THEN" in the T-SQL IF..ELSE statement. Also if you need to do more than one statement in a conditional branch you need to wrap them with BEGIN..END
...
July 11, 2003 at 4:07 am
Like most respondants we only reboot our servers when neccessary. However as an aside this means you need a scheduled job to cycle your sql logs regularly (we do once...
July 9, 2003 at 11:07 am
Depends on the languages. For languages of Western European origin the default code page 1252, accent sensitive, should do fine. For other languages you need to pick the appropriate code...
July 9, 2003 at 10:56 am
The MSSQLServer service needs to run in a domain account to use Log Shipping, DTS and any operations that involve moving files between servers (pretty common operation for e.g. fetching...
July 9, 2003 at 10:49 am
On database creation: Installation of the sql instance should be scripted with setup.iss files for both the base instance and the latest (certified for production in your environment) service pack....
July 9, 2003 at 10:20 am
Your main issue in trying to set up an active/active failover cluster as a scale-out solution (as opposed to an availability solution which is what failover clusters are really designed...
June 30, 2003 at 6:55 am
While Brian is totally correct, AFAICS (also currently doing my MCDBA) it boils down to two choices, developer facing or sysadmin facing.
If you want to stay involved with application...
May 22, 2003 at 11:31 am
Some of the limitations of Win 2K clustering should be being overcome in Win 2003. Check out http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/windowsserver2003/technologies/clustering/default.asp for details. They seem to have taken a leaf out...
May 22, 2003 at 11:15 am
quote:
declare @myErr int, @myCount int[ do something ]
select @myErr = @@Error, @myCount = @@ROWCOUNT
The above...
March 31, 2003 at 9:56 am
To answer Ken Klaft - anecdotally, from a trainer about 3 years ago. Not very verifiable I agree. I defer to zach_john's account as he's nearer the source. In any...
March 13, 2003 at 5:45 am
I have yet to get the 2K DTS method to work yet, but then I was following the online help which is self-contradictory on this :(. As for the scripted...
March 10, 2003 at 4:42 am
Yes you can run a form of log shipping on standard edition. Either from the old Back Office Resource Kit (BORK) scripts, the 2K resource kit or write your own!...
March 10, 2003 at 4:25 am
In our environment the main barriers to deploying hotfixes and service packs are the third party supplier support issue and, above all, losing out to developers in contention for testing...
February 3, 2003 at 10:49 am
Viewing 15 posts - 1 through 15 (of 17 total)