Why aren't you using Query Analyzer? It's a much better way to run your scripts.

-SQLBill

How are you trying to connect Enterprise Manager? Are you using the SA account?

What errors are you getting (look in the Windows Event Viewer logs)?

Can you connect using Query Analyzer?

-SQLBill

Update your service pack to at least SP3a and make sure your SA account has a strong password.  Then retry your script.

-SQLBill

Like I said, you asked for everything from 31/7/05 00:00:00.00 up to 1/8/05 00:00:00, so you won't get any values from the 1st of August.

Either include the time or go...

Did you say you are using this for a view? Try adding an ORDER BY to the script and see if that works.

-SQLBill

Try this:

USE Finance

SET ROWCOUNT 10

SELECT *

FROM SysObjects

See if that works in both databases.

-SQLBill

Check what Compatibility Level the database is set for.

Use Enterprise Manager, find the database, right click, select Properties, go to OPTIONS tab. At the bottom it will show your Compatibility...

One issue with DATETIME is that it includes the TIME.  If you don't supply a time, then the default is 00:00:00.000.

So, BETWEEN '2005-08-09' AND '2005-08-11' is actually BETWEEN '2005-08-09 00:00:00.000'...

If 'spotting typos' wasn't the issue, (and I don't agree the ', norecovery' was a typo, that's a major error), then one of the answers should not have been:

An error...

Since I had submitted my paperwork before knowing about the SSC code, is there anyway to get that added after the registration has already happened?

-SQLBill

Naw......she knows better than to pull that one........

It was a scented candle and she just wanted some good scents while she computed. I told her she should have gone for the...

Did you check the services? Are they started?  If not, manually start them.

-SQLBill

In Enterprise Manager, right click on the instance, select Properties, click on Startup Parameters. Make sure those show the correct locations.

Also, you can right click on the My Computer icon,...

Fingerprints are NOTHING! My daughter had a lit candle on the top of her computer monitor. For two days now, she's been trying to clean the wax off the screen.

-SQLBill

Where is the new drive? Is still a part of the server or is it a network drive?

If it's a network drive, that won't work. It must be an attached...