Ian Scarlett (11/25/2009)

---

Is it the distribution database itself, or the transaction log that is growing?

If it's the transaction log, check the recovery model. If it's anything other than simple, you...

Thanks Kashyap,

You...

Thanks Gail.

Is replication...

Scripting is also failing due to violation of constraint (foreign key, I guess).

Is this a problem without any solution?

Thanks BrainDonor for your quick reply. I thought there is some way to restore as the compatibility is not changed. It is unfortunate that it is not possible.

Detach/attach is also...

Thanks George for your quick reply.

Old server has 32 bit OS and SQL. New server has 64 bit OS and SQL.

Thanks for your help.

Regards,

Suresh

Both are...

Bhuvnesh (9/9/2009)

---

I have one database whose Data file is growing at very fast pace & it’s so huge that the hard disk of server is almost out of space. Now...

This may help you http://www.sqlservercentral.com/Forums/Topic781039-291-1.aspx

Right click on SQL Server Agent node in the SQL Server Management Studio Object Explorer.

Select Properties -> History

Change the values according to your requirement.

Thanks for the reply.

But my question is NOT, when the statistics becomes OUTdated.

My question is, When SQL Server engine UPdates the statistics?

Database master key:

select * from sys.symmetric_keys

DOS command copy can be used with + as follows:

copy File1.sql + File2.sql + ... + FileN.sql FileAll.sql

select * from sys.certificates