the move command really just copied the file with the given name, and then deletes the previous file. there is no need to move it with the same name, and...

you might not be aware, but all error messages from sql server exist in the sysmessages table in master; around 3831 on my machine;

select * from dbo.sysmessages

a more common...

The foreign keys hierarchy can prevent you from just deleting data in the tables;

the script below creates a list of all the tables in hierarchy order, and creates the delete...

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