I found that to be a great script as well; the only change I made was adding a &nbsp; to the closing </TD> tag so that cells didn't appear wierd...

could you add a check constraint that says column2 must be less than or equal to column 1?

that would prevent 3,2 or 2,1 from inserting.

that way you enforce the order...

isn't this kind of situation used when you have multiple locations using the identical database, and you need to merge the databases back together at some point? also, i thought...

i read the question differently: can you execute sp_whatever, that exists on server1, on server 2.

my answer is that you must copy the proc to the other server. I think...

i THINK this sql will list all tables defined row size:  the LENGTH column in syscolumns has the #of bytes used for the column definition; a varchar(30) has 30, nvarchar(30)...

if you try to install the enterprise or standard versions of SQL server on your machine, it will automatically "dummy itself down" to the desktop version / MSDE.

the full verison,...

what happens when you need to tie all those tables together for a quarterly , semi-annual or yearly report?

you'll spend a ton of time writing reports or views which work...

neat; i found out that this is an extended stored procedure when i tried to sp_helptext sp_refreshview.

users become orphanded based on the SID tied to their login.

so if you create a user 'Bob' one one server, a unique ID (SID) is assigned to that login; if...

there is really nothing to it; you download the service pack , open it and it is a couple of NEXT>> buttons;

it will stop the server automatically,(so don't do it...

the issue is proably your CleanInput() recordset; if it is returning an empty string instead of NULL or ZERO for things that expect an integer value(like ATTEMPTS) then you'll get...

Query analyzer does not have the ability to prompt; you end up having to populate variables before you run the script like

declare @var varchar(50

set @var='somevalue'

select form sometable where val=@val

you...

another alternative is to DTS the tables in foreign key/dependancy order.

put the results of exec sp_MSdependencies in a table, and import the tables/views/procs in that order.

all of the log trolling software that is advertised here have the ability to identify and report against DDL changes as well.

there's a couple of  knowledge base article that might help: one has to do with raising the # of locks, and the other is due to a denial of service...