Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Connect to sql server management studio with specific database name

I want connect to sql server with username and password, but in this server I have over of 100 databases.

1.How can I connect to sql server and see just databases that I have owner access(filter on databases with I access them) ?

2.How can I connect to sql server with specific database name (1 of 100 database name), for example : Northwind Db.

like image 346
Ali Ahmadi Avatar asked Jul 19 '26 16:07

Ali Ahmadi


1 Answers

2/ Create a bat file with the following line of code:

ssms -S YourServerNameOrIP -d YourDbName -U UserName -P Password

or just run it in cmd

like image 199
bjnr Avatar answered Jul 22 '26 06:07

bjnr