Steve.Cornelius (8/3/2011)

---

I see very little of value in this article. The readers are ever so slightly better informed after reading it, but have acquired no useful information. In fact...

opc.three (6/8/2011)

---

Thanks for the great article David!

From the article:

Therefore, each row in a database, at any given point in time, can be identified by three numbers; file number - page...

pdanes2 (8/3/2011)

---

opc.three (8/2/2011)

---

From xp_logininfo Books Online article

I...

From xp_logininfo Books Online article

I think this...

You're welcome, HTH 🙂

I've been working on this for hours and you've solved it in a few minutes!! Do you know if it is...

The service running as Network Service sounds fine. You are obviously receiving domain info per the xp_logininfo results you posted.

One more request please.

Most of the stuff is still fine,...

Nice job posting the question complete with DDL, DML and expected results 🙂

I reworked your DML a bit to provide an actual NULL instead of the string 'NULL'. See if...

krish.sett (8/2/2011)

---

Thanks for your suggestion ,however our team is looking for something Open source.let me know if we have something like XML Spy which is open source.

I have the...

You may be able to retrieve the deadlock graph using Extended Events.

Please read this article:

Retrieving Deadlock Graphs with SQL Server 2008 Extended Events[/url]

Note: if you're on 2008 (not R2) then...

Have you considered using XSLT to transform the file? If you already have an XSD then mapping the input columns to that should be trivial with a decent XML Development...

If we use compat mode (I'm still trying for a full regression test...

It sounds like you want Control Flow functionality inside a Data Flow...I don't think that's how it works 🙂

Someone may drop in with some magic setting I am not aware...

ALZDBA (8/2/2011)

---

I hope you did run the upgrade adviser tool. It will point to potential issues and may be a great to prevent failures and prepare migration projects.

Don't start without...

I was going to cite myspace.com too. I heard Christa Stelzmuller speak at PASS 2009 and she was flanked by SQLCAT team members. They were explaining how they use Service...

sunshine-587009 (8/2/2011)

---

Isn't there something that needs to be done on the boxes themselves since they are different domains? Could there be a syntax to add the Server Name, User ID...