Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. articles. downloads. faq. members. files. rss.

RE: LOCK THE PHYSICAL TABLE IN SQL

 From: Lim Wendy Lim
  Where is Lim Wendy Lim?
 singapore
 Singapore
 Lim Wendy Lim
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
Subject: RE: Lock the physical table in SQL
Thread ID: 194496 Message ID: 194504 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Tuesday, September 16, 2008 9:54:17 AM         
   


> > Hi
> >
> > If anybody know any foxpro command can be used to lock the physical table in SQL database ?
> >
> > Thanks
> > Wendy
>
> In an SQL Server database there are no physical table files, only the database file and a log file. The tables are inside.
>
> -Anders

Yes. I know. do you know how to lock the database file to prevent other user to read,update or delete any records in the database file.

I'm using MS SQL express. Have tried to use LOCK TABLE ... but encounter this error msg "Incorrect syntax near the keyword 'TABLE'."

Thanks

ENTIRE THREAD

Lock the physical table in SQL Posted by Lim Wendy Lim @ 9/16/2008 9:43:43 AM
RE: Lock the physical table in SQL Posted by Glenn Villar @ 9/16/2008 9:46:05 AM
RE: Lock the physical table in SQL Posted by Lim Wendy Lim @ 9/16/2008 10:00:31 AM
RE: Lock the physical table in SQL Posted by Anders Altberg @ 9/16/2008 9:47:47 AM
RE: Lock the physical table in SQL Posted by Lim Wendy Lim @ 9/16/2008 9:54:17 AM
RE: Lock the physical table in SQL Posted by Anders Altberg @ 9/16/2008 10:06:28 AM
RE: Lock the physical table in SQL Posted by Anil Sharma @ 9/16/2008 9:52:46 AM
RE: Lock the physical table in SQL Posted by Lim Wendy Lim @ 9/16/2008 10:12:50 AM
RE: Lock the physical table in SQL Posted by Borislav Borissov @ 9/16/2008 10:14:18 AM
RE: Lock the physical table in SQL Posted by Anil Sharma @ 9/16/2008 10:18:35 AM
RE: Lock the physical table in SQL Posted by Lim Wendy Lim @ 9/16/2008 10:27:29 AM
RE: Lock the physical table in SQL Posted by Anil Sharma @ 9/16/2008 10:32:37 AM
RE: Lock the physical table in SQL Posted by Lim Wendy Lim @ 9/16/2008 10:41:59 AM
RE: Lock the physical table in SQL Posted by Lim Wendy Lim @ 9/16/2008 10:19:15 AM
RE: Lock the physical table in SQL Posted by Anders Altberg @ 9/16/2008 1:55:15 PM
RE: Lock the physical table in SQL Posted by Pete Sass @ 9/16/2008 8:00:59 PM
RE: Lock the physical table in SQL Posted by Anders Altberg @ 9/16/2008 8:19:47 PM