Deleted Guest

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
hektor56 Members Profile Find Members Posts Newbie Joined: 24 July 2003 Location: United States Status: Offline Points: 4	Post Options Post Reply Quote hektor56 Report Post Thanks(0) Quote Reply Topic: Deleted Guest Posted: 29 July 2003 at 6:33pm
	Help! I was working with tblAuthor off forum (SQL 7.01) and accidentally deleted the "Guest" record (ID #2). The Forum seems to be operating normally. Will this cause problems down the road? I'm not planning on using guest accounts, and all my other functions appear to be ok. Can I re-run the SQL Setup script on top of the existing tables? TIA for any info. Bob Hester Edited by hektor56

ljamal Members Profile Find Members Posts Mod Builder Group Joined: 16 April 2003 Status: Offline Points: 888	Post Options Post Reply Quote ljamal Report Post Thanks(0) Quote Reply Posted: 29 July 2003 at 6:38pm
	You can turn off the identity on the table and insert ID 2 by hand and then set the identity again.
	L. Jamal Walton L. Jamal Inc : Web/ Print Design and ASP Programming

hektor56 Members Profile Find Members Posts Newbie Joined: 24 July 2003 Location: United States Status: Offline Points: 4	Post Options Post Reply Quote hektor56 Report Post Thanks(0) Quote Reply Posted: 29 July 2003 at 6:46pm
	That seems to have done the trick; thanks very much! Bob Hester

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.