TRY CATCH is used for error handling while IF is used for conditional logic.

IF (Some Condition)

BEGIN

-- run these statements if your condition is true

END

ELSE BEGIN

-- run these statements if your...

Beginner_2008 (1/21/2013)

---

Sql Maintainance plan which takes Full backups of 6 databases is failing with the following error:

Error Number: -1073548784

----------------------

Executing the query "BACKUP DATABASE [DatabaseName] TO DISK = N'\\\\BackupLocation" failed...

Nice easy question. The question is all about whether setting a bit datatype to 'TRUE' evaluates to 1 or NULL. Easy to guess as the output would either be all...

I had to investigate a similar problem and discovered the cause was a junior DBA running the following piece of code at 11PM and then going home.

BEGIN TRAN;

UPDATE MyTable SET...

:sick:

Not so much a case of...

Shrinking the database is not normal maintenance stuff.

Did someone steal your login credentials?

CREATE PROCEDURE TestErr

AS

DECLARE @Err NVARCHAR(255);

BEGIN TRY

SELECT 1 / 0

END TRY

BEGIN CATCH

SET @Err = 'Errrr';

RAISERROR(@Err, 16, -1);

END...

USE [AdventureWorks];

GO

CREATE TABLE TestTrigger (ID INT)

GO

CREATE TABLE TestTriggerAudit (ID INT)

GO

CREATE TRIGGER trTestTrigger ON TestTrigger

FOR INSERT

AS

INSERT INTO TestTriggerAudit SELECT * FROM inserted;

GO

INSERT INTO TestTrigger VALUES (1);

GO

CHECKPOINT;

INSERT INTO TestTrigger VALUES (22);

DBCC LOG('AdventureWorks',...

Binding a default value to a data type will be removed from SQL because it is a bad idea.

This feature will be removed in a future version of Microsoft SQL...

http://support.microsoft.com/kb/949080

Workaround 1

To work around scenario 1 in the "Symptoms" section, you must manually update the .NET Framework assemblies in SQL Server. To do this, use the ALTER ASSEMBLY statement to...

Stewart "Arturius" Campbell (1/21/2013)

---

Good qurstion, Ron,

Thanks

Sean Pearce (1/21/2013)

---

This question is better suited for http://www.GeographyCentral.com.

How does knowing the last day of February in 2016 have anything to do with...

This question is better suited for http://www.GeographyCentral.com.

How does knowing the last day of February in 2016 have anything to do with SQL Server? I had to check a...

Count Function (Report Builder 3.0 and SSRS)

Returns a count of non-null values specified by the expression, evaluated in the context of the given scope.

scope

(String) The name of a...

Don't forget to restore those backups.