JamesNZ (3/3/2010)

---

Out of interest, what's the advantage of saying start with 20GB and go to a max of 30GB rather than start at 0 for minimum and go to a...

It sounds like you may be having issues with either the server certificate, the firewall or the Windows 2008 User Access Control. I'm assuming, of course, that the Standard install...

I agree with sturner, you need to provide the full details for us to be able to help.

However, the error message suggest that your script is trying to drop the...

This has been the guidance in Books Online since SQL Server 2000, as Paul Randal explains here.

There is a default trace which you can look at. There is more information here, here and here.

For example, the following will give you the name of the latest...

Looks like somebody writing in a Turkic language (Turkish, Kurd?) asking for help...

The best way to determine what will work in your environment is to test thoroughly before deploying the changes to your live server.

If your preferred solution is to deploy a...

It happens to all of us. 🙂

So, did you drop and recreate the tables, or change the clustered indexes so that they were on the secondary filegroup?

Very true, if gacutil isn't in your system path (C:\Windows\System32, for example), you need to provide the full pathname. Alternatively, copy gacutil.exe to your system path.

If you are using the...

I agree with both Lynn and Tim's points.

If you choose to install SQL Server 2008 on the same server, you will need to create a separately named instance for the...

Firstly, have a look at some the existing publications on migrating from SQL2000 to SQL2008. The Microsoft Upgrade Guide and Dell Migration Guide are both good at outlining what's involved....

wannabe dba (2/5/2010)

---

I am getting the following error in the SQL error logs:

QueryInterface failed for"DTC_GET_TRANSACTION_MANAGER_EX::ITransactionDispenser": 0x8004d01c(XACT_E_CONNECTION_DOWN).

QueryInterface failed for "ITransactionDispenser":0x8004d01c(XACT_E_CONNECTION_DOWN).

this is Windows 2008 cluster box running SQL 2008. Any help is...

Congratulations!

Best response yet, IMHO.... 😉

CirquedeSQLeil (2/15/2010)

You lured me back - I couldn't resist the earlier comment. I already got the equivalent points by posting multiple times to this thread. As you have...