The cross-reference to authors isn't such a big deal to me. However, I am a 'nit-picker' when it comes to typos. I've thrown out books because of too many typos....

What do you mean 'can sql server agent run in Windows98'?

SQL Server Agent is part of any SQL Server install. So if you can install SQL Server, then the Agent...

Shouldn't cause you any problems. But use MOVE instead of COPY.

I've done the same thing with a 200+ GB database. You don't even have to stop and restart services. In...

I like to see the answer regardless of whether I answered or not. Some days I know that I don't have a clue as to what the correct answer is;...

Here's a unique situation, I'm the DBA and my developer has limited rights to the database.

What's unique about that? I'm both. I created two LOGINs, one for my position as...

Use Enterprise Manager, drill down to the database, right click on the database, select Properties, go to the Options tab.

Is Auto-Close checked or unchecked?

It should be UNCHECKED.

If it's checked, then...

Something to consider for future books (and I hope there will be more books)...

It would have been nice to have each new article start at the top of a page....

I got my book! Thank you very much.

One interesting thing I've noticed.

I have printed several scripts, etc. for my own use over the past year. Guess what? Almost every single...

When you are using a trusted connection (Windows Authentication), your LOGIN and PASSWORD MUST be the same on both the SQL Server and the client machine/application.

-SQLBill

Are you seeing any errors in the SQL Error Logs? How about the Windows Event Logs?

You might have Auto-Close turned on. Use Enterprise Manager, drill down to the database, right...

If they are only the day of the year, how do you know which year they are for?

For example...Julian date 060 is March 1st ONLY three years out of four....

Thanks for the responses. I think I'm going to have to scrounge for a server and build it as a test bed. Then I'll be able to install SQL Server...

Okay, I found it....

refer to the Books OnLine for SP_CONFIGURE.

some of the Memory Options are:

min server memory

max server memory

-SQLBill

What you are noticing is by design. MS SQL Server is designed to grab as much memory as it needs. Then, because it needed it once, it might need it...

SELECT MAX(myid)

FROM mytable

Replace myid with whatever column name is the ID column and replace mytable with the proper table name.

-SQLBill