RE: [NF] Anyway to discover/reset MSSQL UID and PW?
Vince, If you are not reengineering the database model then you need to consider the Sedna Upsizing Wizard. I have used it numerous times in testing and it has worked every time. I am talking about migrating structures *and* data to SQL Server 2000 and 2005. You can run the wizard or you can programmatically control the engine (especially useful if you have to migrate the same database numerous times - think vertical market app). This is not the old wizard warmed over for Sedna. This is a usable tool. Rick White Light Computing, Inc. www.whitelightcomputing.com www.rickschummer.com 586.254.2530 - office 586.254.2539 - fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Wednesday, December 13, 2006 11:55 PM To: [EMAIL PROTECTED] Subject: Re: [NF] Anyway to discover/reset MSSQL UID and PW? Ted Roche wrote: On 12/13/06, Vince Teachout [EMAIL PROTECTED] wrote: In this case, it was for a support call for an existing client, so time was of the essence. However, it turns out that for MY branch of the project, no one has ever actually done the SQL version, so I get to do exactly what you said - create it from scratch. By New Year's. Ho ho HO! Ouch. I guess the Upsizing Wizard won't help out here, eh? No, but the God, this is boring - I wonder if I can automate this function MSSqlMe() I wrote about 4 years ago to rewrite VFP tables into MSSql tables is certainly coming in handy! :-D [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Anyway to discover/reset MSSQL UID and PW?
My all time favorite: I received a call from our company receptionist, her keyboard was beeping. Not the computer, not the speakers, the keyboard. I purchased the systems, so I knew our keyboards didn't have speakers. So I go upstairs and sure enough there is a beeping sound coming from under Carolyn's keyboard. I opened her desk drawer and handed her the pager that was going off. Ted Roche wrote: Well, ya know, I'd hate to miss the obvious solution. I'm embarrassed to admit how many of my troubleshooting sessions could have been shortened with (1) is it plugged it? (2) is it turned on? (3) is the little green LED on the front on? Or, my own personal favorite, Is the keyboard I'm typing on actually connected to the machine I think it is? _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the originator of the message. This footer also confirms that this e-mail message has been scanned for the presence of computer viruses. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Merle Norman Cosmetics. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
Rick Schummer wrote: Vince, If you are not reengineering the database model Condition false, fall through to next line. :-) then you need to consider the Sedna Upsizing Wizard. This is not the old wizard warmed over for Sedna. This is a usable tool. That sounds like something that will be handy in the future. Where do I get it? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
Matthew Jarvis wrote:
Vince Teachout wrote:
snip
No, but the God, this is boring - I wonder if I can automate this
function MSSqlMe() I wrote about 4 years ago to rewrite VFP tables into
MSSql tables is certainly coming in handy! :-D
Vince-
That sounds like it could be handy - care to post the code?
I've been thinking about posting my ME() functions for some time:
SqlMe() - creates a SQL Select statement in the clipboard for the
current WA, with several options
InsertMe() - Creates a Insert statement in the clipboard, with several
options, and also creates the VALUES clause with a leading character
that indicates what kind of data is expected. Plus, bonus, it sounds
naughty.
CurseMe() - creates a FILE containing a CREATE CURSOR statement for
current WA, with lots of options
MySQLMe() - Creates a MySQL CREATE TABLE statement, etc...
MSSQLME() - Creates a MS SQL CREATE TABLE statement, and IIRC, creates
the ALTER Table command for the Primary index, and the index commands
for the other indexes
MyAccessMe() - ditto for Access
ORASQLME() - ditto for Oracle
OraDate() converts a vfp date to Oracle TO_Date command for use in
queries: e.g. OraDate(date()) = To_Date('12/14/2006','MM/DD/')
NvlSQLMe() - creates a SQL Select statement in clipboard with all fields
NVL'd: SELECT NVL(Spons_uid, '') AS Spons_uid... etc...
WaitGlass() - turns hourglass cursor on/off
These things save me hours of time doing repetitive, boring coding. If
there's any interest, let me know and I'll e-mail code to whoever wants
it. If people STILL think it's useful after getting and trying the code,
let me know and I'll talk to Ed about putting it in the downloads section.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
Vince Teachout wrote: These things save me hours of time doing repetitive, boring coding. If there's any interest, let me know and I'll e-mail code to whoever wants it. If people STILL think it's useful after getting and trying the code, let me know and I'll talk to Ed about putting it in the downloads section. How about posting them on the downloads site?http://leafe.com/dls/vfp -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Anyway to discover/reset MSSQL UID and PW?
That sounds like something that will be handy in the future. Where do I get it? Sedna October Community Tech Preview (CTP, aka. pre-beta) http://www.microsoft.com/downloads/details.aspx?FamilyId=808E96E1-3D87-421F-9BA5-4AAFE70C7B21displa ylang=en But as I said, the Upsizing Wizard is very stable and reliable even at this stage. Loading the Sedna components does not overwrite any of your VFP 9 install. The SP2 install does affect the VFP 9 install, and is not required for the Sedna CTP components. Rick White Light Computing, Inc. www.whitelightcomputing.com www.rickschummer.com 586.254.2530 - office 586.254.2539 - fax ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
On 12/13/06, Vince Teachout [EMAIL PROTECTED] wrote: Is there a way to find out, or reset the UID/PW, since I have physical possession of the box? I'd rather not have to rebuild everything from scratch. Thanks. You dont say, but I presume you've already tried 'sa' and blank, 'sa' and 'sa' ? -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
On 12/13/06, Vince Teachout [EMAIL PROTECTED] wrote: Is there a way to find out, or reset the UID/PW, since I have physical possession of the box? I'd rather not have to rebuild everything from scratch. Thanks. http://www.mssqlcity.com/FAQ/Admin/forgot_sa_password.htm -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
Ted Roche wrote: On 12/13/06, Vince Teachout [EMAIL PROTECTED] wrote: Is there a way to find out, or reset the UID/PW, since I have physical possession of the box? I'd rather not have to rebuild everything from scratch. Thanks. You dont say, but I presume you've already tried 'sa' and blank, 'sa' and 'sa' ? Yeah, I'm not that far gone, yet. :-) http://www.mssqlcity.com/FAQ/Admin/forgot_sa_password.htm That'll work - thanks! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
On 12/13/06, Vince Teachout [EMAIL PROTECTED] wrote: Yeah, I'm not that far gone, yet. :-) Well, ya know, I'd hate to miss the obvious solution. I'm embarrassed to admit how many of my troubleshooting sessions could have been shortened with (1) is it plugged it? (2) is it turned on? (3) is the little green LED on the front on? -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
Ted Roche wrote: On 12/13/06, Vince Teachout [EMAIL PROTECTED] wrote: Yeah, I'm not that far gone, yet. :-) Well, ya know, I'd hate to miss the obvious solution. I'm embarrassed to admit how many of my troubleshooting sessions could have been shortened with (1) is it plugged it? (2) is it turned on? (3) is the little green LED on the front on? Ain't that the truth... In a 3 week span I had a user tell me his printer was broken - TWICE the power was off... He's not here anymore... Matthew S. Jarvis IT Manager Bike Friday - Performance that Packs. www.bikefriday.com 541/687-0487 x140 [EMAIL PROTECTED] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
Ted Roche wrote: Well, ya know, I'd hate to miss the obvious solution. I'm embarrassed to admit how many of my troubleshooting sessions could have been shortened with (1) is it plugged it? (2) is it turned on? (3) is the little green LED on the front on? Or, my own personal favorite, Is the keyboard I'm typing on actually connected to the machine I think it is? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Anyway to discover/reset MSSQL UID and PW?
Been there, done that,... Whats worse if you're looking at the monitor on top of the computer wondering why nothings happening and you finally start tracing the wires and it ain't that computer after all... Virgil Bierschwale http://www.virgilslist.com http://www.tccutlery.com http://www.bierschwale.com http://www.bierschwalesolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Wednesday, December 13, 2006 4:30 PM To: ProFox Email List Subject: Re: [NF] Anyway to discover/reset MSSQL UID and PW? Ted Roche wrote: Well, ya know, I'd hate to miss the obvious solution. I'm embarrassed to admit how many of my troubleshooting sessions could have been shortened with (1) is it plugged it? (2) is it turned on? (3) is the little green LED on the front on? Or, my own personal favorite, Is the keyboard I'm typing on actually connected to the machine I think it is? [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Anyway to discover/reset MSSQL UID and PW?
Vince, I have not read the entire thread on this and I apologize for just jumping in. I would suggest that you ignore what was done prior to your getting the computer. By starting from scratch and reinstalling whatever you need, you will be sure of what you have and what you don't have. I have always found this to be the best approach, especially when the person who did the work is no longer around. Of course, YMMV. B+ HALinNY ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
Hal Kaplan wrote: Vince, I have not read the entire thread on this and I apologize for just jumping in. I would suggest that you ignore what was done prior to your getting the computer. By starting from scratch and reinstalling whatever you need, you will be sure of what you have and what you don't have. I have always found this to be the best approach, especially when the person who did the work is no longer around. In this case, it was for a support call for an existing client, so time was of the essence. However, it turns out that for MY branch of the project, no one has ever actually done the SQL version, so I get to do exactly what you said - create it from scratch. By New Year's. Ho ho HO! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
john harvey wrote: Have you tried all asterisks, both upper and lower case.G Bad John. No cookie. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
On 12/13/06, Vince Teachout [EMAIL PROTECTED] wrote: In this case, it was for a support call for an existing client, so time was of the essence. However, it turns out that for MY branch of the project, no one has ever actually done the SQL version, so I get to do exactly what you said - create it from scratch. By New Year's. Ho ho HO! Ouch. I guess the Upsizing Wizard won't help out here, eh? Better tell Whil to write faster... -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Anyway to discover/reset MSSQL UID and PW?
Thanks, but that should be no donut! John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Wednesday, December 13, 2006 6:07 PM To: ProFox Email List Subject: Re: [NF] Anyway to discover/reset MSSQL UID and PW? john harvey wrote: Have you tried all asterisks, both upper and lower case.G Bad John. No cookie. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Anyway to discover/reset MSSQL UID and PW?
Ted Roche wrote: On 12/13/06, Vince Teachout [EMAIL PROTECTED] wrote: In this case, it was for a support call for an existing client, so time was of the essence. However, it turns out that for MY branch of the project, no one has ever actually done the SQL version, so I get to do exactly what you said - create it from scratch. By New Year's. Ho ho HO! Ouch. I guess the Upsizing Wizard won't help out here, eh? No, but the God, this is boring - I wonder if I can automate this function MSSqlMe() I wrote about 4 years ago to rewrite VFP tables into MSSql tables is certainly coming in handy! :-D ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
