sqsh SQL Server 2005 execute *.sql file

Question

I would to drop remote SQL Server db via sqsh but, I don't know how does it works. I can connect to sql server with command:

sqsh -Ulogin -Ppass -Smssql2005

score 0 · Answer 1 · answered Jun 19 '13 at 21:07

0

Maybe you are using the wrong tool to connect to MS SQL Server. If you are looking to connect to MS SQL Server then you can use this code:

SQLCMD -S servername -U username -P password
OR
SQLCMD -S servername -E

answered Jun 19 '13 at 21:07

PollusB

1,726
2
22
31

score 0 · Answer 2 · answered Aug 19 '15 at 00:28

0

The -C argument lets you specify a query to send to the SQL Server instance.

So, I think this will do what you want:

sqsh -Ulogin -Ppass -Smssql2005 -C"DROP DATABASE MyDatabase"

answered Aug 19 '15 at 00:28

bonh

2,863
2
33
37

score 0 · Answer 3 · answered Nov 22 '11 at 16:50

0

Once you're connected to the server, you can drop a database with the command

drop database [DBName]

Assuming that there's no one connected to it, it should work. And if it doesn't, it'll tell you why.

answered Nov 22 '11 at 16:50

Ben Thul

31,080
4
45
68

main goal of question how to execute sql script via sqsh, but thx for your attention – Roman Iuvshin Nov 22 '11 at 20:02

score 0 · Answer 4 · answered Dec 12 '11 at 16:21

0

echo 'USE table' > script.sqsh
echo 'go' >> script.sqsh
echo 'SELECT * FROM table' >> script.sqsh
echo 'go' >> script.sqsh
sqsh -Ulogin -Ppass -Smssql2005 -i script.sqsh

answered Dec 12 '11 at 16:21

mattalxndr

9,143
8
56
87

sqsh SQL Server 2005 execute *.sql file

4 Answers4

Linked