In the beginning of your procedure. your setting @rowcount = @@rowcount. Since no operation or query is being run before you set this, it is setting it to...

Yes the restore job will fail, hanging up all other restore jobs.

A destination database in log shipping cannot have any open connections during a restore, So attaching an application to...

OOPS Forgot an important Part

Declare @n int

Declare @n_str nvarchar(55)

declare @recIDmin int

declare @recIDmin_str nvarchar(55)

declare @TblName nvarchar(55)

declare @Sqlstring nvarchar(4000)

set @n = 5

while @n < 20

BEGIN

--cast suffix of a table name to varchar

set...

How are you viewing the data?

If you see this in enterprise manager returning rows text?OtherText then that ? is indicating the newline character.

I believe your updates are working,

If you...

Not knowing much about your situation, Are they default instances, or named instances?

if it is a default instance, then just using the machine name is okay.

If it is a named...

to answer your original question.

Select *

from tablebA

where exists (select *

              from tableb

              Where Tablea.id = tableb.id)

You need a where clause indicating what criteria you need to establish what data...

Use sp_executesql with output parameter

Not TESTED.

Declare @n int

Declare @n_str nvarchar(55)

declare @recIDmin int

declare @recIDmin_str nvarchar(55)

declare @TblName nvarchar(55)

declare @Sqlstring nvarchar(4000)

set @n = 5

while @n < 20

BEGIN

--cast suffix of a table name to...

use the sp_helpfile system stored procedure.

sp_msforeachdb 'Use [?] exec sp_helpfile'

From books online

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_2ak3.asp

Generally it is for improved performance, by putting files on different drives spreading Disk IO across may drives.

Depends,

Look at this

http://www.bizdatasolutions.com/tsql/sqlarrays.asp

If you would like more help on this specific example,

Please post Table Structures, and Test data.

http://www.aspfaq.com/etiquette.asp?id=5006

Short answer.

The Process Info is indicating all the connections to that sql server.

When a connection is establised it is given a Spid. When a connection is closed the Spid is...

Can you elaborate more on this

The Q_No links to a table of the actual question text as does Answer. Here's the complication. They decided that they want to separate the...

Remi, that code you posted is the way.

I think what it boils down to is that code is hard to read, and kinduv confusing. So in issues of customization, or...

Yeah, no big, that ship has sailed, and out to see for a while. Different company, but that query was fresh in my mind.

True that, Just another way to skin the cat.

As suggested not an ideal solution because of the memory management sql uses with openxml documents. and the inherent issues with it.