Hi guys I am having problems with installing components on the 2nd node, I get the message "No common components have been installed. To add a...
Hi guys, I just want to confirm SQL Server can be installed with a virtual name on a standalone server right? I've been away on holiday for too long...
Hi Guys Where can I find a good read on how to install SQL Server on a newly added cluster node in a four node cluster three active one passive,...
Hi guys I'm having a dilemma as to how I can extract only non-clusterd indexes from a database. Can anyone help me here because I know I can...
Hi guys I haven't done this in years and can't remember how to anymore. Can you be so kind as to let me know how I can separate indexes to another...
Hi guys I'm having trouble changing the SQL Server service account because at the moment I don't know how to get SQL Server back online after I...
Hi guys I have an issue here, I'm unable to see the data inserting into a table in the backend and the logs reports that the insert was successful...
Hi all Does anyone know a simple way to generate the above event ids 103 and 322 from SQL Server to application event logs?
Hi all I get the following error Executed as user: 'service account'. Could not find stored procedure 'up_stored_procedure'. [SQLSTATE 42000] (Error...
Hi all I'm able to create a job to refresh test1,test2 and test3 databases with testA,testB and testC databases by taking a backup of A,B and C and...
Hi all I will like to recreate the above event id for monitoring of sql server but having trouble recreating them. Can anybody help with ways to...
Hi guys Does anyone know where I can find a good disaster recovery document for SQL Server cluster? Thanks
I am short of ideas now so I need help. The scenario is that I've got a 2 node cluster A/P running SQL 2KSP4 on Win2k3 that has an application that...
I'm having trouble with executing a DTS package both as a job or by executing the package via DTS, I get the following error below. Can someone...
Hi All, Is there a script that can be executed to drop all constraints in a database? I'm trying to drop specific tables but I need to drop all the...
Hi all, I'm getting the following error below from my secondary server and the only process that fails intermitently so far is the copy process on...
What rights does a user need to have to be able to run SQL Profiler or is it only a user with sys admin rights that can run profiler? Any response...
Hi All, I'm getting the error below in my event logs and I don't know how to get rid of it. Can anyone help me out here? Schedule and Delivery...
Hi, When I schedule a DTS package as a job it fails but when I run it manually it succeeds. The job owner is sa but the DTS package owner belongs to...
Hi guys, I got the following error below after changing sql server service account on a sql server running analysis services. Executed as user:...
Separate names with a comma.
