Try Catch Throw

Terminating with THROW

THROW formatting

THROW defaults

THROW - 1

Bye Bye to the RAISERROR Function?

This article describes the use and advantages of the throw statement.

RE: DTS date stamp

Well that makes sense.I've commented the messages out and it runs fine until I run the whole thing has a schedule again.  This is the error message:DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSDataPumpTask_1   DTSRun OnStart:  DTSStep_DTSActiveScriptTask_1   DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_1   DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error = -2147217887 (80040E21)      Error string:  Error opening datafile: The system cannot find […]

DTS Global Variable problem

I have a DTS set up which checks the status of a process and sends an alert to a user if a certain condition is met.Each run checks the condition against a global variable, and when complete, updates the global variable with the new value.For example: GV1 was preset to "SUCCESS", after very first run, […]

RE: Create DB using .mdf and .ldf

I suggest unless you know they come from another source like an Access database or SQL 2000 and you have 7 that you just try to attach. It will give you a nice error message if it has issues.

where can i get login logout tmming of database user in MS-SQL SERVER

Our client requiry login logout timming of a datase user that where can get