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.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With