Craig

Yes, since all your values are negative, this will work:

UPDATE MyTable SET MyNum = MyNum * -1

WHERE <whatever>

But if you didn't know whether the values would be be positive...

John is right.  It's as simple as this:

SELECT

TABLE_SCHEMA + '.' + TABLE_NAME

Luk

Do all your tables have a clustered index?

John

UPDATE t1

SET idcreated = t2.ID

FROM Table2 t2 INNER JOIN Table1 t1

ON t2.Description = t1.Description

John

Charbel

I've never tried doing anything like that before, so I don't know exactly how to do it.  One way round it would be to edit your format file as described...

Eamon

You can use the sys.dm_exec_sessions view to find out what session(s) a given SID has open.  Then simply put the session number(s) into DBCC INPUTBUFFER command.

John

Charbel

This is from the Microsoft website:

To create a format file that is easily modified, start the BCP

   utility by using the following command line:

      bcp <db_name>.<owner>.<table> out <data_file> /S<server>...

Charbel

If you read the BULK INSERT topic in Books Online, that should tell you everything you need to know.

John

Charbel

I think you can, but, depending how much data you are importing, you may find it easier to import into a staging table that has the same columns as the...

Garry.

No. SQL Server service packs are cumulative, so you only need to restore the most recent.

John

Sean

Something like this?  Not tested, so syntax may not be perfect.

CREATE TABLE #Gaps (RowNo int IDENTITY(1,1) PRIMARY KEY CLUSTERED,

                              AccNo int, Blanks int)

INSERT INTO #Gaps (AccNo)...

John

Yes, you can script the creation of the articles.  I imagine the creation itself would be fairly reliable, but what happens after that - who knows?  I've never worked with...

Lowry

Don't know.  Are there any triggers defined on the subscriber?

John

Do both databases have the same indexes?  Have you updated statistics and/or rebuilt indexes on the smaller database recently?

John

No.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=48&messageid=351167#bm351190

John