I'm not sure why you are using the "instead of" type of trigger.  With the "after" type of trigger you don't need to delete the row.  Also, I don't think I...

Thanks for the tip!  I just found this article, http://www.winnetmag.com/Windows/Article/ArticleID/43117/43117.html, on the subject thanks to your suggestion. 

I think they are going to try to match processors and drives...

I went though the same headache two years ago.  The problem was the encrypted DTSrun command.  I now write my own dtsrun statement and use trusted authentication.  The only thing I...

Try this:

update a

set a.from_dept = b.to_dept

from dummy a join dummy b on

a.o_id = b.o_id and b.o_tmst = (select max(o_tmst) from dummy c where c.o_id = a.o_id and c.o_tmst < a.o_tmst)

Kathi

By default only sysadmins have permission to use it.  But if you run this "grant execute on xp_smtp_sendmail to public" then everyone will have permission to use it. ...

Go to http://www.sqldev.net/xp/xpsmtp.htm for a SQL Mail alternative.  I am using SQL Mail on several servers.  I haven't had problems getting it configured -- but then we are on Exchange. ...

A couple of "slammer-safe" MSDE installations were recently installed in our environment.  No network protochols were installed by default. 

Install Enterprise Manager on the box and check the network protochols.

Thanks for your feedback.  I am definately going to insist on a trial period with a couple of dev systems to see what happens.

Our firm recently implemented a NetApp filer and is using it for Exchange.  I just found out that the intention is to move some or all of our SQL Server...

Wow!  That worked.  I've written VBScript for years and never came up against this problem before.  Thanks.  You saved me from writing some ugly code.

Kathi

This is how I do it and I haven't have any trouble with precedence:

1.  Select the first task that I want to run

2.  Hold the shift key and select the...

If all of the tasks are connected in one workflow, the precedence should flow according to the workflow arrows.  If you have multiple workflows, then I guess it is up...

I just noticed you are possibly going to have trouble with your query.  It should probably look like this:

select dnrt_phone_numb,dnrt_agency,dnrt_in_date

from super_dba.dncrt

WHERE (DNRT_IS_DATE > 20040601 OR       

        DNRT_FG_DATE > 20040601...

Search for "Lookup Queries" in BOL.  It has exactly what you are looking for.

Kathi

I am pretty sure you will have to have MS Access installed on the server to do the compact and repair function.

What about this:

Create an Access database with the empty table objects --...