Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-18 : 09:17:35
|
| Ajit writes "In the database i am using it does not allow me to view the table structure in the desing mode in Sql Enterprise Manager to any of the users not even to sa which has all the rights of the database used by us.It does allow me to add a new coulmn in table from Query AnalyserNow the problem is I have to change the data type of a column from float to varchar.Please Help" |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2002-06-18 : 09:27:46
|
| You can use this in Query Analyser:ALTER TABLE table { [ ALTER COLUMN column_name { new_data_type [ ( precision [ , scale ] ) ] Look in BOL for the fill syntax Does the Enterprise Manager, provide an error? |
 |
|
|
|
|
|
MS SQl