Per Seat for

The Per Seat licensing mode requires a Client Access License for each device that will access SQL Server 2000 Server. Per Seat is often more economical for networks...

Please read about Implementing Application Failover with Database Mirroring at:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/implappfailover.mspx#EMD

Connection String

The SQL Native Client data providers introduced a new connection string keyword to support some of the new features in...

Can you try dropping the existing plan and creating it again if noone(who has faced this before) replies back back with solution?

MJ

Please post the error message or the message under job step history here so that we can guess something out of it.

MJ

The mirror database is inaccessible to applications and receives transactions sent from the principal database(http://mctssqlserver.blogspot.com/2007/10/database-mirroring.html).

MJ

I was just telling him how dts package can be used once created. Only users with access to database can manipulate data from dts.

I never intended to provide direct...

They can only do something using dts once they get database access, you need to provide only the required access and they will be controlled automatically.

MJ

Have you tried running the t-sql statament ran by the code on server itself? It will answer your problem whether its timeout settings on >net side that needs to be...

You can do that:

http://msdn.microsoft.com/en-us/library/ms189625(SQL.90).aspx

HTH,

MJ

No stored procedure can help you here. You need manually apply t-logs in sequence and test wth the final log restoration by specifying some guessed time and see if you...

If you just need to update sysservers table then try one thing:

Attach your master database files to some other 7.0 server as a user database and update(turn on allow adhoc...

Try starting it from command prompt and let us know the error message you get over there and in event viewer logs, if any.

MJ

You can create packages with just public role membership but for defining tasks under package you need to make connections to server and access the intended database. For accessing a...

Did you try setting timeout setting to 1 hour or something apart from 0(i.e. unlimited) as it usually allows the code to give an hung impression to server.

MJ

Did that problem got resolved by setting timeout to 0(unlimited)?

Sorry asking quiet late.

MJ