I have a question to make, I have a create to file database from an sql server 2005 database (schema), I want to insert (execute the file to create the database) it to an sql server express 2008 sever (win7 and winxp target machines, win7 developer, win xp client), I have tried (in windows cmd starting sqlcmd) to do it without managment studio, have typed sqlcmd.exe but I thing I need the connection string.
ask 1 How do I find the default instance name (my pc win7) I thing theough the file of the database or the services console (contro; panel)
ask 2 The sspi (I have only windows authrntication) is the windows authentication? (I want to use com to create the client(s) server in the target machine(s)
ask 3 in vc# (vc# 2010 express) can I use in local network on...to be continued
Thank you
Kyriakos (aluooss)