Search BOL for DISABLE TRIGGER... 🙂

and to check if enabled or disabled see ...

SELECT * FROM sys.triggers

You're looking for the FIRST_VALUE function.

DECLARE @testData TABLE

([Industry] VARCHAR(2)

,[Naicstitle] VARCHAR(50)

,[NumMatch] INT)

INSERT @testData (Industry,Naicstitle,NumMatch)

VALUES

('00', '', 1025)

,('62', '',...

I've not tested against 2012, you'll have to try and post back here if it does work.

This will get you the results you want. Maybe a bit overkill with the custom subscription part, but it's the only way I've found to do it.

http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69546/

Ok, there were multiple deadlocks over the weekend. Nearly all are fairly much the same as the log text below.

There is definitely something wrong with replication. Any thoughts, this isn't...

Mark Fitzgerald-331224 (10/10/2013)

---

Jason Selburg (10/10/2013)

---

Personally, I'd move the decision logic to the procedure. have it accept both parameters as nullable, then handle your logic there.

The Report then only needs one...

Personally, I'd move the decision logic to the procedure. have it accept both parameters as nullable, then handle your logic there.

The Report then only needs one dataset.

Thanks Gail, it may be tomorrow or later before 1. I get the permissions and 2. the deadlock happens again.

I'll let you know as soon as I have more...

try this link ...

http://i129.photobucket.com/albums/p207/jselburg1970/deadlock.png

Ok, what are you asking? Where what? 🙂

I'll need to get permission from the client to turn on the trace, but in the meantime here is the limited information from the SQL Error Log.

** Each of these...

The server where the backup was created is 10.50.2500.0 or SQL Server 2008 R2 SP1, the version you are trying to restore to is 10.00.2531 or SQL Server 2008 SP1.

You'll...

deleted

Why not drop the column after creation and before putting anything in it?

My understanding is the CMS allows for the logical grouping of your registered servers that can be shared in your organization.

It also allows you to run queries against all servers...