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...

Via what? REST? SOAP? FTP?

They're two ways to do the same task. SSIS OLE DB Destination with Fast load uses OPENROWSET to leverage the BULK INSERT interface. OPENROWSET when used from T-SQL with a...