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

note that the number of milliseconds will overflow an int value, so you've got to use a bigint datatype:

declare @DateOfInterest datetime,

        @EpochDate datetime,

 @millisecs bigint

set @DateOfInterest = '12/11/1962'

set @EpochDate      = '1/1/1970...

how about this?

sp_MSforeachtable @command1="select '?' AS TABLE_NAME,count(*) from ?"

results:

TABLE_NAME                  

---------------- -----------

[dbo].[SFPORGLM] 0

TABLE_NAME                 

--------------- -----------

[dbo].[GMHOME1] 426

etc.

syntax-wise, it raises no errors in SQL Query Analyzer; the sybase statement needs no conversions to get it to be correct in SQL Server.

without the data, i do not know...