as far as i know, you have to select the encrypted column from syscomments:

select object_name(id), encrypted, * from syscomments where encrypted 0

instead of printing, you have to use RAISERROR instead to get your ongoing progress:

--print error immediatly in batch

while 0=0

begin

raiserror ('my Progress So far....',0,1) with nowait

waitfor delay '00:00:05'

end

i didn't see the execution plan as getting attached; can you re-post it?

yeah for big datasets, bcp is the only way to go;

here's an example, works perfectly, creates a tab delimited file:

exec master.dbo.xp_cmdshell 'bcp master.dbo.ALLCITYZIPCOUNTYSTATE out c:\sampleout.txt -S localhost\SQLExpress -T -c -t...

quick and dirty is to use grid mode, select the results and copy, then paste directly into Excel;

it pastes right in as tab delimited automatically..

i don't know if you can...

a typical example from SQL server's metadata:

SELECT

sysobjects.name As TableName ,

syscolumns.name As ColumnName

from sysobjects

inner join syscolumns on sysobjects.id = syscolumns.id

where sysobjects.xtype='U'

order by syscolumns.name,syscolumns.colid

sorry i mis understood, i thought you wanted each of the lower TASKs..

in that case, i'd use the row_number() feature and an outer select:

SELECT * FROM (

select row_number()over (PARTITION BY...

you can use the default trace, and hopefully find what happened;

here is aan example:

-- obtain file name for Default Trace

declare @TraceFileName nvarchar(256)

set @TraceFileName = (select path from sys.traces where...

search the "Scripts" section here on SSC for "Split Function"

there are a lot of great contributions there;

they typically expect a varchar string and a delimiter to split them by:

for example:

select...

here's an example which gets the lowest task for each row; you simply compare the column values in a case statement. that will get you started on which tasks to...

you started a second thread on the same issue.. a lot of posters asked for clarification, and you never replied.

we really need an explanation of the format of the string.

you...

you have to install the Oracle Client tools on the server, set up the TNSNAMES.ORA and SQLNET.ORA files so you can actually connect with SQLPLUS or other Oracle utilities like...

I answered in the other thread that was alonst the same subject:

a specific example for you:

create proc test ()

as

begin

BEGIN TRAN

update table1 WITH(TABLOCKX)................

Insert into table 2 WITH(TABLOCKX)...................

not sure why you'd want to lock a table up, but I would do it with a transaction.

one of the HINTs you can use is to exclusively lock a table:

From...

interesting;

i used the default trace and my own DML trace to see what it was doing.

the code you posted executes and created a stored procedure.,

the procedure gets encrypted, so...