While I like the informative articles that this site tends to publish in it's newsletter, do we really need the astroturfing articles? Yes, barcoding is cool, but as Phil...

In Enterprise Manager you will only be able to backup to either local or mapped drives. In order to map the drive, either go through Windows Explorer (Tools -...

The dilemma is actually the fact that I don't have enough room on the filesystem to do the copy.

This is the reason for the "with truncate only" on the backup...

Somehow the idea of trusting my data to a bunch of (supposedly) well crafted stored procedures scares me. One of the databases I dealt with in the past took...

You mention 3 AND operators, are they in this query as well. i.e. There is more to the WHERE clause than first posted? Keep in mind that anytime you...

With a little less drama than the previous response, why do you want to do it one row at a time? You're going to slow the delete process WAY...

Your best bet is going to be to use an identity column in the temp table. For the initial select statement try something like:

select
  distinct
  Identity (int,...

This may or may not pertain, depending on how you are doing the mailing. Assuming you are using xp_sendmail:

When you run the job manually, it will use your mail...

I couldn't say why the output variable isn't being returned. However, would it be possible to simply select the number you want as an output variable into another record...

For each database there should be a sysfiles table, that should have the data you are looking for.

e.g.:

use northwind

select

name,

filename

from

...

Yes, but you need to modify the ACL on the service to allow start and stop privledges to a user/group for that service.

Try this article, method 3:

http://support.microsoft.com/default.aspx?scid=kb;en-us;288129

Within the DTS package creation utility, in Enterprise Manager, you can set the order of events, and what path that order will take on success or failure of a step....

It's really going to depend on what the query is doing and what type of data it is going against. If the data is mostly static, consider setting up...