sp_configure "allow updates",1
go
reconfigure
go;restart the databaseupdate sysobjects set type ="U" where name="要修改的表名" and type ="S"
gosp_configure "allow updates",0
go
reconfigure
go;restart the databasedrop table ...
go具体请查help
go
reconfigure
go;restart the databaseupdate sysobjects set type ="U" where name="要修改的表名" and type ="S"
gosp_configure "allow updates",0
go
reconfigure
go;restart the databasedrop table ...
go具体请查help
go
RECONFIGURE WITH OVERRIDE
go;restart the databasedrop table tablename
好象是不让改type的。