Either there's a proxy account, or the Replication is being executed under his account, which is possible. Have a look a the publication and subscription properties, and check the Agent...

Do you have any versions of Visual Studio/TFS installed as well? One of our developers' Intellisense stopped working which was caused by an SP install of VS 20101 if I...

I'd actually disagree with putting the database name in the 3 identifier, if the database gets renamed all the queries will fail, and that's a lot of effort to put...

As far as I remember, Notification Services was removed in SQL Server 2008 and above, and I doubt you can install the 2005 service to a 2012 instance.

Anywhere from 1 to perhaps 3000 rows

That was what I tried originally, but the performance is terrible using pattern matching on the formula, iterating through each CellID to replace it with the given value.

I was hoping...

It can be anywhere up to 15000 rows I think.

Thanks for that note, although at this time I've already got a function that will take the resultant formula and execute it to give me the result value, at this...

For PCI DSS purposes we had to run A/V on SQL Servers, but with it configured in such a way with the exclusions on them, it never caused any performance...

We use A/V on our servers and a lot of our production SQL Servers have anything from 256GB to 1TB of memory. As well as setting the file exclusions as...

Import the XML into a temporary staging table, then issue a merge command between that and the live one, so you're updating existing data and only adding in new rows.

Yes, and sometimes you can get better results using different versions of the Oracle Client too if you have to go down the linked server route. I remember at the...

I've had to migrate data from Oracle to SQL before, and I've found the only real reliable way was through SSIS, as it could handle the data type differences better...

you're right about importing the encrypted data, I guess rereading the original post it wasn't clear whether the file was encrypted or the data in it..

Either that or cheat with your SELECT statement and output.

Let's say you want to output each table to a CSV file. Rather than doing

Select

Col1,

...