Viewing 15 posts - 35,371 through 35,385 (of 39,720 total)
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...
January 15, 2004 at 10:05 am
Allen's suggestions are the only way. There really is no other method and SQL does not track this.
January 15, 2004 at 10:02 am
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...
January 15, 2004 at 9:56 am
Is everything working now? It's hard to tell from the post. Are your jobs executing?
January 13, 2004 at 1:53 pm
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...
January 13, 2004 at 1:48 pm
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...
January 13, 2004 at 1:38 pm
There shouldn't be a difference. I'd have to do some testing and see. Will try a bit later.
January 13, 2004 at 1:31 pm
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...
January 13, 2004 at 10:49 am
I'd change to ANSI syntax, but it should work.
SELECT DISTINCT
p.productId,
p.productName
January 13, 2004 at 10:47 am
As David mentioned, if you run this in the non production database you will be fine. Only affects the current database in which it is run.
January 13, 2004 at 10:45 am
today's headline as well
http://www.sqlservercentral.com/columnists/ckempster/sendingalertsviaacustomsmtpprocedure.asp
January 13, 2004 at 10:44 am
Write a script to delete the account or change to deny access in 10 days and schedule it.
January 13, 2004 at 10:43 am
A few thoughts : http://www.sqlservercentral.com/columnists/sjones/whodoyouhire.asp
Feel free to steal some QOD questions if you want. They will at least give you an idea of this person's knowledge. I'd put them...
January 13, 2004 at 10:40 am
Agree that if the load is expected to be high, SQL provides much better concurrency over Access. Access is best and cheaper for small numbers of users.
January 13, 2004 at 10:31 am
Viewing 15 posts - 35,371 through 35,385 (of 39,720 total)