We had this issue today, and we were not able to restore the 80 compatibility database backup done with SQL 2005 to SQL 2000. Currently we are trying to...

I generally use the Connect and Resource roles for my subscribers. Works great for transactional replication with initial snapshot.

Have Fun!

I got it wrong. Based on books-on-line I believed that both 32 and 64 bit versions were acceptable. Careful reading of the link from the "What's New" section...

Make sure you have 2005 SP 2, as we ran into problem that was fixed where if we changed the log file growth to, say, 1 GB, a known bug...

Excellent!

Thank you for your help.  Apparently it was just a matter of using the trace flags as startup options as opposed to DBCC TRACEON ().  I have the info I...

I have tried 1204, 1205, 1206, 3604, and 3605.  I can see them all listed in the log as being turned on, yet nothing is reported in the log when...

We also use the looping delete technique to get rid of approx. 33% of our data in high volume OLTP tables.  The advantage not mentioned is avoidance of lock escalation,...

Think I figured it out.  I just have to change each of the sp_addarticle lines in my script to include @pre_creation_cmd specified as NONE.

Yes, absolutely the security info is kept in the link.  That is why you are not prompted for a password each time you connect via the link.  The ODBC DSN...

Rangark,

If I remember your previous posts correctly, you disabled the cleanup because you had data queued up for subscribers that was being deleted before the subscriber had a chance to...

OOPS!!  Sorry, it is basically a repeat of what Jeff had above.

At the risk of being a contrarian, I see no value in expiring existing certifications.  I think the certifications should merely be version specific.  I'd challenge any recent SQL 2005...

It would appear that a simple query like this would solve the problem far more efficiently:

SELECT 

   MAX (CASE PropertyName WHEN 'FirstName' THEN PropertyValue END) AS FirstName,

   MAX (CASE PropertyName WHEN 'LastName'...

As Mohammed wrote, just replace your "dateadd(hh,Datediff(hh,0,TransactionDate),0)" with "datepart (hh, TransactionDate)" in both the SELECT and GROUP BY parts of your query.

Do you really need to have it in another table?  Rather than have redundant data, why not just define a view on the two tables you have no control over,...