what is the Enterprise manager(2000) and management studio
(2005)?
Answers were Sorted based on User's Feedback
Answer / maanu
Enterprise manager is a tool which comes with SQL Server 2k
and from there you can manage all the aspects of the SQL
Server 2k. But in order to write queries and T-SQL you have
to use Query Analyzer.
SQL Server Management Studio is combination of both SQL
Server Enterprise Manager + Query Analyzer of SQL 2k.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / prasad
Entere prise manager+ Query Analyzer =
Entereprise management studio
| Is This Answer Correct ? | 2 Yes | 1 No |
How to create a ddl trigger using "create trigger" statements?
Explain the truncate command? : SQL Server Architecture
What does it mean to have quoted_identifier on? What are the implications of having it off?
What is the sql case statement used for? Explain with an example?
How do I open a .db file?
What is reference section?
Explain aggregate functions?
List the different types of collation sensitivities in sql server?
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO
What is difference between after and before?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
what is a mixed extent? : Sql server administration
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)