The resorece link provided is found to be useful, now ,i am able to copy login details from sql 7 to sql 2k by creating DTS package. Thank you
Hi.. I am trying to restore master of sql 7 on sql 2k. It throws error as master of earlier version cannot be restored. Can anyone guide me....
10 rows in each table. Emp_Id Amount 1 100 2 200 . . . 10 1000
Hi.. I have created 2 tables Emp_Int _Table Emp_Id int not null, Amount int Clustered index on Emp_Id Emp_Varchar_Table Emp_Id int not null, Amount...
Hi.. As all of us know that while creating Index for a Table there is Option for specifying Fill factor. This option specifies how full SQL should...
Anti virus s/w is installed and it updated regularly. Is there any link between Antivirus and SQL server not starting ? There is no anti spyware...
Thanks for quick response. SQL server is now starting, I followed the steps below to fix the error 1) Tried to execute sqlservr.exe from DOS prompt....
Hi..<br />When I tried to start SQL Server from service Manager, in the bottom of the window it displays message as "Starting..." but after couple of...
Hi.. I would like to know what is SQL Server 2000 Workload governor and it's functions ? Thanks
Thank you very much. The link provided was resourceful. Thanks
Hi all.. Recently I came across following terms , I will be grateful if someone explains the same. "Unrepeatable Reads" "Dirty Reads" "Phantom Rows"...
Thank you for useful links, now i am able to establish Log shipping. But it is working partially. If i view the Log shipping pair properties it...
Kindly share details of prerequisites for setting Log shipping in SQL 2000. I am facing problem when connecting to Destination server as "Connection...
Hi.. Follwoing link explains the level of knowledge required for various levels. http://www.dyessconsulting.com/E-Books/InterviewBook/home.html...
Separate names with a comma.
