yaweah,

That's VERY interesting. Could you elaborate a bit?

Thanks,

Jon

Darcy,

Thanks for the tip about http://www.devbuzz.com/ --that looks like an interesting site.

Everyone,

Here are the answers I received from our Microsoft account rep:

- What Microsoft software package(s) would I need...

Randyv,

Our site does what Steve recommends, and it seems to work fine. If shrinking the log is important to you, you can turn on AutoShrink (search for AutoShrink in BOL;...

Jeff W,

Be sure you *practice* the master and msdb restores on a test server somewhere. There is nothing like real life experience for these two potential problems. Problems tend to...

I agree with yumfin. We typically install SQL Server in the D: drive so that we can do move to a SAN drive later without any registry hassles. It seems...

A while back, Compaq Support recommended the following to us for monitoring AWE memory:

select cntr_value, cntr_type from sysperfinfo

      where

            object_name = 'SQLServer:Memory Manager' and

            counter_name = 'Total Server Memory (KB)'

Watch...

The only problem we had was that our SCSI tape driver could not handle the /3GB switch, which meant that our backups failed until we could find the problem and...

We use the following code to recompile everything on a weekly basis. Hope this helps. It's [very] old code, and it's not very elegant, but it seems to do the...

Phill,

Would you mind posting your scriptlet in its entirety again (without the smiley)? The code sounds like a good idea, but I'm having problems getting it to work.

Thanks,

Jon

Bill,

Thanks for your response.

I found part of the IIS problem: ASP.NET needs to be "turned on" in Windows Server 2003, as does FrontPage 2002 Server Extensions:

Control Panel, Add or Remove Programs,...

I never really thought that much about decrypting stored procedures before, but Colin was right about the existence of code that decrypts them. It took me just a couple of...

Scott,

I assume that you need to download a 64-bit version of SP3a for this version of SQL Server. I looked for it on the Microsoft site, but did not find...

Thanks for the response. We have 40+ SQL Servers and have used the database engine since version 4.21a, but we're just getting started with the 64-bit eval. I got around this problem by...

Sorry... Maybe I missed the answer in the responses...

What is the "switch" that you are using to enable or display parallel execution?

Jon

Personally, I hate tons of email and as a heavy user of the site myself, lots of posts, I get tons. What I'd rather do is batch up the replies...