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...

It might be that they are connecting via enterprise manager with their Windows credentials, but connecting via Query Analyzer with a SQL login;

in that situation the SQL login might have...

assuming you know the tablename and the PK value you wanted to test for (assuming a single column for the PK)

This also assumes that Foreign keys are created, and not...

not enough information, i think Ashok;

do all the transaction tables have Foreign key references to the master table? Are you talking about the CASCADE option on foreign keys for update or...