If the intention of the query is to return most if not all of the columns from the table, and the order nor the exact number is important to the...

give ownership of the object to someone else or drop the object.

This would be the fastest:

select

ORDEREDCount = sum(case when ORDERED=1 then 1 else 0 end),

CATALOGUEDCount = sum(case when CATALOGUED=1 then 1 else 0 end),

PRINTEDCount = sum(case when PRINTED=1 then 1 else...

This may be a job for service broker. Earlier steps result in a message (or messages) being placed in a service broker queue and the subsequent steps are processed...

having a choice I would tend to favor the second version. It has the potential (depending upon table structure) to be faster.

I assume both of these SQL server instances are not named instances (they are using the default: name of the machine). Have the servers they are running on been renamed?

You...

I think it would be good practice to always do an initial full backup on a database as a part of the creation procedure. If for some reason you can't...

VB is a language a lot of people use or have used but it has contributed to more poor programming techniques and software in general over the years (in my...

hehe yeah. The early internet days... when there were no hackers... credit card numbers you entered on straight http forms got sent back to the server as a...

What company do you work for? I want to make sure I don't buy anything from them with a credit card....

Yeah, well the solution I finally adopted was to write a little .NET program that generates csv files. Its a command line driven utility (so you can use it in...

use a stored procedure instead of a select and have the stored procedure return a result set that includes the column names.

Take a look at some of the white papers out there they usually have a basic format you can use.

My advice is to follow the general guidelines of having...

MARS is available to .NET provider and SQL Native Client as I stated. You need to enable it in the connection string, and your application code must be written so...

You will have to query the sys.sysusers table in _each_ database to determine if the particular user has access. This is further complicated by the fact that the login can...