| Sql Server 2000 Interview Questions and Answers |
|
|
Hi.
I Have finished the installation of a SQL SERVER 2000. And after that, I have changed some things (hostname).
Could you help me and tell me, how can I check if everithing is all right ???
Thanks a lot !!!
Omar.
|
|
|
|
Is there a function or a systable column that will tell me the current database? Again this is for SQL Server 2000.
Cheers
|
|
|
|
I installed SQL Server 2000 on one machine and SQL Client on another machine both conected through TCP I P how i manage to connect them both ? i have a database on the server and i have tried all the options of conections and always says login failed for user.. ??'??? i need help with these step by step explanation.
|
|
|
|
Have got a database on cd which i dump on my labtop. Have tried to restore it as a new database in SQL Server 2000 but keep having a device activation error which also says i should use WITH MOVE to identify a valid location for the file. The origional database is also in SQL Server 2000. Not sure if i was able to extract it correctly on to my labtop from the cd (i used Winzip). Any ideas guys!!
|
|
|
|
I have an application role with SQL Server 2000 that is granted permission to a certain table and seemingly on random days the permission I give to that application role disappears just on one table. The application role works fine on all of the other tables.
To my knowledge there are no triggers or other stored procedures that access this table. Anyone ever have this problem, and more importantly, how do I fix it?
|
|
|
|
I want to create table in SQL Server 2000 as the page load using C# with proper attributes defined in the table while creating table.
Please suggest me if any one knows the answer.
|
|
|
|
Dynamically showing SQL server 2000 job status as started, failed, succeeded based on the job.
|
|
|
|
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?
|
|