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!

Register Log in
  • Congratulations bkrike 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: *

  • Users: calico
  • Content: Threads
  • Order by date
  1. calico

    Does detach/attach DB can break the LSN ?

    Hi, SQL server 2000 Full recovery mode Backup log every hour This is a theorical question Suppose I detach/attach a BD, and 2 days after, I want to retore the database from 1 week ago and applied all trx-log backup until today. Because I detach/attach DB 2 days ago, is the LSN still in...
  2. calico

    Sharepoint config database is suspect

    Hi, Suppose this scenario: WSS and SPS 2007 are installed. One morning the Sharepoint Config database is "SUSPECT". If a SQL SERVER backup exist (.bak), is it possible for the DBA to SQL RESTORE from config.bak ? Does the Sharepoint Admin need to execute some others tasks after the SQL...
  3. calico

    Join ({?@parameter},",")

    Hi, When I use Join ({?@parameter},",") "default values" fields are used How can I use the Join () where "description values" are used thank you Calico
  4. calico

    many queries / tables use by a report

    Hi, With CR is it possible to create a reports that use as input many queries and tables like we can do in MS ACCESS ? In others words, it it possible to create a query2 that use (as data source) query1 and tables that are related togather ? If not, what is the alternatives ? Stored proc...
  5. calico

    Automate INDEX ON / REINDEX during the night

    HI, We use Foxpro for DOS 2.6 I would like to create a foxpro program (.FXP) that can execute PACK, INDEX ON .... or REINDEX instructions for all the tables in my application. I would like to automate / schedule this foxpro program (.FXP) during the night. Can we execute INDEX ON .... or...
  6. calico

    XP: FIND doesn't work with .PRG files

    Hi, Since I have an XP workstation, I am not able to FIND string into .PRG file (start/find). Any idea ? Danny Danny Presse
  7. calico

    Pessimistic/ Optimistic concurrency control mechanisms

    Hi, How can I know the type of concurrency control that have been set on our Sql Server ? Pessimistic or Optimiistic ? I read that MS Sql Server supports a wide range of Pessimistic and Optimistic concurrency control mechanisms. Can you enumerate that are they ? Thank you ! Danny Danny Presse
  8. calico

    Hi, Tree montha ago we elimin

    Hi, Tree montha ago we eliminate cluster index option in all of our Sql tables. Now I realize that it was not a good idea to eliminate all cluster index of our Sql tables (MS Sql Server 7.0). This suggession came from our supplier to improve performance of the system. We bought this...

Part and Inventory Search

Back
Top