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...
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 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...
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...
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...
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...
Hi All,<br /><br />In one of my instance, I am facing with the below situation.<br /><br />The application is trying to create the Trust databases,...
Hi All, I have configured report services and created a project to generate reports. I am able to generate reports on the server where I had...
Hi All, We have installed sql 2005 standard edition on one of our test servers. Now we want to remove it from the server. Could any one guide how...
Hi All, We have a database which is growing tremendously. We ran into space isues. So we thought to put the recovery model to Simple for time being....
Hi All, We are planning to upgrade one of our sql server to SP4. Is there a way to uninstall SP4 if it's found it breaks an application? Your...
Hi All, I have some databases rapidly growing day by day !!! Now those databases size is around 140 GB's. I am facing some performance issues so we...
Hi, Good day!!! Can I get sql statement of particular spid after process is over and no longer available in current activity. We had some locking...
Dear Experts, One of my production SQL Server2000 Database crashed due to unknown reasons. I don't have SQL Server agent backups for this database....
Hi All, We have recently migrated some databases to new server. Next day we got to know there is some conflicts in database collation. According to...
I want to make sure "Is anybody enabled AWE on windows sp1 plat form"? or Is it possible to do? or AWE enable is independent of windows service pack?...
Hello All, According to the Schedule the Performance counters will fire every Wednesday and the Job fired at Scheduled time successfully but the log...
We have created Performance Monitor logs on our server. And scheduled for every alternative days. It had failed first time and I have checked...
Hi, We are planning to replace our production server. So we had taken two servers one is stageing and another is production (Both are of same...
Separate names with a comma.
