ya ok thanks

i am using standalone system in that role assignment i want create new role assignment domain\user name so in this which user name i want to use..

i...

What is the main use of creating role in sql server 2008

my question is

print @@version means u get d current version

so how to find d next version of my current version in sql server

is thr any query available in sql...

ya i got this

this will show the short order of sql server

http://sqlserverbuilds.blogspot.com/

no no shortorder only

my MD ask me

what is current version&shortorder in sql server??

and how to find that

ya ok Thanks..but i want to do like that way only the solution..

shall u plz tell me how to do object level permission in sql server 2008

no no i want to do in single schema only..

my client want to use this 1 schema if i separate this into 2 schema means they cant understand this

so...

ya OK..now having another scenario

please solve this problem for me

http://www.sqlservercentral.com/Forums/Topic1189660-391-1.aspx

ya very thanks i got that

HI,

i create new username in that new login window..

in that server roles page i choose pubilc means when i disconnect old user logon and again connect with new username means...

how to disable guest in another db..if i try to delete that it will show error

i cant choose that option (guest account)its in disappearance in that window page

ya i tried this..but when i used that username for connect sql server 2008 it will access all the db

ya very thanks i got

ya i got that ans..thanks for u rreply