To be honest, I can't think of a way. I'm sure I will get corrected on this, but I think the concept of a "schema" in SQL 2000 is...

More info (and a bit of a bump)

The source SQL statement is:

[font="Courier New"]select [col1], [col2], [col3], [col4] from [Sheet1$][/font]

I can preview the sheet if I just select it, but if...

Hi Rohit,

Generally, no, you shouldn't need to reboot your database server weekly to regain performance. If you find that you are seeing a performance increase when you restart, then...

Rob Goddard (10/23/2007)

---

I'm not 100% sure on this next part, but I think if you use snapshot replication with non-updateable subscribers, structure changes are replicated as well. You'll have...

Generally replication is employed once the data structure has calmed down and isn't changed often. If you do need to alter or drop a published article, you need to...

Syed Anis (10/15/2007)

---

I have the OSQL script below:

SET DATABASEFOLDER=%STRING%\My Documents\TIMS\Databases

SET DATABASETEMP=%DATABASEFOLDER%

echo Detaching Databases from Default Instance

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\osql" -E -Q "exec sp_detach_db @dbname='EZSalesOrder'"

echo Database Detached Successfully

echo Re-attaching Databases...

Hi Lester,

For modifications to views and procedures to be replicated, they need to be included as articles in the publication.

For new views and procedures to be replicated, these need to...

Isn't creating user objects in master a cardinal sin?

Hi there,

Great article! We do something similar here, but with a push method as we have a lot of overseas servers etc. We also use the DBCC SQLPERF(LOGSPACE)...

Thanks for all your help, biggest cookie goes to Xanthos for suggesting the hot fix.

The issue was the bug in SQL 2000 SP4 on 32 systems, and applying the hot fix...

Thanks for all the replies.

It is definitely using AWE.  Prior to enabling AWE, SQL was only using 1.7GB, after enabling it is using just under 4GB.

I know that Task Manager...

Just an update,

This has been running for nearly a week and has successfully stopped the stalled job on a number of occasions, so cookies all round!

Thanks for your help Russel,

I'll give this a go and post back.

thanks!

Rob.