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 wOOdy-Soft 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: jacktek
  • Content: Threads
  • Order by date
  1. jacktek

    Problem w/scripting options in SQL Server 2005

    We need to be able to script objects (tables, user functions, stored procedures) with the below structure: if exists(---) then drop procedure xxx create procedure xxx This is available in SQL Server 2000, but I have not been able to do it in SQL Server 2005. It seems SQL Server 2005 has alter...
  2. jacktek

    enabling xp_cmdshell in SQL Server 2005 Express

    I am able to enable xp_cmdshell in SQL Server 2005 Express by going to Start / All Programs / Microsoft SQL Server 2005 / Configuration Tools / SQL Server Surface Area Configuration. However - I need to be able to enable / disable xp_cmdshell using scripts. We build service packs that go over...
  3. jacktek

    problem w/first SQL Server 2005 customer...

    Our software runs on SQL Server 2000. One of the stored procedures executes sp_rename to rename columns in a table. When running the sproc in Query Analyzer the message appears "3604 - Caution: Changing any part of an object name could break scripts and stored procedures." When the VB6...
  4. jacktek

    how to default group tree to 'off' in report preview ??

    The below code allows me to control whether the "group tree" button appears when viewing a report. Set mCrystalReport = mCrystalApplication.OpenReport (pRpt.ReportFileName & ".rpt", crOpenReportByTempCopy) With mCrystalReport -- If Report = "RSM6000" Then...
  5. jacktek

    Corrupt stored procedure, can't drop, can't alter

    I get the below message block when I use Query Analyzer to alter stored procedure spCommon_OTCList_IDString. Server: Msg 644, Level 21, State 3, Procedure spCommon_OTCList_IDString, Line 100 Could not find the index entry for RID '167a662d18100' in index page (1:698), index ID 0, database...
  6. jacktek

    SQL Objects - dependencies

    When running large scripts I often get the "cannot update sysdepends table ---" message. Because of this I cannot trust the "system dependencies" as displayed for objects by Enterprise manager. Is there a way to ask SQL Server 2000 to update the system dependencies? I...
  7. jacktek

    setting stored proc parameter in VB code

    I'm running Crystal 7.0, and writing stored procedures in MS SQL 2000. This is my first attempt (or anyone else's here) to create a report that uses a parameterized stored procedure, and I can't get it to work. I've written a simple report. One parameter. I display the parameter on the...

Part and Inventory Search

Back
Top