the script was originally written for SLq2000;

it's using the old sysobjects instead of sys.tables

now, objects are by schema, not by userr;

so the offending code is here:

set @tableListSQL = 'use ['...

you need a Calendar table of some sort which gives you the arraay of all possible months;

from that you change your query to select from that table, and join to...

wendy we need some examples, i think;

splitting the name based on some character is easy; PARSENAME or the famous DelimitedSplit8K are two examples that come to mind;

but unless there is...

a little of both, i think.

From a SQL server standpoint,

SQL server passwords are inherently less secure than Windows authentication; you can use a brute...

thinking outside the box, i think you could create a script that adds users to a role that removes backup permissions,

on a per database level,

ie DENY BACKUP...

yeah DBCC commands are not DDL Events; you can do it in a trace or event notification, though;

same thing happens when someone RESTORES a database...you cannot capture the RESTORE in...

I just checked, and it does show up in my default trace

here's my query i use to get to the trace data:

/*

--Results

EventClassDescrip EventSubClassDescrip trace_event_id...

Roland Alexander STL (1/3/2013)

---

twahl0630 (1/3/2013)

---

Low hanging fruit would be to get rid of those OR's and UNION ALL a separate SELECT for each one. Also if there is any chance...

Mozilla Thunderbird, EditPlus and even Notepad++ as well as LOTS of other applciations all do the same thing when they encounter text that looks like an url or email, so...

Yeah that's a feature of Outlook, not something that has anything to do with the code you generate; it finds strings with an @ in them, and converts them to...

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