Hi,

I saved the change script after adding manualy the IDENTITY property to the autoid column in Enterprise Manager. This is the generated script:

BEGIN TRANSACTION

SET QUOTED_IDENTIFIER ON

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

SET...

Hi,

this should help you:

http://www.codeproject.com/KB/aspnet/PagingLarge.aspx

Regards,

Oana.

Hi,

you can begin with reading this:

http://msdn2.microsoft.com/en-us/library/ms191428.aspx

Regards,

Oana.

Hi,

maybe this will help:

http://technet.microsoft.com/en-us/library/ms178567.aspx

Regards,

Oana.

Hi,

please read this:

http://articles.techrepublic.com.com/5100-22_11-5068954.html

hope it helps 😉

Regards,

Oana.

Hi,

write this at the beginning of you code

SET INDENTIY_INSERT REAL_TABLE ON -- "disables" the identity column

EXECUTE sp_xml_preparedocument @Pointer OUTPUT,@xml

INSERT INTO #tmp_tbl

SELECT *

FROM

OPENXML (@Pointer,'DATA/OBJECTS/OBJECTS_ITEM',2)

WITH REAL_TABLE

and SET INDETITY_INSERT REAL_TABLE OFF...

Hi there,

Did you check if the number of columns in the otherdb..table matches the number of columns in the activedb..table?

I would suggest this:

INSERT INTO otherdb..table (list_of_columns)

SELECT list_of_columns FROM activedb..table

Regards,

Oana.

Hi,

Application Roles

Application roles are the SQL Server roles created to support the security needs of an application. Often database applications enforce their own security based on the application logic. For...

Hi there,

You can use the Attach Database option where you can specify the .mdf and .ldf files to be attached and a new database will be created.

Is this what you...

Hello,

there are more ways to do this.

what i would do is to copy the source table on the destination table using DTS.

after that you can insert the missing data into...

everybody makes mistakes .... :ermm:

Kind regards,

Oana.

Thank you so so so much 🙂

Oana.

wow 🙁

I hope this time you can see the xml example.

Sorry ...

I don't know what happend with the xml example 🙁

Schuster</Last_Name?

...

Hi,

Maybe this will help:

http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx#EHFAC

Oana.