VIEW SERVER STATE Permission is the way to GO.

you can use the select * into tablename_backup from tablename will give you a copy of the original table.

GilaMonster (5/4/2010)

---

Maninder S. (5/4/2010)

---

Also Pl do check that your jobs do not OVERLAP.. i.e schedule them at diff times.. e.g : if you do a full backup of all the...

Jason P. Burnett (5/4/2010)

---

Maninder S. (5/4/2010)

---

Also Pl do check that your jobs do not OVERLAP.. i.e schedule them at diff times.. e.g : if you do a full backup of...

Also Pl do check that your jobs do not OVERLAP.. i.e schedule them at diff times.. e.g : if you do a full backup of all the databases at let...

just Change your current Maintenance Plan to include the Differential backups and Trans Backups and you should be good.

Do not worry the initial size of the Trans Log "might" be...

Can you Skip over the Flat File process and directly load from XML to SQL Tables using OPENXML.

Is BizTalk passing one record at a Time or All at once.

Also include...

If this DB is a critical database, then:

Daily Full Backups / 4 hour Differential Backup / 30 min Transaction Log Backup

If the database is very Critical and heavy Transactional then:

Daily...

checkout this solution:

http://www.dbanation.com/?tag=collation

Thats always going to be a issue with NT ID. Best Practice is to create a SQL user for ODBC and specify it inside the .dsn file.

do the normal shrink file process, then goto DB properties and change the mdf (data file) size to 60GB from 130GB.

This will take care of releasing the extra space that...

I agree with Grant.

But if you are still inclined to develop the system, you can use SQL Profiler to Capture certain Queries based on events and conditions. Read more SQL...

Sorry for this info, but this is not a reversible process as far as i know. you will not be able to see the text inside the encrypted SP..

Asyn.. database mirroring is supported only by SQL Server 2005 Enterprise Edition..

Partner can be STD editions or ENT edition

The performance or the user stats will be with the service provider.

If your plans are to go with SQL Azure, then read material on their site.

Good this about SAAS...