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

i found out that hind_ items are hypothetical indexes that are used by the index tuning wizard, they are supposed to be auto-removed when the tuning is done; see:

http://support.microsoft.com/kb/293177

The...

Remi's knowing the nuances of allowable indid and status values lets him use that to find the drop statements; you'd still have to wrap that into a cursor to get...

The script below uses a cursor nested within a cursor to get the job done.

in this case it drops ALL statistics, leaving indexes alone.

SET NOCOUNT ON

--ONE OF THOUSE HORRIBLE...