|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Alter Table PropertyI have a sql server 2005 based MyDB.mdf and MyDB.log in c:\MyData folder. All
client components are installed on my machine but do not have Management Studio. How do I ALTER a table property in this database either by using osql or sqlcmd command line tools or any other tools? Ryan (R***@discussions.microsoft.com) writes:
> I have a sql server 2005 based MyDB.mdf and MyDB.log in c:\MyData You run the same ALTER statement as you would have run in Mgmt Studio.> folder. All client components are installed on my machine but do not > have Management Studio. How do I ALTER a table property in this database > either by using osql or sqlcmd command line tools or any other tools? sqlcmd -d MyDB and off you go. (Provided that MyDB is also the database name, and not only the filename.) -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics