I figured my coding out

Our SQL Server is in Pacific

Our Time Recording system is in GMT

For each timezone, I need to run a report at 10:00 in the employee timezone or it could be...

All other tables are the defaults, not set to 850

Would the temp table not be collate at 850 so i dont have to change my update code aswell.

Thanks didn't know about the tables one..cheers

Manufacturing, accounts system.

Thanks - I forgot about the unsupport of the version and will pass it along to our developer that the tool is not supported and also try to just install...

How about sql replication? or if on a san talk to your san guys they can replicate the data from san side.

Keep your data separate and then another database called test_custom_db with all your views etc and sp..your data stored in test_db then your data can be updated from production...but then...

Thanks for the script

Didn't think about having the SYNONYM on the SQL02 and the databases on SQL01. That makes sense.

Now i can do the SELECT * FROM TABLE....

All works just as I...

Don't suppose you know how to see SYNONYMS in a linked server.

I have SYNONYMS set up on server b and on server a set the user with view definition of...

This is what I did

SQL 01

DATABASEA

CUST.ORDERS

DATABASEB

CUST.ORDERS

CREATE SYNONYM [DBO].[ORDERS] FOR [DATABASEA].[CUST].[ORDERS]

CREATE SYNONYM [DBO].[ORDERS] FOR [DATABASEB].[CUST].[ORDERS]

SQL 02

---SET UP THE LINKED SERVER called...

If it takes that amount of space and there more than one statement in a sp then issue a backup statement in between to backup the log provided you got...