The Replay Trace will capture everything. I would setup the package to use a unique Application Name in the connection string so I could filter on that in the Trace...

Well, someone may. I use PowerShell + WMI for disk space monitoring and I check all...

It provides a way for the the replication engine to identify a row unambiguously. Unlike unique keys, primary keys do not allow NULLs. Why do you have tables with no...

One is running SQL 2000 Standard Edition x86...it's a memory bound old beast serving data for ColdFusion...

They still have some 2000 boxes around.

😛

Win32_Volume is more appropriate in some server environments. I use Win32_LogicalDisk in this environment as Win32_Volume is not a class on all the servers that I support.

Here is how...

pveilleux (6/6/2012)

---

This is good stuff, info I couldn't find in any of the BOL.

So, here's what I have:

JobA is owned by sa. SQL Agent and SQL Server are both...

SQLKnowItAll (6/6/2012)

---

If someone is a sysadmin, they are automatically in all fixed database roles....

pveilleux (6/6/2012)

---

opc.three (6/1/2012)

---

pveilleux (5/31/2012)

---

Hello, all,

In digging around on one of our servers, I found what appears to be someone logging in as the SQL Server/Agent service account and running jobs....

Issues I have with the OLE Automation procedures:

Issue #1

From BOL...

When an index is rebuilt or reorged only the stats for that index are updated. This is why I suggest also updating column statistics if you have time. If you...

The use of a table is in lieu of a file. Have a look at the link I posted. It explains all the types of package configs.

Andre Ranieri (6/4/2012)

---

My project involves creating a CLR trigger which will take a jpg file out of an NTFS share in bulk insert into a SQL table.

The CLR trigger is...

Right-click your Control Flow design surface and choose Package Configurations...

Click Enable, then Add, and you can choose SQL Server:

Look for the "SQL Server Configurations" section in this article:

Understanding Integration Services...