We use owner of tables in our replication from SQL to Oracle. In our case, we have 7 corresponding staging tables on Oracle for plain data load. Then some procedures...

Yes, we are using LUM replication. I am not concerned with the SQL server on DR site. I am concerned with SQL server on primary production site. Is there a...

Thanks for the response. That helps.

But, I really want to find out if I could make entire SQL server in read-only mode with a simple command since I have...

Could you indicate which line is Line 198 in your trigger?

1. back up jobs

If you don't want to restore msdb, you use "generate script" feature in Enterprise Manger by

going -> Management -> Jobs: select the job and right click the mouse.

2. DTS

Save...

Leonid,

Your script is simple and works for most of the months except for September, 2005. It returns 9/23/05 instead of 9/30 as the last Friday of the month.

Thanks!

Scott,

You query works great! Just out of curiosity, when you cast(date) as float, what does that float number mean? I would like to know why you need to add 3,...

Govinn,

Thanks! Your script works for me.