indeed. have a look at Djikstra's or Floyd's algorithm for finding shortest path between nodes in a connected graph. I don't think it would be very efficient to...

in general, travel time between two points is not the same in both directions. most common example is airlines - because of prevailing winds it takes longer to fly...

I wouldn't consider doing this unless you have identified that your queries using these date functions have perf problems.

I have found that it's not a good idea to make assumptions...

if you are unsure about pulling the whole table over, you can always do this: INSERT INTO ... EXEC linked.db.dbo.sproc - then you can always be absolutely certain that the...

the \ character does not need to be escaped in t-sql. only the single quote character ' needs to be escaped. for example, try this:

select '\', 'abc\def', '',...

While code reuse is a good goal to have, you shouldn't sacrifice the security of your site to attain it.

Before you consider using dynamic sql for anything, you should read...

It looks like you need to generate sequential guids. correct?

if so you should check out Gert Draper's XPGUID library:

http://www.sqldev.net/xp/xpguid.htm

and if you are on 2005 (guessing you are...

This is an old thread, but I just had to add that SqlSpec is better than apexsql doc for this purpose. But then I am biased - I wrote...

SqlSpec uses these extended properties to generate a very comprehensive data dictionary. Link to it is in my sig below.

somewhat late on this thread, but SqlSpec will do what the poster wants. Link to it is in my sig below.

I know this thread is very old, but I have to add SqlSpec to the list. It's quite a bit better than the two listed above.

I would avoid doing this if you can. Cross server joins are usually VERY slow. It's much better to have both tables you want to join on the...

ok, this is fixed now. problem was the code was trying to script schemas, and schemas don't exist on 2000. SMO is rather strict about what you ask...

oops!  I should have tested this on 2000   The problem is the tool is trying to script an object that doesn't exist in...

well, I have found that the publishing wizard pretty much sucks. It doesn't even work against pubs!!

Here's the error I get:

Generating script for database pubs

- Including default object types...