March 4, 2010 at 5:52 pm
How to check my current schema that im staying right now
March 4, 2010 at 6:01 pm
masterpiecebeta2 (3/4/2010)
How to check my current schema that im staying right now
Not sure what you mean.
Could you clarify what it is you are trying to find out?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 4, 2010 at 6:12 pm
I just want to check the existing schemas inside the sql server 2005
March 4, 2010 at 6:20 pm
If you are referring to Users then check out this link
http://msdn.microsoft.com/en-us/library/ms190387.aspx
if you are looking for a way to compare database structure (schema) between two different servers, then check out RedGate SQL Compare
If you just want to look at the Database Structure for a specific database, then you can browse the structure through SQL Server Management Studio.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 5, 2010 at 2:36 am
use select schema_name()
this script will show your default schema for the login used in the respective DB selected.
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
March 5, 2010 at 10:32 am
That rocks:-D
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply