I am wondering whether there was an issue introduced when the workstation was renamed. Prior to SQL 2005, you needed to use sp_dropserver to remove the old server name...

You certainly create triggers in the subscribing database. You will need to make sure that the triggers are created correctly - either manually by you after the distribution agent...

When using replication you can't use aliases for the servers - the name that you register in Management Studio must match the name for the instance of SQL 2005. ...

I think you will need to get the password/unlock the workstation. SQL is not designed to allow someone else to take control of a connection.

All I can suggest is that the differences that you have identified between the 2 servers (the different number of LUNs) should be investigated further as this seems to be...

If 78% were the cache hit ratio that SQL is reporting (e.g via Performance Monitor), I would be quite concerned. For a system that is performing well I would...

One question is - does the provider for Pervasive support parameters ? Some providers don't.

For what it is worth, I get a similar error when trying to preview a...

Yeah - other things that may also be affecting you include the cache that are allocated to the LUN's. There is also the potential that the I/O requests were...

The different "disks" being used for the two servers will definitely make a significant difference. Whether it accounts for all of the difference should be able to be determined...

The query plan for the whole stored proc should include the plan for each statement in the sproc. This appears as nodes within the tree structure which does tend...

You need to install SQL Net (an Oracle product) onto your SQL box. Once done you need to configure it (you may simply be able to copy files such...

One of the recommendations by Microsoft is that a maximum of 5 databases should be mirrored per server. I think that will rule out mirroring since you have around...

No, it doesn't. You can use any data source but it does need to store the credentials of a user that can run the report

Your data source is defined so that Report Services impersonates the credentials of the user runing the report. For a subscription to be created for a report, reporting services...

Transactional replication will only send (to the subscriber) enough of the snapshot to cover the new articles. The snapshot itself is always complete (includes all articles).

Are you dropping all...