Wednesday, 24 October 2012

How to set the daefault database in sql server 2008?

steps to set default database

when you open ssms,
1.Go to object exploreer
2.go to security tab,
3.expand that logins tab will appear
4.in logins tab you will find some users
5.Right click on that,go to properties
6.set the default database option                         

No comments:

Post a Comment