Hi, we've noticed anomalies on our development servers ie: dropped servers. Could be accidental ie: from code. We cannot control physical access to the database server room 24/7. Developers need...

Hi, are you able to create a trigger on a system table? I tried and keep getting an error ... "Error 229 CREATE TRIGGER PERMISSION denied" ... and I'm in as...

Noel/Yelena,

Great! Works like a charm. Had some challenges with refreshing the alert in EM re:"all databases" vs a single db.

Any idea what the number would be for a successful...

Hi barsuk,

I want to capture ad-hoc db backups being performed by other users ie: have an alert emailed to me when this is done re: to monitor disk capacity and...

Hi, great ideas. Yelena - Do you think you could post the script or send email, i would greatly appreaciate it? Is it vb or  tsql?

Hi,

many thanks to all.

dcpeterson - this is exactly what I was looking for. I look forward to your future articles. When the time comes, I'd be appreciative if you could...

Hi,

We're a Canadian company using RedGate's SQL Bundle Suite (ie: SQLCompare ..) and have been VERY happy with the product, support service and cost. This isn't an answer to your backup...

Hi Brian,

I've peformed some initial analysis using the ApexSQLEdit tool. In your experience using this tool, is there a functionality similar to MS EM and Access that allows "Show table(s)" ......

Thanks for the sugeestions.

Steve - any insight into if these issues will be alleviated with MSSQL 2005?

Hi, I used th datatype "money" to display commas ... but would like to chop off the decimals ... not sure if i can use variable in xp_sendmail in @query line?

here is the...

Hi ... it worked, but the file had to be locally. It didn't like using the Network ...

great. 

Works like a charm!!

Hi, yes ...

For example:

looking at the Temp db (tempdb.mdf):

* Dos Dir Cmd = 1,106,182,144

* MS Win Explorer = 1080256 kb

* exec sp_helpfile = 982016

no