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...
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...
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, 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 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
Hi, A background process was terminated by running kill process. But soon it was noticed that the process started rollback. It is showing rollback...
Can you please let me know what are best Third party tools for data warehousing ? Regards Riya
Hi, I am new to data warehousing & data mining. Can somebody please explain both of these & also their differences? Also please let me know what...
Hi, Can I copy a file from one machine to another in the same network using SQL job? I have tried creating a job with "Operating SystemCommand (Cmd...
Hi, My SQL Server shuts down automatically once in 3 days. SQL server was re-installed recently. After this re-installation, we have noticed this...
Can IIS & SQL be on the same server? Regards Riya Riya
Hi, I am facing following error in errorlog, when checked when the memory of SQL server was more than 1 GB This SQL Server has been optimized for 8...
Hi, Can I exclude delete in SQL replication? Please tell me how.... Regards, Riya
Separate names with a comma.
