I'm not aware of connection rejections as a concept. SQL Server might terminate a connection on a fatal error, but otherwise it is the client that terminates connections.

Have you enabled PAE?

That should allow you more RAM, but I'm not sure if it will get the entire 64. The 4GB limit is a fundamental limit of 32 bit...

Is DTC running on both computers? Not sure if it's needed here, but it helps to control transactions across two computers, and you are starting a transaction in the linked...

Please suggest what? You haven't asked a question.

If you have a table you want to partition, you need to learn how to partition. There are articles on this site...

You typically use an insert..select to insert and in that case, you can specify the columns. If you look in Books Online, you will see examples for the insert statement.

As...

Dropping and recreating should give it a new ID, as well as change the versioning. IF there is substantial data in the object, that can take time.

Renaming just changes...

Note that SQL Server will not automatically move data to this file unless it is in the same filegroup.. The default filegroup will still likely be your mdf.

SQL will not...

SQL Server's endpoints are using TDS, HTTP, or SOAP.

If you want to receive some other format, you'll have to write a receiver that takes the data and inserts it into...

Are you moving on the same server or to a new server?

In either case, Gail's #2 will have the least downtime. You can keep taking logs and moving them, getting...

You might need to rewrite the trigger. That error cannot magically go away, you need to write sub-queries that do not return more than one value.

If you need help,...

perhaps not an apology, a thank you.

I would agree that Open Source tools can respond quicker, and changes can be made. However it's a double edged sword, as Jeff pointed out. Often there are people that...

Please use full sentences and periods so we can understand each other. It's hard when you run all your typing together.

Can you connect to the Vista SQL Server from the...

Not a bad apology. There's hope.

You cannot restore master to another version. even another patch level can be asking for problems. Master contains version and instance specific information. You must restore to another 2000 instance.

As...