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

[--CELKO--]

>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?

[Zark3]

On 17 jun, 17:40, --CELKO-- <[e-mail]:

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

[Tony Rogerson]

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]

[Tony Rogerson]

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]