Re: Alter Table Property
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 13 Sep 2007 22:17:06 +0000 (UTC)
Ryan (Ryan@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I 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?
You run the same ALTER statement as you would have run in Mgmt Studio.
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, esquel@xxxxxxxxxxxxx
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
.
- Prev by Date: ANN: MS SQL Field Box 1.7
- Next by Date: Re: SSMS Pain in the ***
- Previous by thread: ANN: MS SQL Field Box 1.7
- Next by thread: can someone have idea on this perfmon result
- Index(es):
