You can use versioning on stored procedures by suffixing the procedure with ;n where n is the version.

Look in Books Online for "CREATE PROCEDURE (Transact-SQL)".

Just a follow up from another topic, here is a link to a Microsoft KB article that will help to accurately size your pagefile, rather than use a generic value.

http://support.microsoft.com/kb/889654

Perchance, would the drive contain folders with a strange naming convention such as 48e386c5badf38bfb1 ? And would drive E be the largest drive on the system?

As regards pagefile size, I...

Good questions:

1.You can can certainly put the pagefile on the system drive, however this is not best practice, you should put it on another permanent drive on the server. It...

You only run MSDTC on one machine, it handles things for the whole cluster, so there is no need to try and get it to start up on the other...

The biggest thing is to weigh up the benefits of including the index versus the overhead of maintaining those indexes during inserts, updates and deletes.

Don't implement blindly, get a baseline...

Have been very happy with 1and1.com

Not even going to plug and do the whole "sign up someone else" thing. Take a look though.

Guessing that the disk size is in GB, would that be correct?

And you don't see any files - hidden, system or otherwise?

The low virtual memory is another issue entirely, what...

Take a look at sp_executesql within Books Online. You can build a dynamic string and then execute that to get results.

Why not just restore the database rather than try to compare schema and data?

The not enough storage issue is because you are attempting to, I guess, restore the database to...

Have you tried the following---

open SQL Server Configuration Manager --> SQL Server 2005 Network Configuration -->Protocols for (whichever instance) --> right click on TCP/IP and go to Properties.

In the protocol...

Backup the database as normal.

Restore the database, changing the name, and using a WITH MOVE for the data and log files so that they are in another directory (or under...

You can actually use a SQL extended procedure to check the existence of a file, folder or parent folder.

The following code should give you a good place to start

create table...

You could always backup directly to the remote location, but I wouldn't recommend it.

So far as I can tell you have the best method for taking care of it. The...

There's really no need to failover. Were you able to look for hidden or system files on the drive?

Perhaps one of your NT admins could take a look and see...