Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 19,092 of 19,505    |
|    Mads Aggerholm to All    |
|    Re: 'Import' scripted DB ?    |
|    17 Aug 14 20:13:57    |
      From: mads001@xxxxxhotmail.com              Den 16-08-2014 21:42, Erland Sommarskog skrev:       > Mads Aggerholm (mads001@xxxxxhotmail.com) writes:       >> That's beyound my influence. It's for some customer, who will not upgrade.       >       > Idiots!       >       >>>> On the internet i forund this:       >>>> sqlcmd -S xxx.xxx.xxx.xxx -i C:\SQLFOLDER\database.sql -o       >>>>       >>>> Unfortunately, it does not work.       >>       >> First, it says: "Sqlcmd: '-o': Missing argument. Enter '-?' for help."       >       > Yes, -o takes an argument. This option redirects the output to a file.       >       >> Then I type '-?', and get the message: "'-?' is not regoqnized as an       >> internal or external command, operable program or batch file."       >       > You are supposed to type       >       > sqlcmd -?       >       > You can also find information about the command options to SQLCMD in Books       > Online.       >       >> Well, I ommit the '-o' and tries without it:       >>       >> If waits for some seconds, then says:       >> "HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a       >> connection to SQL Server [2].       >       > So you did not specify the name of the instance correctly. This is no       > different from how you do it in SSMS. It has nothing to do with the size       > of your scripts.       >              Thanks a lot, I forgot the login and password. Damn!       Now I've come to the next step, facing other difficulties, but at least       I'm in.       I think I can take it from here.       Thanks again.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca