Hi,
I'm a complete novice concerning SQL Server (Express Edition)
I'm trying to Add or Delete rows froma VB 2005 Express Function or Sub. While the program is running everything is ok. Except when restarted added records are gone and deleted records are back.
Have i missed an option during installation?
Thx,
Steven
Your installation of SQL Server 2005 Express may be operating in 'Snapshot Isolation' mode. Refer to Books Online for more details.
You may also find this series of instructional videos to be useful.
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#1
|||Make sure that you did not specify the datafile for "Always copy", if you did this, the file will always be copied from scratch upon new start of the Visual Studio debug session.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1611696&SiteID=1
Jens K. Suessmeyer.
http://www.sqlserver2005.de
Hi Arnie,
Thx for your trouble, but i got the 'Always Copy' option wrong!
Greetings,
Steven
|||Hi Jens,
Your answer was the correct one.
Thx,
Steven
No comments:
Post a Comment