I think AJ is right, EM is not a good place a view all rows of a table especially a large one. It consumes  alot of mem.

That is why there...

I think you need to turn off your parellism because it's causing a deadlock.

Room for another?

update table set column = select substring(column, 1, len(column) - 4)

how about drop view --> re-create view ?

when you exec the proc, the proc executes itself (looping/nesting) 32 times.

It's only 32 iterations because a stored proce can only nested proc up to 32 times.

Cheers.

I thought, import data into staging database first(which I call staging load) and then trasformations take place from there into DW layers.

Anyway, my preference is to use SPs wherever I can because I will have...

I had the same problem last year. When using DTS data pump truncation occured in destination without raising any error. Until now I still don't know why.

if you set ANSI_WARNINGS...

With the 'go' statement you create the proc first then execute proc.

Without the 'go' statement you create the proc with a nested proc within. In this case you're self looping...

select getdate() --current date

select dateadd(mm,-6,getdate()) -- last 6 months

Phil, just wondering, it is possible to create a xp_proc and call a batch file that contains all your command lines?

Not sure what you mean by "linked table".

Can you give a example??

There is nothing you can do but find the most current backup and restore asap.

I'm just being psychotic here...

"if I drop a database can I rollback ???????"

where 1=1 + @addfilter

2 problems in this clause:

1. it will not return any results as long as there is a value in @addfilter. It will always return FALSE condition.

2. @addfilter...

not sure what you mean by no owner?

As far as I know owner can not be null.

typo....

Sufian, You cannot rollback a restore because it is NOT a transaction.