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 |
|
Helloise Smit
Starting Member
22 Posts |
 Posted - 2008-09-30 : 03:25:05
|
| followed the steps in the blog: http://blogs.msdn.com/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspxi typed the following at the command prompt: c:\program files\microsoft sql server\100\setup bootstrap\release\setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=SQLEXPRESS /SQLSYSADMINACCOUNTS=BUILTIN/Users/SAPWD=internet /SQLCOLLATION=SQL_Latin1_General_CP1_CS_ASit ran through...i then had a look at the summary.txt file and it gives the correct collation BUT when i open my DB and look at the tables the collations is still set to the old one. i dont get any errors when i run the above code.can someone help pleasethankshelloise |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-11 : 04:13:06
|
| The command you are using rebuilds SYSTEM DATABASE."when i open my DB "It will not have any affect on your user database.For user database, you can use ALTER DATABASE command to change collation.Thsi only changes collation for any newly created object after the ALTER stmt.To change Collation of existing objects, you will need to use ALTER TABLE command. |
 |
|
|
|
|
|
rebuilding a database for sqlexpress 2008