The only database backup operation that can be run when you are in SIMPLE is FULL DATABASE Backup. In BULK-LOGGED you can take TLOG Backups

try BEGIN DISTRIBUTED TRANSACTION!

You need to call the procedures "at once" right?

So you have to have either separated threads on the client side or separated processes on the client side that call the...

You will need to use VBSCRIPT and use DTS Object model to save/load the package. Use VBSCRIPT subsystem of SQLSERVERAGENT.

Well Try connecting using an SQL Server Login (other than SA of course).

Windows Authentication prevent account delegation ( or impersonation) unless you have setup Kerberos and The remote server...

are you using "windows" authentication when you sad that you connect as "myself" ?

The reason for not using the index is that it considers more expensive to perform bookmarkLookup " for the rest of the columns in your query" than scaning the clustered.

You...

Can you explain "in words" how you constructed the output?

IDLog --- IDOrder

101 --- 201

103 --- 202

104 --- 203

105 --- 203

????????????

you will have to create either a multithreaded app or multiple clients that pool a single resource file and when you change that "file" your clients will execute the procs.

Cheers!

in the article properties you can specify destination table owner!

Cheers,

Or post your questions here

EM queries UPD Port and from there retrieves the active instances, then it uses the Port in the "connection string"

Cheers,

You need to map your login to the one used to connect to DB2 in the linked Server properties!

Cheers,

>>>>

DECLARE @int INT

EXEC sp_xml_preparedocument @int OUTPUT, 'DieselPetrol'

SELECT Carname FROM Catalog

WHERE CarType = ALL (

Select Type

FROM OPENXML (@int, '/CarType/Type', 2)

WITH (Type VARHCAR(20) '.') )

EXEC sp_xml_removedocument @int

<<<<

Is there such a car type...

If you are planning to drop the table used in a stored procedure temp tables are your friend