This works for me

USE TestB; --replace with your appropriate database

GO

CREATE TABLE TBL1 (Property nvarchar(255))

GO

CREATE PROCEDURE DBO.InsertProperties(@Prop NVARCHAR(200))

AS

BEGIN

INSERT INTO TBL1 VALUES ('N'+char(39)+@Prop+char(39))

END

GO

EXECUTE DBO.InsertProperties N'????' --Run the SP

GO

SELECT *

FROM TBL1;

GO

russ.thomas (2/20/2014)

---

Here is some more recent info from the SQLCAT team... among some other petabyte monsters and companies they profile the databases running XBOX live which adds 12 TB monthly...

Grant Fritchey (2/20/2014)

---

No way in the world, at all, to avoid the log, so best practice is to find ways to deal with it. No other choice there. If you...

One option is to use SQL Data compare. I know it is not coding your own solution and does come with a price tag. But there is a...

happycat59 (2/20/2014)

---

Yes but

create database [DELETE]

does work

I am just waiting for...

jshahan (2/20/2014)

---

We developed a test that required applicants to write queries against our proprietary database that would answer a list of specific questions we provided along with which tables to...

Not sure on FalconStore. I have never used it. Maybe somebody else has and can chime in.

Shawn Melton (2/20/2014)

---

GilaMonster (2/20/2014)

---

Shawn Melton (2/20/2014)

---

Do you bother capturing a before and after to show what you accomplished?

What type of information did you capture (perfmon counters, DMV output, wait...

Definitely me:-D:-D

jayoub (2/20/2014)

---

Is disk alignment for everything or just for the clustered resources/disks?

I am not sure if the disks have been aligned or not. NETApp is helping out, so they...

Revenant (2/20/2014)

---

The Dixie Flatline (2/20/2014)

---

I think that's...

Revenant (2/20/2014)

---

Because trusting MSDN and the BoL after all these years fits precisely the definition of "repeating the same [course...

Because I forgot...squirrel...

Let me throw another concern out there for you.

Have they aligned the disks on the netapp prior to doing the DTA move?

I have done migrations using both (or at least...

Red