For Trader Sam (post 461679) and Jeff Deluca (post 461745):

First of all, the ms152560 reference says:

"It is recommended to set [the sync with backup] option on the distribution database in...

I agree with Jeff Deluca. "Both of these" to me means situation 1 gives a "true" AND situation 2 gives a "true."

):-D

I don't think you should take the blame for this one. I think Books Online should be more explicit.

This was a great learning experience! I will now know...

I was at that very page in SQL 10 Books Online:

http://msdn2.microsoft.com/en-us/library/bb677290(SQL.100).aspx

And I quote:

"The hierarchyid data type is a variable length, system data type."

and

"The hierarchyid type is available to...

Here is the question:

In SQL Server 2005, can you reference a synonym located on a linked server from your local server?

Here is a quote from Books Online

In the following example,...

A tried executing TRUNCATE TABLE against a table variable and did get an "incorrect syntax" error.

There is nothing like experimentation!

):-D

I combed the msdn article cited from top to bottom twice, and found no mention that truncate was not allowed.

I'd appreciate the location and exact quote.

Thanks.

):-D

Thank you, Steve.

Diana

Well, hey. The answer you quoted also included Windows Server 2008 Enterprise. So, gimme my point.

I also agree with Hugo.

Diana Dee

MCITP: DBA on SQL 2005

I agree with Matt.  Many times when I answer the question, I am hung by the English syntax.  Often there are spelling errors.  I wish wish WISH that you would...