MS SQL Server - strange things when moving database

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

strange things when moving database

Per W.

2006-02-28, 8:23 pm

When moving from a SBS2000 server with SQL2000SP4 and using detach and then
attach on a new SBS2003server (Prem. edt) with SQL2000SP4 then many fields
behave as date field and there isnt any data in them, any sugestions?

/Per W.

John Bell

2006-02-28, 8:23 pm

Hi

What do you mean by behave as datefield?

Have you checked that they are using the same collation?

John

"Per W." wrote:

> When moving from a SBS2000 server with SQL2000SP4 and using detach and then
> attach on a new SBS2003server (Prem. edt) with SQL2000SP4 then many fields
> behave as date field and there isnt any data in them, any sugestions?
>
> /Per W.
>
>
>

Sponsored Links