Just to add on what Peterson and Aaron said.

Be careful when you change the ownership of the database. The user who is the current owner would loose acces to...

Right click on the Servername in enterprise manager. Click on properties. Select the Security tab and select the radio button Sql server and windows instead of Windows only. I can't post screen...

If you already have another account with admin privilige, you can add that account to sql server and grant it sysadmin privilige. And then remove the builtin\admin group. You can then...

"With AWE turn on the second instance will try using 5 GB for a total of 10 GB. 2 GB short which will cause the server to use page file...

The default isolation level is READ COMMITTED. Also from BOL.

Only one of the options can be set at a time, and it remains set for that connection until it is...

When you access a cluster, you make a connection to the virtual server.  Say below is a connection string

cn.open "driver={SQL Server};Server=Server_name;uid=user;pwd=;"

The only thing changes is that if it is a...

You don't have to hold all the data in temporary tables. You can create an ActiveX script with DTS where you can process one row at a time.

From books online.

BEGIN TRANSACTION starts a local transaction. The local transaction is escalated to a distributed transaction if the following actions are performed before it is committed or rolled back:...

This should not affect the transaction log backups to fail. sa is a member of sysadmin group and he has permissions to all the database. You might want to take a...

It seems that you might have had some IO issues. the cluster log might have some information of what triggered the failover. It might be difficult to post here but...

Below is the closest article i found.

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

I have my test server on 8.00.878 and the issue is fixed on that one. The rest of the servers are on 8.00.818...

check this out.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=168848

You can use the procedure below. It will create different text files for each and every table. Create the procedure in master database and then just pass in the database name...

I remember this to be a post sp3 bug where jobs could not run under windows account but i couldnot find the fix for it. i will post it if i find...

Try to re-start your server after resetting the status. If that doesn't work, you can bcp all the data out of the database and then create a new database and...