We have a newly built cluster environment and there is a dedicated disk for the tempdb. Unfortunately, after the setup, I forgot to put tempdb in...
We have a 3 node cluster..Lets say, the names of nodes are A, B and C We have 2 instances running Inst1 and Inst2 on these nodes..Both are SQL Server...
Friends, I am trying to update SQL Server 2008 CU7 on a 2 node cluster which has 6 instances running on it. When I try to extract the CU7...
Hi All, we have a 2 node cluster for SQL Server 2005. when we are trying to move the entire group to the other node, its going offline and within a...
Hi All, We have a production database with lot of tables in it.May be around 400+ tables. There was no issues till yesterday. I actually want to...
To give you some background we are trying to do the below scenario and are not successful. Please try the same and let us know any issues you see...
Hi All, I need to install SQL Server evaluation edition 2005 on my machine.. It will be valid for 6 months. I have heard that after 6 months, if I...
We have a server where transactional replication is setup. The publisher database log file is growing nearly 10 GB everyday. The drive has got very...
Hi All, I am getting an error when I am trying to install SQL Server 2000.. I am using the login with Domain admin as well as local admin rights.. I...
Hi, We have a setup with transactional replication..The databases are in full recovery mode.. Can we have DB's in simple recovery mode in...
Hi, We have one of the databases on SQL Server 2005 Enterprise edition. Its around 500 GB and is configured for mirroring as well as log...
Hi all, Please help me to upgrade an existing instance of SQL Server standard edition 2005 to SQL Server enterprise edition 2005. FYI, standard...
I am getting this error very often. "SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection" At this...
Friends, We are not able to install SP4 on SQL Server 7.0 After we start the setup, we proceed with 2 steps and at the step where it shows as...
We have a customer server where we have installed SQL Server 2005 with SP2. As a part of value addition, we would like to apply some hotfixes. Is...
Hi all, We have a problem in MSDE. morning, SQL was in the stopped state.we tried to restart it but no luck.finally, we had to reboot the machine and...
We have installed SQL Server 2005 with SP2 on one of the servers in cluster Environment.. We are getting errord when we try to create a differential...
I am unable to drop a user in a Database. The name of the user is 'HPOV' When I try to delete it, I am getting an error message like "Drop failed...
Hi Friends, Please help me to create a linked server between SQL Server 2005 and oracle
I am getting the following error message in the log file. Seems like some permission issue. Please let me know if any permission is missing...
Separate names with a comma.