I can't find that error in a search, but you might try running this from the command line (VBScript) and see if there's a better error returned.

I know everyone is busy, but voting helps authors. It's a second to vote on an article.

A "good job" or "nice article" goes a long way as well. You don't...

Might start somewhere like this: http://www.cs.bris.ac.uk/maintain/OracleDocs/server.816/a76994/logical.htm

I'd be curious to know how you did that, mostly to tell people not to do that.

Since system table updates are disabled in 2005, I'm not sure what you can...

Tend to agree with GSqaured, don't forget size 🙂

No matter how you want to report it, you want to break out the repeating elements, like color, and drop them in...

I'd use Mark's solution if that's what you need. You don't want to write lots of subqueries as you're scanning the table multiple times and will take a big performance...

I believe that's a 2005 only construct. If you are running 2000, you posted in the wrong place. Let us know and we'll help.

In 2000, there's no good way to...

Or better yet, Camtasia your screen when you're analyzing something, record the actions, and then play them back in a loop 🙂

How did you move the databases over? Was this a wizard or backup/restore?

The logins don't move, so you have to move them. The easiest way to do this is search...

Look at your dateimport. They include times, so you are likely getting a "count" for each group of the time, not the date.

If you need it by date, then extract...

Once you get SSMS, you need to "Connect" to your instance since you're working in client server mode now. SSMS won't "Open" the database.

Go to Databases, expand that, then expand...

1...2...3...4... enough recounting.

I'll add points back to the True's later :). The system doesn't allow "either or" answers. If I ticked both, both would be required.

Happy April Fool's!

Ian,

Thanks and it's tough writing every day, but it's also fun for me.

Once in awhile!?!?! Hopefully more often than that, or what that just the editorials? 😉

The Prius fits our family of 5 (6 ft, 6ft, 5' 10, 4' 6, and 4') fine. If we have all 5 of us in the car and a load...

There is actually an air car in the NY Auto Show slide show if you check it out as well. It's a neat idea, though anything highly compressed contains energy...