-- kill all connections to MyDatabase first, then run

use master

alter database [MyDatabase] set allow_snapshot_isolation on

alter database [MyDatabase] set read_committed_snapshot on

Before changing this and hoping that you get no...

$nameoffile = 'myname' + getdate() this way the file be unique.

Make sure the fully qualified name is being used i.e SQLSERVERNAME.DOMAIN Check with DNS people what they set it as and try IP instead. Make sure SQL is set...

Few things that you can do if brand new. Get a list of all the configurations, server, sql the memory settings, the database locations where disks are stored..Think of...

I had this once where it would remain as Red x that it didn't run but it had run. I ended up just adding a new job and deleting...

If you can go straight to SQL 2008 and Windows 2008 there are wizards making your life simple.

The Disks have to be setup first for Cluster part of SQL and...

how do you do back door..to get sa pwd..i got a few copies of SQL on laptop but i forgot sa ...

so i can't get in....i was just going to...

Can you connect to SQL using SQLCMD you could then execute the memory change setting.

Thanks Mark

The SQL Idera is per 5 minutes not every sql statement. Is there a way to make this every statement.

Quest for SQL is the boom. expensive though

Basically the SAN guys can give you some guidelines to follow. Or try DELL / EMC website.

If you have a SAN there are some tools on here for measuring...

Mark the record.value('(./Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]', 'int') AS the path is this a specific path somewhere. Did you set this up in master or just any "DBSYSTEMDB"

Cheers

Click on the DAIL MAIL in SQL STUDIO and put the email server parameters in it.

Yes that was great and i appreciated it. Got my program running Friday made my weekend.

Cheers for sharing.............

If more than 23 in the string or less i should use len too