Hi,

I have not used OPENROWSET ever, so have no idea. But for the same requirement, I think you can try using DTS. A data transformation task with source as ".xls".

Renuka__

Hi,

Or may be you can try this:

exec sp_configure 'affinity mask', 0x0000FFFF

GO

reconfigure with override

go

Renuka__

Hi,

May be you check the table: msdb..restorehisory. It holds the information like the date of restoration, which login was it done from, destination databases etc.,

Renuka__

Hi,

After you restore the database from one server(Production) to another(Development), on the development server, under the restored database, run the query:

sp_change_users_login 'report'

This gives the list of orphaned entries. Map these...

Hi,

May be you can try running a profiler with minimum required events and if you already have some databases in mind (unused) , use the DBID for filtering.

Renuka__

Hi,

I think you can try either "select @@version()" or "xp_msver"....

Renuka__

Hi,

If you want the updates on publisher should be replicated to Subscriber, you can use either Snapshot or Transactional Replication (Depending on your requirement). Only if you require the updates...

Hi,

One of the possible reasons is "Overlapping Schedules". May be you can check if there is any other job running at the same time, when this job runs....

Renuka__

Hi,

Actually as you mentioned, creating a role on Database B with the required access on required objects should be fine. (Im not sure if there is any other way). Later,...

I think you can as well use --SELECT SERVERPROPERTY('ProductLevel')-- to get the sevice pack applied.....

Renuka__