Here's an alternative way to change the server collation. http://spaghettidba.com/2011/05/26/changing-server-collation/

Read the "An undocumented method" paragraph.

Rowles (1/29/2012)

---

I have four questions that have nothing to do with each other. They are small, so I hope it is ok to consolidate them.

#1

This link

http://msdn.microsoft.com/en-us/library/ms175037.aspx

says this:

"Forced parameterization, in...

If you want to set up a linked server you need the Oracle client.

There's no way around it.

I liked the last comment:

Why not use a snapshot?

GSquared (1/27/2012)

---

Jack Corbett (1/26/2012)

---

Okay, Jason don't report me. Just found this in an SP:

IF 1 = 1 -- Placeholder in case there is an actual conditional on...

Not always 😀

On a totally different note, I was looking for a good open source project management software for a client of mine and I found this one[/url] that looks pretty cool.

I...

SQL Kiwi (1/27/2012)

---

If you are referring to "please reply me of my question only .Thanks",...

That's exactly what I gave to you. Did you read the article?

Beyond that, I would have to do the work for you.

BTW, CAPS and bold is an unpolite way to...

I guess you need Jeff Moden's split function[/url].

Does this help?

-- SAMPLE DATA

DECLARE @Audit TABLE (

[ID] varchar(50),

[Owner] varchar(50),

[Modified on] datetime,

[Previous Delivery Date] datetime,

[New Delivery Date] datetime

)

SET DATEFORMAT dmy

INSERT INTO @Audit

...

Why would one ever want activity monitor when you can have Adam Machanic's sp_whoIsActive?

No, this was a mistake of mine. EXECUTE...AT works with dynamic sql and not with procedures.

Which backup sets did you restore?

FULL + DIFF only? No TLOG?