I'm trying to determine what instances of sql server/sql express i have installed (either manually or programmatically) but all of the examples are telling me to run a sql query to determine this w. It will prompt you for it and not record it. I have a.sql file with an export from phpmyadmin
I want to import it into a different server using the command line 15 you need to use I have a windows server 2008 r2 installation
I've sql server 2008 express on a windows server 2008 machine, if that relates. What are the possible ways to determine the deployed sql server version I’ve tried to do it using the sql server software I want to do it using a command line sql statement.
Open sql shell (psql) from your applications (mac) Click enter for the default settings Enter the password when prompted For help *) type \conninfo to see which user you are connected as
*) connect to a database by \c <name of db>, for example \c genedb1 you should see the key prompt change to the new db, like so *) now that you're in a given db, you want to know the schemas for that db The best command to do this is \dn
