Thanks for such a quick response. I'd never tried scripting replication before but it works well. I just changed sp_add_article and altered @destination_table. This option didn't seem to be on...

See where you're coming from - thanks.

Paul Ibison

Paul.Ibison@btinternet.com

Eventually solved this one: use sp_scriptpublicationcustomprocs to generate the stored procs when you don't need synchronisation. It's allegedly fixed in SP1 for SQl 2000, but I still need to run...

Tim Peterson's book is the most comprehensive book I found. It doesn't have a case study like the Wrox books, and is sometimes a little difficult to find a topic,...

I had 5 years of db experience before doing the SQL 2000 exams, which helped, but I still think carefully going through the Sybex books and Transcender exams would be...

Apparently 32767 per instance of SQl 2000 is the limit. I have only supported a max of 15 dbs on a server, but Andy Warren has 250 so he might...

Don't know sql 6.5 too well, but I solved a similar issue in SQL 7/2000 by shrinking the individual file. From BOL:

"The target size for data and log files as...

It's a local table not created using EXEC.

Paul Ibison

Paul.Ibison@btinternet.com

Hadn't renamed the folder, but had issued dbcc reindex, update statistics and sp_recompile on all tables. I guess one of these is the cause, but will need to set up...

Thanks Andy - this gives me some ideas. Would also welcome any details from people out there who work in this sort of 'extreme' environment.

Paul Ibison

Paul.Ibison@btinternet.com

I have a little experience of this, but will need some more info: what error messages are being returned? Are the dimension tables being populated ok? Is the schema changing?...

Sorry David, I copied and pasted my comments incorrectly - should have said "if you are not opening the cursor before ...". As long as there are no 'Close MyCursor'...

SQL Server raises this error if a referenced cursor variable exists but does not have a cursor currently allocated to it - have seen this if you are opening the...

You might want to have a look at this related thread: http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=950&FORUM_ID=8&CAT_ID=1&Topic_Title=how%20to%20decrypt%20data%20from%20sql%20server&Forum_Title=T-SQL.

(There are other threads which deal with this as well, as well as several articles). For my...

Didn't catch the first thread, so sorry if my questions go over the same ground, but how are Answers_Eligible and Answers related? You say that if two requests are made...