the better question is why you think you need a report with 600K or more records in it? who is going to use it? no-one can possibly manually review that...

opc.three (1/3/2013)

---

Thanks, Lowell. SQLCLR is a powerful tool, to be sure. You know where I stand on the topic already but I am curious now, can the assembly you created...

for me, a VPN session just gives me an ip and DNS services on my work LAN so i can see all the servers on the lan.

so if i open...

opc.three (1/2/2013)

---

xp_readmail is for SQL Mail, which is deprecated.

In my opinion this kind of work should be done way far away from the database engine. There are many applications out...

and the same tested query via sqlcmd:

declare @cmd varchar(4000)

--sqlcmd -q "select col1,col2,col3 from table" -oc:\myfile.csv -h-1 -s","'

SELECT @cmd = 'sqlcmd.exe' --the executable...if not in the PATH variable, you might need...

ahthomas (1/2/2013)

---

I have a script that writes data to a temp table. I need to automatically export this to a csv located at a UNC destination. How do I write...

ahthomas (1/2/2013)

---

I have a script that writes data to a temp table. I need to automatically export this to a csv located at a UNC destination. How do I write...

SQLCrazyCertified (12/31/2012)

---

Hi Lowell,

I don't exactly follow all the steps you mentioned above.

Can you please provide step by step for example, I want to create a

Linkedserver from SQL to Oracle.

What...

my original link in the other article is still good, as well...

arnipetursson (12/28/2012)

---

If you have default trace records from around the time of the delete, you may be able to compile a list of suspects. Hopefully you do not too...

the key is what criteria to use to find that 1200, or whatever the number actually is;

Create table dbo.UFM_AGENTS (

TS_ID ...

your trigger needs to refer to a table, just like any other SELECT statement does;

when inside a trigger, you need to use the virtual tables INSERTED or DELETED, depending on...

i have no problem doing this in either SSMS or Visual Studio; for me it's very common for documentation and help files to be included.

you just right click on the...

I think the issue is SSMS itself tends to require higher level permissions than you'd think would be required. if you access SMO directly(like from powershell) , ddl_admin or even...

reminds me of horrors like this:

CREATE TABLE [SELECT]([SELECT] INT IDENTITY(1,1) NOT NULL PRIMARY KEY )

SELECT [SELECT].[SELECT] FROM [SELECT] WHERE [SELECT] = 1