What is the default schema of your login session in ms sql server?



What is the default schema of your login session in ms sql server?..

Answer / 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

More SQL Server Interview Questions

In which year relase the 7.0& 2000 & 2005?

1 Answers  


What is difference between Datepart() and Datename() in SqlServer?

1 Answers   Infosys,


How to use copy and concatenate commands in SQL?

1 Answers   Amdocs,


What is the purpose of the tempdb database?

1 Answers  


How to define output parameters in stored procedures?

1 Answers  


What is Pointer ?

3 Answers   Cap Gemini, CarrizalSoft Technologies,


How to generate create function script on an existing function?

1 Answers  


What are .mdf files?

1 Answers  


What is the command used to check locks in microsoft sql server?

1 Answers  


whate is advantages of sql server 2000

0 Answers  


wht is normalization?can u explain me in detail?

9 Answers   TCS,


What is self join in sql server joins?

1 Answers  


Categories