Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TRBLUE

    lock/deadlock problem

    SELECT ItemID, Title WITH (NOLOCK) or make sure you do begin trans commit and end trans In sql 2005 bit different
  2. TRBLUE

    read isolation levels

    SQL 2005
  3. TRBLUE

    Export fro sql query to an Access table

    Open up Access and create new database and do right click and open up linked database, and use the odbc and your have the table in access . Look up linked databases.
  4. TRBLUE

    read isolation levels

    Is there a way to use ms access 2003, 2007 with read uncommitted record so that it does not lock SQL with updates. Anyone know of a way to set this up. We currently use sql replication and rather not have to use this. For example if im in SQL doing mass update and open up table in access i...
  5. TRBLUE

    ODBC Farm

    We have about 30 applications and ODBC installed all over place for accessing database. Trying to use SQL 2005 snapshots which is great however when users use ODBC and i rebuild snapshot we get errors with disconnects because the spid in sql has been removed. Anyone know of a way to prevent...
  6. TRBLUE

    Maintain state using cognos

    Im trying to use snapshot in sql 2005 this works great the only thing is if someone is in Cognos impromptu looking at a report and at the exact minute the SQL builds the new snapshot which only takes 1 minute i get the error in cognos Driver DBMSLPCN general network error which is caused...

Part and Inventory Search

Back
Top