One way round it is to have the objects created as owned by their creators, but then changing ownership afterwards.  The script below will create a view in your database...

Clement

Assuming all currency fields in your database have the "money" data type, this will generate a script that will change your values as required.

John

SELECT 'UPDATE ' + c.TABLE_NAME + ' SET ' + c.COLUMN_NAME + ' = ' + c.COLUMN_NAME + '/1000.000'

FROM INFORMATION_SCHEMA.COLUMNS c JOIN INFORMATION_SCHEMA.TABLES t...

Ian

Temporary tables aren't less efficient than table variables.  Both will be created in memory if there is enough; both will end up in tempdb if they end up too large...

You say that Node B was rebuilt three months ago.  How was it rebuilt - from an image file or by reinstalling the operating system?  How did you reinstall SQL...

Depending on whether you just want the empty database or the data as well, you can script out the creation or restore of the database.  Do the same for the...

Andrew

Yes, just set the stats option in the command in the job in the same way as you would if you were running it in Query Analyzer.

John

Jeff

You are indeed missing a trick.  The tables MyTable, ThisTable and AnotherTable have to exist in your database.  If they don't, substitute them for some tables (and columns) that do. ...

OK, so the problem is occurring in transferring data from the distribution database to the subscription database (Northwind) on 192.168.195.10.  I would guess that there's a problem with the sp_MSins_Region...

Claudia

Is it the LogReader Agent or the Distribution Agent that gives you the error?

John

Happy to help.

John

I don't think this can work with your current database design.  It seems to me that where you have gone wrong is to create your FK constraints the wrong way...

Please will you post the SQL for creating the constraint FK_PaymentTypes_CashPayment.

Thanks

John

Not if you use bigint, which is 8 bytes.  Then you can have more than 18 billion billion records in your table.

John

Fernando

Try doing your restore with T-SQL.  Something like this:

RESTORE DATABASE MyDB FROM DISK='\etc\etc\etc.bak'

John

I understand the restrictions on cascading updates and deletes... I think this is what I tried to explain to Darren.  Self-referencing tables aren't to do with this problem, just an...