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

how about:

SQL Server Web Data Administrator

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

well i could see that you can add viewnames with the identical table names for each of the 450 lookup tables, and use them in your application, but that would...

older versions of Adobe reader supported a command line /t, so you could call acrord32.exe with the proper command line parameters in order to print and then kill adobe reader;

this...

cross database foreign keys are not possible; the best you can do is create a trigger that performs the logic to make sure the relationship exists that you are trying...

not directly from TSQL, no; you'd have to write a program that would prompt for input, and then use the input in the sql to be performed;

Oracle (or rather, SQL...

i learned a bit more myself; if you go to a command prompt and type net start the list of all services will be displayed;

pretty much every service listed will...