Hi, The remote login which you are using should exist on both servers. Regards, Anil Kumar
HI All, I have a query which will need to run all our production environments daily so I planning to run the query from a central location. Could...
Not sure, but I am using this method since a year in my environment and didn't face any issues yet. Thanks Regards, Anil Kumar
If I understood correctly, you have created SP and able to send the email but wanted to schedule it correct? Create a job in SQL Server which will...
Right click on SQL Server resource and add the disk as dependency. http://support.microsoft.com/kb/295732 Regards, Anil Kumar
Hi, We faced siminilar issue recently. Without knowing the fact that cluster admin account need to be added to SQL Server, we have deleted...
Here are the errors in the log.<br /><br />******* Got commit request from MSI *******<br />Complete: InstallDTSAction at: 2007/0/9 10:35:31,...
Yes. Before starting the installation I have added this domain account to local admin group. Thanks Anil Kumar
Hi All, I am trying to install SQL 2005 standerd edition on one of my server with domain account as start up account . I tried nearly 10 times but...
Hi All, I'm working on setting up replication on a database in SQL 2000 and get the following error: Implicit conversion from data type text to...
hi thanks 4 responce could u be more specific how to do that plz. Even an overview of the script would be of great help!!!! Regards, Anil Kumar
Sorry for that. I didn't see the scetion. When I opened link which already in my favorates, it opened this section and in a hurry I just posted...
Hi All, I wan to manipulate string values to protect the identity of the original value. For example I have column which contain Names. I need to...
In your given link LOCK_TIMEOUT option also mentioned. I want to know LOCK_TIMEOUT is set at server level or application level? Regards, Anil Kumar
Hi All, Need a help from you!!! I am facing some blocking issues with my production database so I am planning to implement LOCK_TIMEOUT option. My...
Thanks for looking into it!!! We are just using sp_updatestats as we don't have proper experience at UPDATE STATISTICS .......WITH FULLSCAN....
Hi All, We are having performance issues in our production server. Billing query usally take 1 Hr to execute but it's taking nearly 4 Hrs in these...
Hemant, Here we will increase RAM first and then install another instance. Will performanc still be an issue? Satya, Should we need to increase...
Hi All, Here I want some focus on multiple instance concept. We have some applications launched on one server. Another new application likely to be...
If authentication is mixed. Try by changing the data source properties. Change to use SQL Server authentication and specify a database user. It...
Separate names with a comma.
