batch file script need

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » batch file script need

batch file script need

Rate Topic

Display Mode

Topic Options

Author

Message

charipg

Posted Wednesday, October 24, 2012 9:18 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

I need a batch file script to read the hostname, and replace the hostname dynamicaly where we see 'Hostname' in below script.

sqlcmd -S Hotsname\Inst -i C:\abc.sql

can some one provide this.

Post #1376546

Lowell

Posted Wednesday, October 24, 2012 9:21 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:27 AM
Points: 11,605, Visits: 27,646

in a bat/cmd file or command prompt, you can get the computer name from the variable %computername%

echo %computername%
so you can build a script with that...does that help?

edit

also, if the script is alwasy being run on the same server, you don't need the computername anyway...you can just use the dot placeholder to reference the current server, i think

sqlcmd -S .\Inst -i C:\abc.sql

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1376548

charipg

Posted Thursday, October 25, 2012 1:44 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

Thanks..

Post #1376822

« Prev Topic | Next Topic »

Permissions