I have a similar issue.. I want all my steps in a job to go to the next step even if the step fails but I want it to...

I use a Free product called SQL Heartbeat by SQL solutions. It lets you see visually the deadlocks as they happen and with graphic links of who is causing the...

The SQL dedicated admin connection, so your Management app does not lock up and hang when something goes wrong in SQL. So needed over the years.

I used to manage a huge casino management system and was forced to use triggers to audit tables that were updated by stored procedures. Altering vendor code is never a...

Ron Porter (11/12/2010)

---

Steve Jones - SSC Editor (11/12/2010)

---

Some interesting "get there from here" possibilities are coming to mind. Imagine that we allow self-driving cars, but only for < 15mph. Perhaps...

Don't forget, Americans love cars. It's built into us since childhood. Driving is convenient and you don't have to pay a fee each time you get into the car. You...

How come my Sim City 3 never seamed to work out that way? 😛

Here is another way I calculate age.

SELECT @AGE = ' '+CAST(((datediff(ss, @DOB,GETDATE())) /31536000) AS NVARCHAR(MAX)) +

' Years, ' +

CAST((((datediff(ss, @DOB,GETDATE())) %31536000) /2628000) AS NVARCHAR(MAX)) +

' Months, ' +

CAST((((datediff(ss, @DOB,GETDATE())) %2628000)...

No matter where you backup to, the key is making sure your Backup software backups and verifies the SQL backup file correctly. The worst thing in the world is when...

In SQL 2005 you will most likely want to add a Maintenance Clean up Task into your Backup Plan. Set the task to delete files with .bak extensions in your...

I don't think it’s a permissions issue. I have fought with this many times. It may be a minor bug with your 2005 Server Management Studio Application.

I noticed that in...