What I am actually interested in is how, if it is possible, to save multiple result sets to a temp table or tables.  If I run sp_spaceUsed without a parameter...

You can backup x and then restore it to x2 using the "With move" syntax to move the files. You can do this using Enterprise Manager, changing the...

I may have misunderstood the question, but I think she is saying that completely duplicate rows were accidently added. If that is the case, my solution would work.

Don't know what kind of crappy code Access is generating for you that is different from your non-junky book, but inner and outer joins, union queries and most sub-queries will...

Try this:

Select [Number_of_Shipments],1 as sortORder from [QryTotal];

Union

Select [Weight],2 from [QryTotal];

Union

Select [Charge],3 from [QryTotal];

Union

Select [Additional_Costs],4 from [QryTotal]

order by sortOrder;

The bad thing is that now you have an additional column. You...

Just a hunch, but when you change the table definition in SQL you usually need to refresh the link from Access. I know this is the case when adding...

I wouldn't call this a bug, SQL is evaluating @X = -1 for each row so it is using a scan. It can't use the primary key to find...

Basically it means that when you deploy your application the datasource will not be overwritten on the server. This is nice if you are pointing to a development database...

I don't see why you are using a subquery. I would remove the "(Select " right after Expr3. This looks like a simple join to me.

I was called in to help with a situation a few years ago where they were using the SQL agent for either Backup Exec or ArcServe for their backups. ...

There are great tools available, like SQL LiteSpeed, to compress the backups. When you use one of these utilities, the file can only be restored by using the same...

Actually, setting up an automated install isn't that bad. I did it a couple of years ago for about 15 servers. There is an article in BOL that...

Post your code and maybe we can figure out what the problem is.

This should work with an aggregate query:

INSERT INTO current                                                                                          SELECT [Unique ID] AS UniqueID, Country AS Country, [Company Name] AS CompanyName, [Deal Name] AS DealName, [Line Amount] AS LineAmount, [SR Name]...

I am using log shipping to replicate one database.  When log shipping breaks, I have a VBScript that creates my log restore script for me to get it caught up...