I hope you are not trying to run this on a cluster ?

Why don't you generate the osql-line in your job and then xp_cmdshell it ?

(select @sqlcmd = 'osql -E...

- are you sure nobody changed the tablestructure when you were looking at it with EM ? (You will need to refresh the tables-tab) Refreshing at the correct position in...

Whichever way you're going to do this delete-cycle. Remember to provide the propre indexes (FK) to speed it up ! Keep their columns in exact column-order(as defined on the parent-table).

...

Why perform the shrink database if you've truncated the tables and are planning to load ?

build your load-data sorted on the tables clustered index and then load.

you could also put...

1.5 ct

maybe you could try to drop/create the proc with QA at your server ?

This could solve dependant settings (that are stored with the sp)

Edited by - alzdba on 12/16/2003...

- Log Simple does mean it only keeps the log-data until commit is done.

- Maybe index b.recstatus and force the use with hint.

- To keep log-chunks low you could make...

- If you can avoid lock-escalation, do so.

So set a table lock when you start loading.

- You can have autgrowth active, but if you detect space may be allocated during...

correct.

Should be :

CREATE VIEW v_selectarticle

AS

SELECT TOP 100 PERCENT article_id, headline FROM ARTICLES

ORDER BY article_id desc

This is a long shot, but maybe you could download a trial copy of erwin(CA) or another dbcompare-tool, reverse engineer your scripted db and compare it to a reverse engineered...

If you no longer want the jobownership-burden to be able to start a job, create an alert which you let start the job. So when you want to start your...

IMO this is not supported for sqlserver.

(unlike DB2)

What you could do is alter the clusterd index of those partitioned-view-parts to 100% fill and rebuild it. Keep in mind to put...

I think I've read this in a server-migration descussion/whitepaper.

There is a update sysjobs script which puts the new servername in the "originatingserver"column.

If I'm correct all it took was just a...

FYI: The replies counter in forums is not correct. It goes from 0 to 2.

Is there a way to Unsubscribe from a topic notification ?

maybe this helps :

select o.name

, c.text

FROM dbo.sysobjects O

inner join dbo.syscomments C

on O.id = C.id

and O.xtype = 'V'

where C.text like '%CREATE VIEW %'

when opening a page I already start scrolling down before it is complete.

When it completes, it scrolls to top.

Can you avoid that?