As far as identifying application dependencies go, one technique is to run SQL server profiler while the application is being used (It's resource intensive, so ideally you'd want to...

It's of course risky... but if only the log is corrupted then detaching the db then do a attach single file db *should* work. I'm not saying that you should...

for the projects i worked on the filestream data was a huge win. I reaaaallly want to start messing around with spatial data, but so far i haven't had a...

I'm having this problem with one of my LCS tables, dbo.HomeResourcePermission. It's in my rtc database, which was migrated from sql 2000 to 2005, but is still running in sql...

you need to make sure the mail profile is enabled in the SQL server agent properties.

right click SQL server agent -> 'properties'

select 'Alert system' then check 'Enable mail profile' under 'mail session'...

you can check the error logs for database mail in 'SQL Server Agent' -> 'Error Logs' . when the log file viewer opens up, select 'database mail'. There should be an...

Sorry for not responding sooner Shah,

you can create the vbscript in a normal text editor and give it the extension '.vbs'. Windows recognizes this extension and you can execute it...

I think your example won't be wrong. Also it's not like if you enable an option, it's enabled for good and you can't change it; you can go back and...

The first thing that comes to mind (after recovery options) is maybe a scheduled script that checks the service state, send an e-mail if stopped. something like:

strComputer = "."

Set objWMIService...