See if this gets you there:

EXEC('SET IDENTITY_INSERT CORELIBRARY_ARCHIVE.dbo.MessengerLog ON') AT [NAS2-RPS];

You might be able to do it using Extended Events.

Patti Johnson (9/27/2012)

---

I cannot find exactly what I am looking to know regarding SQL Server 2008 Express R2 and support for DTS Packages. Can I install SQL Server 2008...

Sure, in the spirit of objectivity XML might help you in some specific cases. If you're in need of every ms of performance test XML. You could also reasonably include...

Thanks for posting the code.

I have no problem with this:

ALTER TABLE Invoicing_2005..T2 ADD CONSTRAINT CK_T2 CHECK (Val BETWEEN 10 AND 10)

BETWEEN is inclusive so it's the same as saying this:

ALTER...

+1

This is where I would start as well.

Can you please post the view code? The DDL for the 2013 table maybe useful as well, but I'd really like to see how the view is defined.

Have a look at Ola Hallengren's Database Backup script. It does what you're wanting and if setup in a SQL Agent job you can send an email if the job...

http://www.sqlservercentral.com/Forums/Topic1364971-391-1.aspx#bm1365006

Cuisinart

Shameless self-promotion:

http://groupconcat.codeplex.com/%5B/url%5D

I just did this last week but do not remember if it was Eval to Enterprise or Eval to Dev Edition. I do remember I used the Edition Upgrade feature...

An EKM system would solve this problem for you I think. If it supported Windows Auth all the better. You could secure the key so only your devs and relevant...

Perry Whittle (9/25/2012)

---

opc.three (9/25/2012)

---

CREATE TABLE #LOGSPACE

(

DB SYSNAME,

LogSize FLOAT,

SpaceUsed FLOAT,

Stat BIT

);

INSERT INTO #LOGSPACE

(

...

Jeff Moden (9/26/2012)

---

opc.three (9/25/2012)

---

Do not enable xp_cmdshell! You do not need it for this scenario and it introduces risk in your environment.

If you want to do everyting...