RE: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Dan Covill
A couple of days ago I stumbled over this: https://msdn.microsoft.com/en-us/library/hh510202.aspx It's a new form of SQL Server Express called "LocalDB", and is supposed to reduce required complexity and overhead for software developers/testers. Looks good but I haven't investigated further.

RE: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Richard Kaye
SSMS = SQL Server Management Studio. This is actually the 2008 R2 version I just found. And then there's the 2014 download but it's not 100% clear to me if this is time limited in any way since the page refers to "eval".

Re: FoxPro/DOS 2 Lines per record in a browse?

2015-03-31 Thread Michael Glassman
This is an example of FoxPro’s (both DOS and Windows) inconsistency and quirkiness. Calculated columns in BROWSE, CHANGE, and EDIT commands must always be assigned to a new variable name. Calculated columns in LIST and DISPLAY statements must NOT be assigned to a new variable. Just to keep us

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
I need the enterprise manager (or whatever it is called now) software because I don't have time to learn to manipulate express. Thanks, On 3/31/2015 2:53 PM, Richard Kaye wrote: Large is a relative term, Jeff. Does it exceed the capacities of the current Express version? If not, you should b

RE: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Richard Kaye
Large is a relative term, Jeff. Does it exceed the capacities of the current Express version? If not, you should be able to just get that. And one change over time is they also make SSMS available to Express users. It used to be SSMS was not available so you got the engine but not the dev tools.

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
Database is large. Thanks and you better not go anywhere! On 3/31/2015 2:35 PM, Ted Roche wrote: Or the SQL Server express 2008 R2 edition, which is what you asked for initially! http://www.microsoft.com/en-us/download/details.aspx?id=30438 Surprised to see these still available. On Tue, Mar

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Ted Roche
Or the SQL Server express 2008 R2 edition, which is what you asked for initially! http://www.microsoft.com/en-us/download/details.aspx?id=30438 Surprised to see these still available. On Tue, Mar 31, 2015 at 5:33 PM, Ted Roche wrote: > I should be here less often :) > > If the database isn't hu

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Ted Roche
I should be here less often :) If the database isn't huge, you could probably get by with SQL Server Express: http://www.microsoft.com/en-us/download/details.aspx?id=29062 On Tue, Mar 31, 2015 at 5:32 PM, Jeff Johnson wrote: > Thanks Ted. Stephen must be absent today. We miss you when you ar

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
Thanks Ted. Stephen must be absent today. We miss you when you aren't here. ;^) On 3/31/2015 2:28 PM, Ted Roche wrote: I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Ted Roche
I yield to the other DBAs here. I consider SQL Server a read-only product to migration to other databases. My DBA experience is a decade out of date. I thought there was discussion here on a FREE developer edition, but now I can't locate that thread. $49 seems like a reasonable deal. I would exp

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
That link takes me to Amazon and SQL Server 2014 for $49.00. Can I restore a backup of 2008 R2 into this? The $49 is okay by me. On 3/31/2015 2:06 PM, Ted Roche wrote: Jeff: FREE should be the price: http://leafe.com/archives/full_thread/498425 On Tue, Mar 31, 2015 at 4:48 PM, Jeff Johns

Re: FoxPro/DOS 2 Lines per record in a browse?

2015-03-31 Thread Ted Roche
Not sure the help is all that helpful when it comes to "everyone once knew this." Try: change fields fred=fieldname1+' '+fieldname2+" ", fieldname3 Essential, you're creating a calculated field, fred. It doesn't have to be named that, but it always worked for me :) On Wed, Mar 25, 2015 at 8:2

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Ted Roche
Jeff: FREE should be the price: http://leafe.com/archives/full_thread/498425 On Tue, Mar 31, 2015 at 4:48 PM, Jeff Johnson wrote: > I need to purchase the subject software for a one time project on my > computer only. I have seen prices from $32 to 32,000 and can' t make heads > or tails of i

Re: FoxPro/DOS 2 Lines per record in a browse?

2015-03-31 Thread American Sentry Systems, Inc.
I tried: change fields fieldname1+' '+fieldname2+" ", fieldname3 "I got a unrecog phrase/keyword in cmd" error by the way, I am running 2.6 if that is material John On 03/25/2015 04:44 PM, Ted Roche wrote: I'd forgotten about CHANGE! I believe EDIT is a synonym. Clever work-around! On We

Re: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
Can't afford it for this project. All I need to do is restore a backup and export data from the database. Thanks, On 3/31/2015 1:52 PM, Virgil Bierschwale wrote: When I was active, this was how I stayed up on software https://mspartner.microsoft.com/en/hk/pages/membership/action-pack-subscri

RE: [NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Virgil Bierschwale
When I was active, this was how I stayed up on software https://mspartner.microsoft.com/en/hk/pages/membership/action-pack-subscribe .aspx -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, March 31, 2015 3:49 PM To: profox@leafe.co

[NF] SQL Server 2008 R2 Developer Version

2015-03-31 Thread Jeff Johnson
I need to purchase the subject software for a one time project on my computer only. I have seen prices from $32 to 32,000 and can' t make heads or tails of it. I purchased an earlier developer version of SQL Server and it fit my needs perfectly. Can someone tell me the least expensive way to

InfoWorld mention of FoxPro

2015-03-31 Thread Ted Roche
Former Byte columnist, Microsoftie and New Hampshire resident Jon Udell posts a blog entry on InfoWorld: Wanted: Easy database app dev tools for the Web "Programming languages, application frameworks, SQL or NoSQL databases, data-binding mechanisms, templating libraries -- they're all up for grab

Re: SYS(2015)

2015-03-31 Thread Christof Wollenhaupt
> > Anyone know how to reverse engineer this function so that you get a > datetime value? > Here's the C# version that generates a SYS(2015) value. It's three characters for the year/day and six for the milliseconds within the day: https://bitbucket.org/cwollenhaupt/guineu/src/6daa05f4c05df6663b5

SYS(2015)

2015-03-31 Thread Laurie Alvey
Anyone know how to reverse engineer this function so that you get a datetime value? Laurie --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com S