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 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. JackVam

    Restoring TRN files from Log Shippping on SQL Server 2000

    Thanks for the reply , in the event , I ended up , doing the RESTORE option, which to my surprise worked Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  2. JackVam

    scripting maintenance plans

    Just of interest , why do you want to script them? Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  3. JackVam

    Reorg Tablespace Command

    Normally , I have a script that queries the DB2 elements and then generating the REORG TABLE / INDEX statements Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  4. JackVam

    Lock table access

    If you use TABLOCKX - this will place an exclusive lock on the table. Keep in mind , this will disallow anyone else to read or update Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  5. JackVam

    Modify Column

    charbrad , I think you're using MySQL syntax Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  6. JackVam

    Restoring TRN files from Log Shippping on SQL Server 2000

    We've got a Primary and Secondary Server (as a standby currently in Read Only mode ) on a Log Shipping set up. For the last week the TRN files have been backed up and moved across to the Secondary Server - but I've discovered they haven't been restoring. In other words , I have a bunch of TRN...
  7. JackVam

    Result Set Comparisons

    Also exploits the set based approach Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  8. JackVam

    Execution Plan Objects

    Also , check SQL Books Online , which gives seome useful information Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  9. JackVam

    Puzzling If statements results in TSQL code

    The issue is how you use the If statement , the ELSE statement needs to be investigated If exch = 01 delete from CBOTPrelim where CBOTPrelim.FirmNumber = @sFirm and CBOTPrelim.YearMonth = @ymprev If exch = 02 delete from CMEPrelim where CMEPrelim.FirmNumber = @sFirm and CMEPrelim.YearMonth...
  10. JackVam

    Sql 2005 Question

    Have you tried rebooting and then trying the reinstall? Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  11. JackVam

    Result Set Comparisons

    More steps occur in using temp tables rather than derived table. A derived table is a sort of Select statement within another Select statement and manages to complete it's tasks within memory, The temp tables requires disk action Jack Vamvas All the IT jobs in one place -...
  12. JackVam

    Stored Procedure Execution is slow

    Break the query down into parts via the Execution plan and monitor if there are any scans which may be slowing things down. Also are there functions which could be causing this situation? Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  13. JackVam

    Import text file to sql DB

    You can also use the BULK INSERT command Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  14. JackVam

    specing out how much resources are need for a project.

    What's your backup strategy? Are you doing auditing? How will trap/handle errors? 1000 people adding 1 record a day , is not a big system. Worth looking at how the vb apps handle the connections , i.e close them etc Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  15. JackVam

    Moving a DB.

    If you need to see the path of the MDF/LDF files , do a : USE Master SELECT name,filename FROM sysdatabases Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  16. JackVam

    Using DTS to run a stored proc and export to Excel

    Yes, for example , when you run the the Export Wizard, you get an option to run a "query" ,is it not possible to encase what you are trying to do into a stored procedure, and then just execute the stored procedure as part of the job? Jack Vamvas All the IT jobs in one place -...
  17. JackVam

    Create 2 views in one query batch file

    Have you got GO between the various segments e.g CREATE VIEW 1 GO CREATE VIEW 2 Jack Vamvas All the IT jobs in one place - http://www.ITjobfeed.com
  18. JackVam

    Can I cancel an sp via code?

    You will need to do this asychronously and in a separate thread All the IT jobs in one place - http://www.ITjobfeed.com
  19. JackVam

    Maintenance Plan (2005) Not Deleting Old Files

    You could look to evole a cmd line task , that will clean up relevant files All the IT jobs in one place - http://www.ITjobfeed.com
  20. JackVam

    SQL 2000 Client Install

    Try installing the MDAC manually All the IT jobs in one place - http://www.ITjobfeed.com

Part and Inventory Search

Back
Top