What is the default schema of your login session in ms sql server?
- 1 Answers
- 1143 Views
- I also Faced
- E-Mail Answers
Answer Posted / Brajkishor Tiwari
"The default schema of a SQL Server login depends on how the user was created. For users created through T-SQL scripts, it's usually dbo. For users created through SQL Server Management Studio (SSMS), it's the same as the owner of the script."
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How raid can influence database performance?
When should you use an instead of trigger?
What is self contained sub query?
What is a scheduled job or what is a scheduled task?
Can one drop a column from a table?
Is it possible to have clustered index on separate drive from original table location?
Can we do dml on views?
What is sql server query analyzer?
Explain “row_number()” in sql server with an example?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to convert numeric expression data types using the cast() function?
What is the difference between for xml raw and for xml auto?
What are the source of constraints?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How do I create a trace in sql server?
