how to execute a SQL statement
Posted on 2013-01-03
I am working on a windows XP sp3, DELL optiplex computer. I have installed some software for a group home, called PPS, which is a database software suite. It required that I installed SQL server 2005, as part of the install. The install has been completed successfully.
Next, I moved on to copying the data for the database, from the prior machine/workstation into the appropriate spot. I was able to correctly copy the files to the correct location, after stopping the SQL services. I rebooted, and made sure the services started again, as they are set for automatic.
Now, i am left with one last step. I am being asked to execute a SQL statement that says:
sp_attach_db 'PPData', 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\PPData.mdf', 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\PPData_Log.ldf'
The location of the files has been updated for the new machine, and is accurate. However, when I try to execute the command from the run prompt it says:
Windows cannot find 'sp_attach_db'. Make sure you typed the name correctly ...
Can you execute SQL statements from the run command in windows XP. If not, how would I go about executing this statement so that the database application, PPS, can see the data I have copied in. I cannot see the data until it has been attached.