If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
No Answer is Posted For this Question
Be the First to Post Answer
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
Explain having clause and where clause?
What are orphan records?
What is the purpose of linked server configuration in sql server?
what is mean by constraints in sql?
what are different types of raid configurations? : Sql server database administration
whats the maximum size of view state??
How can we get count of the number of records in a table?
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 will you do If the low Performance occurs?
Which are the third-party tools used in sql server and why would you use them?
What is attribute hierarchy? : sql server analysis services, ssas