Thank you in advance, here is a sample:

CREATE TABLE tbl

(

ID int,

[Name] varchar(50)

)

insert into tbl (ID, [Name]) values(1, 'John Doe')

insert into tbl (ID, [Name]) values(2, 'John Smith')

insert into tbl (ID, [Name])...

Thank you for that, holding breath now but it seems "remove SQL server"...

Dan.Humphries (6/25/2010)

---

I think that depends on how much data you are copying and what is going on in yoru servers. for my money though I would strongly encourage you to...

Thank you Chris, I didn't notice the redundancy.

Thank you guys for replying me, I have the same concern about the function, I don't know if/how to improve it because for each record in the query result, I...

You are right, thank you.

select object_id('#temp') returns NULL

thank you Lowell

Where can I find the report file (.rdl?)? maybe from the report file I can find some clue on how the report is generated and create my own...

Here is an example for you to understand:

set@body1 = 'This email is intended for ' + @Email + '.'

set @body1 = @body1 + '<br />' + '<br />'...

lmu92 (6/2/2010)

---

Would you mind reducing your post from 500 lines of code to the issue you're struggling with? If your issue is not to see the line break in your...

One thing missing here: is it possible to find out the last modified user? who made the last change? It seems not included in the sys.objects table. I do see...

Thank you.

Thank you.

Whoa.... it doesn't sound friendly or patient to me, there...

It seems the bracket is causing the problem, I took away the [], now this issue went away.

Thanks for replying.