Friday, March 23, 2012

how to connect to .mdf file with sqmcmd?

Hi,
i have several mdf files for several asp.net applications. How can i reach
such a database with sqlcmd?
Thanks
BobThe .mdf is just the data file it is not the server. Have you looked up
sqlcmd in BooksOnLine?
Andrew J. Kelly SQL MVP
"Bob" <bob@.omail.nl> wrote in message
news:OuGOrItVHHA.496@.TK2MSFTNGP06.phx.gbl...
> Hi,
> i have several mdf files for several asp.net applications. How can i reach
> such a database with sqlcmd?
> Thanks
> Bob
>|||Take a look into the below URL:-
http://msdn2.microsoft.com/en-us/library/ms162773.aspx
Thanks
Hari
"Bob" <bob@.omail.nl> wrote in message
news:OuGOrItVHHA.496@.TK2MSFTNGP06.phx.gbl...
> Hi,
> i have several mdf files for several asp.net applications. How can i reach
> such a database with sqlcmd?
> Thanks
> Bob
>|||Thanks, i know that mdf is not the server. All i ask is: is it possible to
manage such a database with sqlcmd (something like 'use mymdf_file'). Maybe
that file is attached to the server ...
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schreef in bericht
news:%233v%23A1uVHHA.1036@.TK2MSFTNGP03.phx.gbl...
> The .mdf is just the data file it is not the server. Have you looked up
> sqlcmd in BooksOnLine?
> --
> Andrew J. Kelly SQL MVP
> "Bob" <bob@.omail.nl> wrote in message
> news:OuGOrItVHHA.496@.TK2MSFTNGP06.phx.gbl...
>|||Not that I know of. Ssqlcmd talks to the server instance not the file. You
can specify a db name in the connection string but not a file.
Andrew J. Kelly SQL MVP
"Ken" <kns@.shdv.sd> wrote in message
news:%23M3$h8yVHHA.4404@.TK2MSFTNGP03.phx.gbl...
> Thanks, i know that mdf is not the server. All i ask is: is it possible to
> manage such a database with sqlcmd (something like 'use mymdf_file').
> Maybe that file is attached to the server ...
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schreef in bericht
> news:%233v%23A1uVHHA.1036@.TK2MSFTNGP03.phx.gbl...
>

No comments:

Post a Comment