Generally, the join order does not make much difference. SQL Server does a lot of work building the query plan and it normally ends up with the same plan...

I have just created a transactional publication (of table Customers in Northwind) on a SQL 2000 instance and created a push subscription to a SQL 2005 instance. The initial...

Have a look at "Timestamp data type" in books online.

In part, this says...

timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique...

Launch "Enterprise Manager", register the server, and then navigate to "Replication Monitor"

The Log Reader agent does not apply transactions to the subscriber database. Its role is to extract transactions from the transaction log of the published database and store them...

Have you configured the "Response" for the alert ? By default, alerts are not configure with a response which means that even if the alert condition occurs, nothing will...

Do you use any msgbox or inputbox commands in your activeX task ?

FYI : the "bunch of random characters" are not really random. They are in fact an encrypted equivalent of the parameters required to run a particular version of the...

Error handling for calls to extended sprocs isn't that easy.

You might have to make some assumptions. The only thing of use I could dig up was the following code...

I think that this is in

HKLM\Software\MSSQLServer\Setup

The key SQLDataRoot is probably the one to go with.

This information is stored in the registry. Have a look at

HKLM\Software\Microsoft\MSSQLServer\MSSQLServer

If there is a non-default value for the log/data files, you will see an entry for "DefaultData" and...

The size of your data and log files should be set so that they would not normally need to grow during prime time. If they need to grow, the...

Try

exec sp_changeobjectowner @objname = '[Win03\firstName.LastName].[ARCMonth]', @newowner = 'dbo'

You need to use square brackets to delimit he part of the name of the object. In your example, you are specifying...

If you are using SQL 2005, have a look at the output from the DMV called sys.dm_db_index_usage_stats.

If you are using SQL 2000, you cannot definitively find what indexes have never...

Have a look at DTSRun in books online. It describes how to run DTS packages and the various switches you need. Using this information, you can create a...