I am aware that 194 indicates no SP. But why doesn't it allow me to install SP3? Regards Riya
While installing SQL SP3, it gives error " You have a newer version of Service Pack. Setup will now exit" Then on installing SP4, the installation...
We have a Single Processor (HT enabled processor) for SQL database. On performance monitoring, SQL utilises only 50% of the processor(never goes...
Yes whenever I click on the OK button for restore it gives that error. Regards Riya
Hi, It is possible. I have tried this scenario on another machine. It gets restored. Let put my problem in right words... "The backed up database...
Can I restore a backup of a database from SQL 2005 (Beta version) to SQL 2000 I am getting error no. 3169 Regards Riya Riya
Hi, I am in process of testing Reporting Services in SQL 2005. I have installed Beta version of SQL 2005. OS is win 2003. I am creating the report...
We want to recomend client to continue using SQL 7 or should they switch to SQL2000 Regards Riya
Hi Ranjit, We are facing memory problem in SQL 2000. Is this what u want to say? Can u explain? Hi Hemant, We not running any other application on...
Hi I am having a Win 2003 machine on which SQL 2000 Ent Edition os installed. The problem is that I am not able to telnet its own IP on port 1433....
Hi, It has been observed that there is huge difference in memory utilisation with SQL 2000 & SQL 7.0. The hardware configuration of the server is...
Hi all, The said problem was resolved by installing sp4.Now all the tools are working fine. Regards Riya
Hi Dinesh, Your solution says..... RESOLUTION To resolve this problem: 1. Ignore the message in the Symptoms section and click OK to start MMC. 2....
Hi, I have installed SQL 2000 Enterprise Edition. I am able to use Query analyser, Profiler etc. But Enterprise manager gives the following error...
Hi, I was successful in changing the name of default instance. 1. Renamed the server 2. sp_dropserver 'old servername' 3. sp_addserver 'new...
Hi I am facing a problem in restoration. It says "Please restore in single user mode". Please let me know if anyone has faced this problem & fixed...
Hi I have to, for some reason change the name of the server on which SQL default instance is installed. What will be the impact of this name change...
Hi, I want to attach a databse in SQL 7. I can do it using sp_attach_db. But is there an "attach-detach" option in the enterprise manager in SQL 7....
Hi, We are trying replication for our disaster recovery project. we r using transactional replication. The snapshot job was run successfully.The log...
Hi Please give some information on 4-node active/active clustering in SAN.... Regards Riya
Separate names with a comma.
