How to transfer Logins from SQL Server 2000 to 2005
Answers were Sorted based on User's Feedback
Answer / ravi
we have to run the microsoft standard script or use stored
procedures if less logins are there try to create..........
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sandeep
Taking backup and restore of the system database
| Is This Answer Correct ? | 0 Yes | 3 No |
What is the library index called?
How to delete an existing row with delete statements in ms sql server?
What are the basic functions for master, msdb, model, tempdb databases?
What is a result set object returned by mssql_query()?
Can a synonym name of a table be used instead of a table name in a select statement?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
What will you do If the low Performance occurs?
what is a traditional network library for sql servers? : Sql server database administration
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What is an index in sql?
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500
What do you understand by triggers?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)