You can change the db owner if you need to. sp_changedbowner.

I'd script out the permissions from the old db and this should run fine on the new db. The scripting...

sysjobhistory.run_status. A 4 indicates it is running.

Good suggestion. We'll see about implementing that.

Prior to VB.NET, I think VFP was the best. I used v1 to rewrite a Fox for Windows app with SQL as the back end and after a year of...

Allen's suggestions are the only way. There really is no other method and SQL does not track this.

I've actually used VMWare as well (http://www.sqlservercentral.com/columnists/sjones/buildingademosystempart3.asp) and it is great. I've got a better solution than that for high end corporations, and one that works extremely well.

Using customer's...

Is everything working now? It's hard to tell from the post. Are your jobs executing?

I don't think they are the same. With a detach the db is removed from the server. With offline it's still part of the server architecture, just closed and unavailble...

Open, save under a different name.

The licensing mode doesn't affect the operation of the server. It's more of an administrative thing. If you just purchase the per CPU licenses, you are covered. Just add it to...

There shouldn't be a difference. I'd have to do some testing and see. Will try a bit later.

chris's idea is probably the simplest. Not sure this will get you what you want (multiple result sets), but there isn't an easy way to do that. Could insert the...

I'd change to ANSI syntax, but it should work.

SELECT DISTINCT

            p.productId,

            p.productName

January 13, 2004 at 10:47 am