How you have configured the max server memory settings for both installations? I believe awe is enabled.

Manu

It would be helpful if you mention the index structure on both the tables involved in delete operation.

Manu

It should be Version: 9.00.3042 as specified under Quick details section on

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

Manu

Check this:

http://www.sqlservercentral.com/Forums/Topic230344-5-1.aspx

Manu

I think you need to specify the timeout interval at connection level if SQL Server is not responding within default connection timeout setting. For this SQL should be responding to...

Try:

Use DBname

select * from information_schema.columns

Manu Jaidka

Nope. To view jobs you just need membership of targetserver role under msdb database.

Manu

Alan,

I have never gone that much deeper so cant comment on it. Better if you try using the GUI or isqlw option. I never had any issues in deleting...

You need to be a member of db_datawriter(& db_datareader in case your delete and update statements include WHERE clause) database role for performing any such DML operations.

Manu

Have you gone through the following link:--

http://support.microsoft.com/?id=271344

Manu

Did you check the snapshot folder for any script that is genrated for the newly added article once snapshot agent complete its execution?

There should be three files(I think) for the...

What error do you get when you right click the publication and choose delete?

Manu

Dan,

Would be good if you go thru the following link before indulging in any argument with vendor regarding clustered vs. non-clus index.

http://www.sqlservercentral.com/articles/Indexing/clusterthatindexparttwo/1094/

Manu

One question: Will subscribers come automatically after restoration or do i need to manually susbscribe to the publications after restore?

Thanks for the reply,

Manu

Dan,

Would be better if you create a clustered index on this table(either on the same column on which non-clus index is thr or any other relevant column). This way...