DMV data is not guaranteed to be accurate at the time of retrieval. They are updated asynchronously.

robbase9 (7/25/2012)

---

So I just learned that some of our users are using a VM to impersonate a sysadmin and logging into SSMS using the command:

runas /netonly /user:domain\username “C:\Program Files (x86)\Microsoft...

It is nice you can leverage some of the T-SQL improvements now that you have completely moved off 2000. However, while your perspective might be tilted towards "we just moved...

Sounds odd. Can you please post more from the trace? Including the text data from the entries for the proc calls?

GBeezy (7/30/2012)

---

Thanks for the reply OPC...

I did try that method as I researched out to get this done. My problem that I had with it, is that the File...

Cool doc. Thanks for sharing it. The Wikipedia page on SQL Server has a lot of this with background info but where it tries to be more detailed it has...

Please save off the deadlock graph and attach it to this thread.

shrishasqldba (7/28/2012)

---

xecuting query "DECLARE @Guid UNIQUEIDENTIFIER

EXECUTE msdb..sp".: 100% complete End Progress Error: 2012-07-29 15:00:32.68

Code: 0xC002F210 ...

stephen.chapman 77519 (7/24/2012)

---

Hi,

I am new to this forum but I have just had to deal with setting up log shipping for a DR site which would have meant setting this...

You're welcome.

One of my favorites! Was actually my desktop wallpaper for a while 😎

Nothing.

Mordred (7/28/2012)

---

Alright, I think the issue might be that I have some duplicate values in the csv file trying to be passed into the PK fields. Is the csv...

If you're not versed in programming in C# (SSIS 2008+) or VB.NET against the Office Object Model, or at all, then I would recommend you create an empty Excel Workbook...

Welsh Corgi (7/26/2012)

---

Thanks for all of the ideas.

I got audited today but an outside firm and I got dinged for having the Staging and Data Warehouse on the same server....