You can use the SQL Server DB Export/Import feature and select all the database tables to a text file..

If  you check SQL Server current activity, do you see any processes with some data under Wait Resource? I would guess you should see some processes with Wait Resources and...

You probably can change the DNS entry for the SQLP to point to SQLS. (dns alias record I believe..)

Now if the secondary server is a named alias, that could be...

The user who would administer the database should belong to the db_owner group.

The folks who read and write should belong to the db_datareader and db_datawrite roles.

Noeld:

Have you used delegation? Would like to get feedabck or gotchas from folks who already used it.

Thanks.

I think it relates to SQL Server not allowing nested inserts in a Insert into .. Exec construct. That is why instead of using the "insert into master..space1...

I know protegrity software make software something on those lines using extended procs.

Noeld:

Was the fourth step in the first case to make batch file that runs DTSRUN of the .dts file?

In the second case, I think I have hit a brickwall and...

My guess would be, assuming the SPID has no wait conditions (no disk waits, or resource waits) it would continue to process the SPID. I saw no mention of pre-emptive...

I am not familiar with BO, but would aliasing the server in the Client Configuration work?

Here is a piece of code I found on some other site that does (I did not validate the code, please verify and modify if required)

Make this a procedure in...

The table sysindexes has most of the information generated by the sp_spaceused. Querying sysindexes is probably easy, since you get space usage for the entire database at one shot. Iterating...

Chris:

In my earlier post, I should have clarified that AdStartDate and SaleDate are aliases to the same field, and the same holds for UPC and Item. In my effort to...

At a cursory glance, here is my slicing:

I would do one mirror set just for the SQL server transaction logs, one for the Oracle Redo logs and one for the...

I have found log shipping to be very reliable on the two projects I worked on. If there were ever any issues mostly related to the network availability, since one...