How to open sql server management studio by using sql server authenticaion by using vba

Hi,

Maybe
 

Sub Open_ModScript()
     Dim rc
        rc = Shell("ssms.exe -S CHNMCT123456D -d sample -U theUser -P thePW")
 End Sub

Select allOpen in new window

Regards

Hi,

That code is not working.  I replaced theuser as username, the PW as password. But ssms show dialog box which contain usage.

and with
-noSplash

it shows

ssms.exe [-S servername[\instance_name]][-d database][-U user] [-p password] [-E] [-nosplash] [file_name[,file_name]*][-log [file_name]?][?]


and gives meaning from -s to.....[?]

HI Rgonzo1971,

I am new for this VB macros. If you give code , i will check it.

Didn't quite understand

in the above code i replaced my server name, database name, userid and password of the server. But it should not work. Sql server management studio shows a dialog box of usage. The usage box contain below code as,

"ssms.exe [-S servername[\instance_name]][-d database][-U user] [-p password] [-E] [-nosplash] [file_name[,file_name]*][-log [file_name]?][?]

[-S the name of the sql server instance to connect to]
...............
..............
[?] displays this usage information"

But the SSMS is not opening automatically by run this vb

Sorry can't help further

Hello Rgonzo1971,

Do you know how to import xlcsv file into sql server by using VB?

Nope

Ok

Thank You

Just tested with SSMS 2016 from the cmdline, and it works for me as expected. Even if the DB is wrong (does not exist), SSMS opens up with a connected query window.

Hi Qlemo,

How to upload xlcsv file in SSMS by using VB?