I finally had all my issues resolved with SQL 2005 on a Windows 2008 Cluster.

There were several issues:

1) Issues with SSPI handshakes when the service account was...

I finally had all my issues resolved with SQL 2005 on a Windows 2008 Cluster.

There were several issues:

1) Issues with SSPI handshakes when the service account was...

Not sure what you mean about support for RC0 we are installing SQL 2005 EE x64 on a Windows 2008 EE cluster....

More trials and tribulations...

After installing 2005 EE x64 (again)...

I think I may have an idea on why SP3 has not been released yet. I was installing a SQL 2005 Enterprise Edition x64 on a Windows 2008 Enterprise Edition...

I just installed my first SQL Server 2005 x64 Enterprise Edition virtual server on a Windows 2008 Enterprise Edition Cluster. It is basically the same install as on Windows 2003....

Can you please show me where Microsoft has had mainstream support for three or more service packs at one time?

http://support.microsoft.com/gp/lifeselectindex#S

Microsoft will only support 2 service packs at one time. They are not ready to pull SP1 from mainstream support yet.

Farrell,

I found a good link which might help you.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_73u6.asp

Use the query governor cost limit option to specify an upper limit for the time in which a query...

Had a similar event happen where there was something wrong with the heartbeat nic(s) and node2 would think node1 was dead so it would fail over.

1) Make sure you can see your network (Ex. Ping a server)

2) Try to create an ODBC connection  to a SQL Server on the network and test it.

3) Check the...

I personally would advise you into reading the SQL Bible by Alex Kriegel. It covers more than the standard "Microsoft" covered material. It encompases Microsoft, Oracle, DB2, Sybase and some...

Sounds like there is either a relationship or constraint set up within the ACT database.

You either turn off the relationship or add an identity column and use the enable identity...

Create two tables one vertical, one horizontal. insert the next min subid in the horizontal table, flag it in the vertical table and then delete it from the vertical table....and...

Never heard of that where it would build a new .ldf file for you.

If you are set to simple recovery just back it up and then shrink the ldf to...

1) Detatch the database(s)

2) Copy mdf & ldf files you your new drive(s)

3) Attach the databases(s)