Hello,

Can you post an example of the SP execution that fails? Also can you provide the BlogEntry table’s definition?

Regards,

John Marsh

Hello Steve,

I would ask the same two questions of you i.e. has this Linked Server ever worked, and can you post a screen-shot of the Linked Server General Properties page?

Regards,

John...

Hello Norman,

Apologies for the delayed response, but I have been on holiday for a few days.

Did you ever get to the bottom of this?

As you have Triggers on the target...

Hello,

You could probably build a formatted report using this code snippet as the starting point:-

Select

*

From

sys.columns SC

Left Join sys.foreign_key_columns FKC

On (FKC.parent_object_id...

Hello,

The following thread provides a script solution (and also explanations of why you should normally not need to worry about maintaining column order in a table).

http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/f1281533-ad45-4bdc-867c-a9369a02de80/

Regards,

John Marsh

Hello,

There are a couple of threads around that suggest it may be as a result of memory issues on your server. May be take a look at these:-

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2689fb21-f3c8-4754-b0d0-09b91886c8ea/

Hello again,

Are the Replication updates being delivered to the Target Server? If so, then are there any triggers on the Target Tables that might be reversing the updates?

Regards,

John Marsh

Hello,

The code below is generic, but you could adapt it for your needs:-

Declare

@MyTable Table (MyColumn Int)

Insert @MyTable Values (100)

Insert @MyTable Values (-100)

Insert @MyTable Values (500)

Select

Sum(Case When MyColumn > 0 Then...

Hello,

This could be caused by different versions of SQL Server between the DB files and your new installation.

What is the output if you run "SELECT @@version" on the SQL Server?...

Hello,

You could accomplish this with a third party tool such Redgate’s Data Compare:-

1) Script the DB Objects.

2) Create an empty DB from this script.

3) Compare the original DB to the...

Hello,

I think adding a Having clause to your Select statement would do the trick.

Regards,

John Marsh

Hello,

I think this article describes the issue you are experiencing. It also suggests a possible solution:-

http://sqlug.be/blogs/por_dentro_sql/archive/2007/10/20/management-console-and-db-ddladmin.aspx

Regards,

John Marsh

Hello,

I would guess the issue is related to permissions of the Account under which the SQL Server Agent Service runs.

One way to test this theory out is to temporarily...

Hello again,

Hmm, I guess it isn’t a “big” problem as your application is working fine. It would be good though to be able to explain the cause - just to...

Hello,

I quite like http://www.searchwindowsserver.com (the sister site to http://www.searchsqlserver.com)

Regards,

John Marsh