Connecting to a Database without Entering Parameters Every time from SSMS

Profil de Dinesh Asanka.:: Dinesh Asanka ::.BlogListesSkyDrive

< Précédente Suivante >

30 octobre

Connecting to a Database without Entering Parameters Every time from SSMS

If you are using SSMS regularly, you know that you have supply database name every time. You can avoid this by supplying a default database for a user. However this is not recommended because in case that database is dropped or renamed, user will not be able to login to SQL Server and will receive this error.

Cannot open user default database. Login failed.
Login failed for user 'sa'. (Microsoft SQL Server, Error: 4064)

SQL Server Management Studio is executed from a exe called SSMS which resides by default at "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

For this you can supply server name and database name as following.

"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" -S Dinesh-PC -D AdventureWorks2008

You can create a short cut with above values and when ever you click the short cut SSMS will database as AdventureWorks2008. However, problem with this is that, Object Explorer will not load objects unless you use conventional connect dialog box.

17:15 | Ajouter au blog | SQL Server Experience

Commentaires (1)

Pour ajouter un commentaire, connectez-vous avec votre identifiant Windows Live ID (si vous utilisez Messenger ou Xbox LIVE, vous avez un identifiant Windows Live ID). Connectez-vous

Vous n'avez pas d'identifiant Windows Live ID ? Inscrivez-vous

Aucun noma écrit :

http://www.supplyreplicabags.com Replica Bags/Handbags- Louis Vuitton Replica Bags, Chanel Replica Bags, GUCCI Replica Bags, Hermes Handbags
http://www.cshiny.com Replica Louis Vuitton Handbags, Replica Chanel Handbags, Replica Guccci Handbags, Tiffany Jewelry, Replica Designer Jewelry
http://www.cshiny.com/Handbags/Louis-Vuitton/index.asp Louis Vuitton Replica Designer Handbags, Replica Designer Handbags
http://www.cshiny.com/Handbags/Chanel/index.asp Chanel Replica Designer Handbags, Replica Designer Handbags
http://www.cshiny.com/Handbags/Gucci/index.asp Gucci Replica Designer Handbags, Replica Designer Handbags
http://www.cshiny.com/Handbags/Chloe/index.asp Chloe Replica Designer Handbags, Replica Designer Handbags
http://www.cshiny.com/Jewelry/index.asp Replica Designer Jewelry,Replica Jewelry wholesale
http://www.cshiny.com/Handbags/Dolce--Gabbana/index.asp Dolce & Gabbana Replica Designer Handbags
http://www.cshiny.com/Handbags/Mulberry/index.asp Mulberry Replica Designer Handbags
http://www.handbag001.com 2009 Classic Handbags Wholesale, OEM production of Bags, New Arrivals Handbags - Discount Handbags Wholesale
http://www.handmaderolex.com Rolex Replica, Replica Rolex Watch, Fake Rolex, Rolex Replica Watches
http://www.9icon.com Wholesale Replica Handbags,Replica Gucci,Replica Chanel,Replica Christian Louboutin,Replica Louis Vuitton
http://www.9icon.com/Productlist.html?CatID=200221106 replica LOUIS VUITTON
http://www.9icon.com/Productlist.html?CatID=200221077 replica CHANEL
http://www.9icon.com/Productlist.html?CatID=200221042 replica GUCCI
http://www.9icon.com/Productlist.html?CatID=200221224 replica travel & business
http://www.mlbnfljersey.com Buy cheap NFL Jerseys, cheap MLB Jerseys, cheap NHL Jerseys, cheap NBA Jerseys - Jerseys Wholesale
http://stilere.com/index.php?cPath=17_66 jimmy choo
http://stilere.com/index.php?cPath=17_30 manolo blahnik
http://stilere.com/index.php?cPath=17_68 alexander mcqueen
http://stilere.com high heels wholesale

Il y a 2 jours

Rétroliens

L'URL de rétrolien de ce billet est :

http://dineshasanka.spaces.live.com/blog/cns!22A79FCE82651673!946.trak

Blogs Web qui font référence à ce billet

Aucune