the error you received is because child records exist which are not in the parent/referenced table;

run this query:

SELECT CLINICPHONE AS MISSINGCLINICPHONE,* FROM DBO.CENTER  WHERE CLINICPHONE IS NOT NULL AND CLINICPHONE...

I don't think the time to run DBCC CHECKDB is a function of the size of the database only, but rather a combination of something like

(number of tables) *...

On my dev box I had sql7 as the default instance , and SQl 2000 and SQL 2005 as named instances;

from the SQL standpoint I had no problem, and all...

I think that due to foreign key constraints, a cursor is not the right solution.

i would recommend adapting the Hierarchy2 script from this site.

http://www.sqlservercentral.com/scripts/contributions/759.asp

it returns all tables in the...

Another text editor with syntax highlighting, which also prints in color is EditPlus http://www.editplus.com

another pointer...you should never have a trigger actually send an email; it can take several seconds for the email step to occur, and if there is a network  or other...

offhand, i'd bet a buck on the second sql statement, which inserts into delivery_detail.

i'd say change the 3 LEFT JOIN's to LEFT OUTER JOIN's

if the join for those 5...

Found it myself;

Query Analyzer uses the dll sqllex.dll for the definitions of keywords.

i did the old regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqllex.dll"

and it fixed the issue; hope that helps someone else...

Are you sure the data is being deleted, or is there an error in the code and the details never get saved in the first place?

you could grab some of...

couldn't you create a view of the table that has the results of the udf as additional columns of the table/view?

for example create view vw_sometable as

select col1,..colN,dbo.fn__special1(col5) as Result1,dbo.fn__special2 (col5,col6)...

the semicolon is also recognized as a command separator, if that helps.

i would bet that a connection string is incorrect when it is moved to production...

I don't know your app of course, but if the connections string is hardcoded to look...

I typically see this when an ADODB connection has not been opened, and then you try to open a recordset with the still closed connection;

for example:

dim conn As New ADODB.Connection

conn...

As far as I know, the ONLY way to save your xml is using an application stream for SQL 2000. SQL 2005, with it's more robust XML support, may offer...

apparently a hind_ can be either a hypothetical index or a hypotehetical statistic; note how the tweak the dynamic sql based on the objectproperty:

from the same MS KB article:

DECLARE @strSQL...