running a SQL script

We have a program running on the SQL 2005 database platform. One of the
tables has too many indexes to do an ODBC call from Access, so the programmer
wrote a script that will drop some of the indexes so that I can link to it.

It has been years and years since I've run a SQL script on the database ...
and I can't remember how to do it. I can't get anyone from the software
company that gave me the script to tell me how to run it. Can someone please
tell me how to do it?

Jackie,

With SQL 2005 you can use SQLCMD (new) or OSQL (still supported) to run a
script. These are installed when you install the SQL Server management
tools.

sqlcmd -S servername -E -i scriptfilename -o outputfilename

The -E is telling sqlcmd to run with your rights. If you have to run as a
SQL Server login, then

sqlcmd -S servername -U loginname -P password -i scriptfilename -o
outputfilename

If you want to know more about the utility, the other options are describe
in the SQL Server Books Online.
Tutorial, if you need it:
http://msdn.microsoft.com/en-us/library/ms170207(SQL.90).aspx
Documentation: http://msdn.microsoft.com/en-us/library/ms162773(SQL.90).aspx


RLF



"Jackie" wrote in message

> We have a program running on the SQL 2005 database platform. One of the
> tables has too many indexes to do an ODBC call from Access, so the
> programmer
> wrote a script that will drop some of the indexes so that I can link to
> it.
>
> It has been years and years since I've run a SQL script on the database
> ...
> and I can't remember how to do it. I can't get anyone from the software
> company that gave me the script to tell me how to run it. Can someone
> please
> tell me how to do it?