I try to follow all the best practices , not just some of them.

(Troll)

Are you expecting us to do your homework ?

If you have a specific legitimate question, then maybe we can help.

If you use the wizard, you can choose to append to or delete the existing data. With linked server, manually delete the existing data first if you need to.

In general, maintenence agreements often permit you to get new releases of the product for free or greatly reduced prices.

I did a similar thing as I mentioned above. However, I did not change the system SP. I made a copy with a slightly different name and created it in...

Are there currently files in the destination folder that should have displayed with "DIR" ? Or is the folder empty ? If the folder is empty, put a test...

Yes. Apparently you will improve performace by keeping MSDB small and deleting old backup history. I don't need the t-log history which takes up the bulk of the space, so...

I use the backup history information to see growth trends, so I like keeping it. I made a copy of the system stored procedure that deletes the information, and modified...

Ray K (1/28/2010)

---

Ummm . . . NOBODY has time, much less, wants, to read a book!!!

I guarantee that everyone (myself included) is taking one look at your massive block...

Don't install SQL on their computers.

As stated above, create a login for the website application that only has the access that it needs.

It may not matter for this thread, but couldn't you change critical names to something...

FYI, Online index operations are available only in SQL Server 2005 Enterprise Edition.

Generally 2 files are created to improve performance by spreading the data onto multiple disks or arrays. Or it can be done because of space limits on a drive and...

Please tell me everything:

http://www.sqlservercentral.com/Forums/Topic852819-146-1.aspx

If the data files are all in the same file group, then no. Data could be spread among several data files.