471,108 Members | 1,289 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Re: Not finding GUID value after migration sql 2005 to 2000

>My application takes that value and uses that as a parameter for an SQL query to retrieve the user's data, which works fine on my 2005 server but breaks on the 2000 server. <<

This might be one reason that web apps are using email addresses to
identify users, and implement on LAMP instead?
Jun 27 '08 #1
3 1809
On 17 jun, 17:40, --CELKO-- <jcelko...@earthlink.netwrote:
This might be one reason that web apps are using email addresses to
identify users, and implement on LAMP instead?
If I would've written the main application, I certainly would have.
Unfortunately, I'm just writing a reporting plugin that needs to use
the login session of the root web, so I'm stuck on getting this to
work with the guids instead of being able to change the login
scheme. :(

Thanks though,
Chris
Jun 27 '08 #2
This might be one reason that web apps are using email addresses to
identify users, and implement on LAMP instead?
Yet again you think "only the database".

Yes, the application front end will take an email address from the user as a
login, but once logged in it uses a guid; but the great majority of people
use a GUID for the application plumbing - even the Microsoft session state
stuff.

Have you ever signed up for google services or ebay or paypal? The email
confirmation url you receive is GUID centric.

--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]

Jun 27 '08 #3
identify users, and implement on LAMP instead?

Why are you selling LAMP so much? The statistics say you are wrong on that
as well.

Let's see....

You give inaccurate and often dam right dangerous advice on MICROSOFT SQL
SERVER
You are now selling LAMP
You fail to recognise the ETL, Data Mining, Reporting and Cube (BI) tools
that ship with the product
You spend 99.9% of your time on MICROSOFT SQL SERVER instead of spreading
your standards gospel on the Oracle and DB2 and Sybase groups

It almost appears you are being paid by a Microsoft competitor or are just
so anti Microsoft you think you'd play some games with the people using the
product.

--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]

Jun 27 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Bungle | last post: by
9 posts views Thread by Rene | last post: by
7 posts views Thread by ESPNSTI | last post: by
5 posts views Thread by Michael Primeaux | last post: by
8 posts views Thread by Leon_Amirreza | last post: by
1 post views Thread by Jeff | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.