Browse by Tags

• change
• database
• databases
• kba
• SQL Server
• tables
• transfer

• Modified KBA - How to transfer a database from one collation to another collation in SQL Server

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to transfer a database from one collation to another collation in SQL Server http://support.microsoft.com/kb/325335/en-US Read More... Posted Friday, August 17, 2007 6:37 AM from SSQA.net | (Comments Off) Filed under: SQL Server, collation, database, kba, transfer

• TSQL to generate a script that updates a column on every table in my database. How do I do this?

  SELECT 'ALTER TABLE ' + sysobjects.name + ' ' + 'ALTER COLUMN ' + syscolumns.name + ' ' + systypes.name + '(' + cast(syscolumns.length as varchar) + ') ' + 'COLLATE ' + syscolumns.collation + ' ' + case when syscolumns.isnullable = 1 then 'NULL' else Read More... Posted Sunday, July 29, 2007 6:39 PM from SSQA.net | (Comments Off) Filed under: SQL Server, change, collation, databases, tables