Checking collation of Cloumns
SELECT name, collation_name
FROM sys.columns
WHERE OBJECT_ID IN ( SELECT OBJECT_ID
FROM sys.objects
WHERE type = 'U'
AND name = 'reg2003AU')
Clone table structure from existing one with collation.
select reg2003AU.*
into reg2003AUabccd
from reg2003AU
where 1=2
most likely, you have also heard about how to reinstall system database sql server 2005
ReplyDelete