this question has also been asked and answered here;

http://www.sqlservercentral.com/Forums/Topic634281-1291-1.aspx

Depending on how big your database is, you could write a SSIS package to copy all the database objects across.

It is because you are using nvarchar(max) datatype which is effectivly a Text datatype or a blob and these have their own limits.

If you are only inserting 10 characters then...

No worries, glad that it worked out for you.

Collation affects the way that string values are sorted and compared and can sometimes can cause funny issues.

Check the properties of the database (right click), have a look at the collation setting.

Check the properties of the table --> Extended properties, have a look at the...

It looks like your collation settings for the table are different than that for the database, check that these are the same.

This is fairly straight foward in SSIS, you can even run the SSIS import-export wizard to get you started.

Is there something in particular that you are struggling with?

The best place...

You should really store all the same data in the same table, having a new messages table for each user will cause massive headaches in the future.

5,000,000 rows...

You are trying to use a Varchar variable with a smalldatetime paramater, this will not work. you either need to change the varaible data type to smalldatatime, ...

The easiest ways are to either use restore from backup to the new server,

or dettach the database and attach it at the new server

If you are unable to do...

I am assuming that you are using the microsoft ORACLE ODBC driver?

If this is the case then this driver does not have the ability to handle LOBs.

You would better off...

It would depend what is contained within the CLOB.

The direct equivalent in SQL is a binary data type, but if the information in the field is pure text then...

if you are looking for the script that create '5GSMM20000K0' as your primary key, then that is not the right one. All that does in define the column in your...

If you do a select * then you are asking sql to return all the columns on the table. If the Index only has the one column...

Tony (12/30/2008)

---

I agree with the "Inside SQL Server" series mentioned above. After being a SQL DBA for 13 years & getting certified, I discovered these books. I'm somewhat...