SQL Server 2000 Interview Questions 


 

SQL Server 2000 Interview Questions
What is Virtual Directory in MS SQL Server 2000 ?
How can it be created and Maintained ?
Is the virtual directory associated with XML ?
Why using XML ?
I want to install a second instance of SQL server 2000 on the same machine(running windows server 2003) but every time i install the second instance I cannot have connection to it from any client although I can have access to it from the server itself
what should I do to make the second instance work?
should I change anything in the parameters of the instance? maybe changing the port or maybe changing the destination of the program files when installing the instance to make it different than the the default instance program files??
I have a database set up on a remote sql 2000 server and I want to duplicate the same database on another remote server for testing purposes. Is there a way to do this without manually creating the database again?
How to replicate Microsoft sql server 2000 database to remote server for high availability and failover?
Hi all!
I'm a beginner for SQL Server 2000. But, I've learned exception handling in Oracle 8i. I know the meaning of the exception handling but I can't able to write a programs in SQL Server 2000. So please tell me the simple program for exception handling. And tell me, what are all the keywords or functions to be involved.

sss

1262728Showing 406 to 420 of 410