Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 28th, 2003, 11:42 AM
Registered User
 
Join Date: Nov 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bful Send a message via AIM to bful Send a message via MSN to bful Send a message via Yahoo to bful
Default How to remove rowguid without affecting ids

Is it be possible to remove rowguide without affecting existing session id controls?

My partner and I built a site using SQL, ASP, javascript, and html, and delivered a perfectly working site to the client. One of their developers added rowguid to the database after delivery and it has prevented updates to web pages with any query changes after that.

Would this assumption hold water? We have tried our updates on the client's live site, and offsite on our own replicated testing environments.

I am a bit new to SQL and am not too familiar with ROWGUID. Any help?

Bill Fulbright
[email protected]
 
Old November 28th, 2003, 12:29 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

I may be a permission issue as to why you cannot update the page. if the developer changes the account to a dbo account and the account your using to update the page also has dbo permission; this may solve your problem.

Change the owner of the tables to be the dbo user.

Also see this article: http://support.microsoft.com/default...NoWebContent=1
 
Old November 28th, 2003, 12:57 PM
Registered User
 
Join Date: Nov 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bful Send a message via AIM to bful Send a message via MSN to bful Send a message via Yahoo to bful
Default

Thanks, you may be right.

I will check it out.


Bill Fulbright
[email protected]





Similar Threads
Thread Thread Starter Forum Replies Last Post
ids dhoward VB.NET 2002/2003 Basics 4 December 17th, 2007 05:46 PM
Combo box select affecting avail option in another ebburks Access 4 June 3rd, 2006 05:33 PM
Module.InsertText affecting unrelated variables! DaDeViL Access VBA 1 October 16th, 2005 12:43 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.