You could also do it by using custom replication stored procedures, or modified versions of the ones automatically created by replication.

To do this create replication as per usual pretending you...

Check the file size. One minute later check it again - if same, you can assume its finished.

If you aren't on a fast network then stretch it out to five...

BCP out using the QUERYOUT option rather than OUT, that way you can format the date how ever you want. If you've got something against QUERYOUT, then use a view.

I believe you can get around this by telling your article that you want to do an MCALL on the update rather than a CALL. This is done in the...

Thanks, I've fixed that now.

I can't believe that openrowset is available to ALL users by default, and that it isn't restricted to the DSN's setup on the host server...

What's this "DisallowAdhocAccess option" the faq claims is set using "the advanced sp_serveroption" to stop openrowset useage?

I've only got sql7 at work, but can't find it.

IF @@ROWCOUNT = 0 BEGIN

-- RAISE AN ERROR

       END

Watch out though, @@ROWCOUNT is reset by each statement - so checking...

I don't think there's a topic on this in BOL.

It may be worth batching up the scan of the large table into smaller chunks avoiding a large rollback if something...

You are just missing the owner. It goes SERVER.DATABASE.OWNER.OBJECT so in your case it would be:

 select * 

from RMATV..PICKLIST

or this if the object's owner...

In the database you are interested in run: DBCC SHOWFILESTATS

 sp_msforeachtable 'sp_spaceused ''?''' 

uddim,

That doesn't work for SQL7.

I use this as a step before my restore step in the job that copies production to dev each morning:

 

use master



declare...

Steve, Agreed with everything you said. I'm particularly fond of commas preceeding column names.

Adam, Thanks for your guidelines.

-- Allowing for variable length, comma delimited fields.

declare @states varchar(2000)

select @states = 'AL,AZ,AK,MO,FE,ARIZONA,ZA'

Declare @MyState VARCHAR(10)

create table #states (state varchar(10) not null)

WHILE (charindex(',', @states)) > 0 BEGIN

insert #states (state) select substring(...

end-user,

Go with Antares686's suggestion of pumping the @States string in to a temporary table.

You lose all advantages of stored procedures using dynamic sql, and the SQL has to be compiled...