Thanks! Ideally, yes I'd like to try for the MCITP next. I hear books/study materials are scarce. Have any of you taken it?

In total, about 10,000. There are some updates too, so that's why I was curious to see if there was a way to do it within SQL Server.

Also, methods 3 and 4 returned the same error as before.

sturner (6/23/2011)

---

You can't use CR/LF in the command line... just semi colons.

It will make a very long string, or you can build the string in a series statements like:

set @sql...

Sean Lange (6/23/2011)

---

Not sure why method 3 did not work. Looks correct to me. Method 4 will only work if the remote server is sql 2008. From the two you...

Thanks for the info. Here are the results of my test. Method 2 looks most promising, but I'm not sure why it only inserted the one row.

--Method 1 (10 rows...

What do you mean? My concern is the opening and closing of so many connections and how it's causing query performance degradation and unnecessary load on the server. Would simply...

So the question is, why are the tags for JobStatus not hidden when all of the rest are?

CREATE TABLE [dbo].[SisJobs](

[Name] [nvarchar](128) NOT NULL,

[LastRunDate] [datetime] NULL,

[JobStatusCode] [int] NOT NULL

)

INSERT INTO SisJobs

SELECT...

I never realized that concatenating a literal (e.g. ',' or even '') to the field name causes FOR XML PATH to remove the XML tags.

Thanks.

Mike

Thank you

I'm almost 100% certain. Just out of curiosity, what if I said that there might be another row or two? Would you refer me to your previous example?

I understand now.

I added a where clause to each query, which should only ever return one row:

SELECT end_date FROM DELETED WHERE ID = '1', etc.

Thanks GSquared!

GSquared (5/27/2011)

---

Not on the default schema, maybe? Or accidentally in the wrong database on one or the other connection?

As an aside, the way the trigger is written will throw...

Why disable it? What if all users are accidentally locked out or deleted. SA is your guaranteed way in, no?

Don't use it for the owner...

Gianluca, thanks for the responses.

If you only need Execute permissions on the stored procedure to run any code within it, then what's to stop someone who has execute and edit...