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 |
How to provide default values to function parameters?
What are the disadvantages of using the stored procedures?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What are clustered and non-clustered index?
What do you understand by hotfixes and patches in sql server?
How do you size a resultset?
What is optimistic concurrency?
i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2
Explain the difference between clustered and non-clustered index?
What is normalization? What number of normalization shapes are there?
how many triggers you can have on a table? : Sql server database administration
How many categories of data types used by sql server?
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)