Happy 3005th to you!

-Bill

szopdog,

The easiest way to set up a job is to use Enterprise Manager. Expand your server, expand Management, expand SQL Server Agent. Right-click on Jobs, select New Job. Build the...

The BIGGEST thing about ORACLE and MS SQL Server that was left out was ADMINISTERING the databases. I originally was looking for work as an Oracle Programmer. When I applied/interviewed...

Why go through all that trouble? Just give SA a secure password.

-Bill

First, if you include the PersonID in the other three tables it will make JOINs easier. For example:

Select *

From Person P

Left JOIN Date D

On P.PersonID = D.PersonId

Last, varchar will do...

The colon (:) with a variable (:v1) identifies a 'host variable'. A host variable is a C-program variable. See the Books Online, go to index and look for 'host variables'...

I am looking into making the queries run as stored procedures. But I still have to answer, to my boss, why Crystal Reports is being so slow. And I don't...

I think I got the answer to my problem! It came from another site. Apparently it's documented bug.

It's in Microsofts Knowledge Base Articles (Q294412).

-Bill

HermitD,

I'm not connecting via ODBC, I'm doing all this right on the SQL Server machine.

Greg,

I think you may be right. I've even posted this on someother sites and haven't gotten...

I rebooted the server, stopped and restarted SQL Server Agent service and SQL Server service. Still no luck. This is really bugging me since it works properly in Query Analyzer...

Okay, I added the SELECT @@option&512 and ran it as part of the job. It returned 512 (SET NOCOUNT ON) but I still got the (1 row(s) affected) message. This...

OOPPPSSS, I guess I really should include my question....

Any ideas why SET NOCOUNT ON isn't working on my second server?

-Bill

I use autoshrink on my database (165+ GB) without any problems.

-SQLBill

Thanks Steve. I'll work with Profiler for now. I know about the ebook, I've seen it recommended on this site and the SQL Server Worldwide User's Group (www.sswug.org) site. I...

The same query run in QA runs just fine. It doesn't appear to be user related, more query related. Over on another site (with a Crystal Reports forum) I got...