Munabhai (7/27/2012)

---

Michael, I did try following way but still showing error before running. this is what I was looking for

DECLARE @VALUE INT

SET @VALUE = 101

SELECT

STATEUS

from

STATEOFUSA

WHERE STATEUS =

(case

when @VALUE =...

SELECT

STATEUS

from

STATEOFUSA

WHERE

case

when @VALUE = 103

then 1

when @VALUE in 101 and STATEUS in ('TX','CA','NM','AZ')

then 1

when @VALUE in 102 and STATEUS not in ('TX','CA','NM','AZ')

then 1

else 0 end = 1

Putting an artificial and unneeded CPU load on a server, putting large files that are not needed on the disk, and generating unneeded disk or network IO seem like things...

Confused about what? TRY/CATCH or MERGE or something else.

Welsh Corgi (7/25/2012)

---

Sean Lange (7/25/2012)

---

What is the question? I am not sure where you are stuck. You built your proc to log the error. Now just raise it again inside...

It's is fairly simple to get the counts for inserts, updates, and deletes from the MERGE statement output.

Example:

set nocount on

go

create table #source (

PKintnot null primary key clustered,

Col1intnot null )

create table...

It would probably cost far more for development/maintenance time to change the application to distribute the database across multiple servers than it would to upgrade to a more powerful server...

It appears that is a documentation error, and that database mail is fully supported on SQL Server 2012 Standard Edition 64-bit

http://social.msdn.microsoft.com/Forums/en-US/sqldocumentation/thread/97ae8556-c5b2-4816-ae60-5423247c6ad2/

To keep the SQL Server Error Log file from getting too large (1 GB??), I schedule a job to run every week on Sunday at 00:00:00 to start a new...

Set the database to simple recovery, shrink it, and set it back to full recovery.

Also, I think you have the wrong format for the DBCC SHRINKFILE command.

use [master]

go

alter database [model]...

Harsh ranking systems are very common in sales.

Someone told me about an automobile dealer he worked for where every month they started with 13 salesmen and at the end of...

Why don't we just convert to a "metric" date system, like Julian date:

The Julian date for CE 2012 July 20 04:00:00.0 UT is JD 2456128.666667

It makes a much sense as...

ScottPletcher (7/16/2012)

---

Michael Valentine Jones (7/16/2012)

---

ScottPletcher (7/16/2012)

---

SQLKnowItAll (7/16/2012)

---

ScottPletcher (7/16/2012)

---

Donald Bustell (7/16/2012)

Database: timetracking

Column: project varchar(50)

Questions:

1. What in the world???

2. How would I craft a trigger to just RTRIM everything on the way...

ScottPletcher (7/16/2012)

---

SQLKnowItAll (7/16/2012)

---

ScottPletcher (7/16/2012)

---

CREATE TRIGGER dbo.project_trg_ins

ON dbo.project

AFTER...

As an alternative to implementing TDE to protect the backups, you could use a third party backup utility to encrypt the backups. The disadvantage is that you would have...