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

hopefully someone else will chip in on how to alert the operators;

all services on a server can be started and stopped with the NET START /NET STOP command: