OSQL issue with running update script..

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

OSQL issue with running update script..

Author

Topic

snivas
Starting Member

9 Posts

Posted - 2012-02-23 : 11:05:28

hey all,
I am running below script
master.dbo.xp_cmdshell
'osql -S [A2ML03599\SQLSERVER2008R2] -U tets -P Test1234
-d Tets -i "D:\SQLSERVER2008R2\batch_1.sql"'

But I am getting below erros
output

DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
OS Error 53 The network path was not found.
NULL
NULL

I verified Server name with SELECT @@SERVERNAMAE name is correct what every I enter into the script.Path also I given with \\servername still I am getting same error.

Please some body help..me.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-02-23 : 14:22:08

did you try without that square brackets?

No, you're never too old to Yak'n'Roll if you're too young to die.

snivas
Starting Member

9 Posts

Posted - 2012-02-24 : 04:39:39

Thanks webfred for reply
Yes ..I tried with out square brackets..

Otherwise help me by giving script which can run 13000 update sql script files.

Thanks in advance

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources