Hello,

Any chance you could post the Create Table statements to go with your script? Also some sample data Inserts would be useful.

Regards,

John Marsh

Hello,

I've not (yet) seen one for SQL 2005, but you could try this guide for SQL 2000: http://www.databasejournal.com/features/mssql/article.php/1438231

Regards,

John Marsh

Hello,

If it is not a firewall related issue then try specifying the Port in the connection string i.e. Ip-Address\instance-name,NNNN

(Where NNNN is the Port that the SQL Server Instance is listening...

Hello Tom,

I would suggest first looking at a few topics in SQL Server's Books Online e.g. "Using Clustered Indexes". You (almost) always want one of these on each table; more...

Hello,

When I tried out your script under SQL 2005, I got the following errors:-

Msg 8152, Level 16, State 2, Procedure sysmail_help_profile_sp, Line 20

String or binary data would be truncated.

(3 row(s)...

Hello,

Assuming you are using Kerberos, then does this post help: http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx

Regards,

John Marsh

Hello,

As you have posted to an MS SQL Server forum you will get a slightly biased answer as to your choice of DB Server. I would of course recommend MS...

Hello,

Has your Merge Replication been in place for a while? In which case does this thread relate to your issue (it is SQL 2000 related though):

http://www.mydatabasesupport.com/forums/ms-sqlserver/235830-replication-failure-problem-sysmergearticles-table.html

Regards,

John Marsh

Hello,

Thanks for posting this script.

From my testing though it seems the query does not return results for any Linked Servers that do not explicitly map Logins e.g. in the case...

Hello Sandy,

Glad to hear it is working fine.

Here is a link to a related article that you may also find useful: http://www.sqldts.com/210.aspx

Regards,

John

Hello,

Multiple users can execute the same DTS package, for example by using the dtsrun utility, or from a custom application. (Please see the SQL 2000 BOL topic "Executing a DTS...

Hello,

A useful Script, thanks for posting it.

One comments though: I don’t believe the example of using Set to supply multiple DB names would work. You normally have to use a...

Hello,

As you are doing an Insert then you would know the value of most fields. Is it just the Identity value created that you need? In which case you can...

Hello,

In Visual Studio (2005) - if you don’t already have a (test/dev) Database Project now would be a good time to create one. Add a DB Reference to your test/dev...

Hello,

For the record, it is worth noting that sp_depends only returns references to objects within the current DB i.e. if there are Views in other DBs based on the table,...