Hmmm... I checked the (planned) schedule. Your session only conflicted with five other interesting ones... I hate (and love) these conferences with too much to see.

Chris...

Brian, you need to install service pack 2 for your brain, that will make it choose TOP instead of SET ROWCOUNT.

Chris Hedgate @ Apptus Technologies (

Yep, I saw it this morning when I got to work.

OK, if it doesn't clash with anything else interesting (as if...) I'll try to attend your talk.

Chris Hedgate @ Apptus...

OK, thanks.

Andy, which session(s) are you speaking at?

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

Brian: From what I've heard, using TOP is recommended over SET ROWCOUNT, mostly because the optimizer can take TOP into account. Am I wrong on that?

Andy: Nice solution, slightly better...

This may not be the best solution, but it will work:

SELECT TOP 200 col1, col2 ...

FROM table

WHERE NOT idcol IN (SELECT TOP 2000 idcol FROM table ORDER BY somecol)

ORDER...

SELECT * INTO newtable

FROM employee

WHERE 1 = 0

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

Anyone? Otherwise I guess I'll have to wait for PASS and ask someone from MS (or Kalen Delaney perhaps), just two weeks now...

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

Andy wrote:

> Why did you decide to code it yourself vs

openxml?

Two reasons:

1) I had some older code from a SQL 7 'experimental app' that used them so I just...

I agree with Andy, use the master-server functionality if possible. Take a look at these sprocs in msdb:

* sp_add_job

* sp_add_jobstep

* sp_update_job

* sp_add_jobschedule

* sp_add_jobserver

Chris Hedgate @...

I'd say yes. But why not just try it?

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

Hmm...forgot to answer...

It should be IP:Port, but you have to know which port.

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

By default, a named instance uses a dynamically chosen (at startup) port number to listen on. You can change this behaviour and force it to listen on a specified port...

Embed the OBJECT_ID() function in a stored procedure on the remote server, and execute the proc with the name of the object you want the id for.

Chris Hedgate @ Apptus...

quote:

---

So, again, can anyone confirm this behavior in SP1?

---

Sorry to be bugging you with this...