Forum Replies Created

Viewing 15 posts - 16 through 30 (of 37 total)

  • RE: Debugger

    I thought I posted this yesterday but I don't see it today. Run

    exec sp_sdidebug 'legacy_on'

    That should fix it.

  • RE: debugging a stored procedure

    Try executing this:

    sp_sdidebug 'legacy_on'

    in Query Analizer in the same database you are debugging..

  • RE: debugging stored procedure

    One way...

    Go to SQL Query Analyzer, click on the object browser, click on your database, then stored procedures.  Right click on your stored procedure and click on debug from the...

  • RE: Estimate the rbutime of a query

    I don't have a clue how you can do that other then a crystal ball.  Another method besides the first one I mentioned would be:

    From Query Analyzer click on "query"...

  • RE: Estimate the rbutime of a query

    I use this.  There are probably better ways:

    set nocount on

    declare @testtime as varchar(30)

    set @Testtime = convert(varchar(30), getdate(), 126)

    print @testtime

    === > Run query here

    set @Testtime = convert(varchar(30), getdate(), 126)

    print @testtime

     

  • RE: Get sp names who is using given table name

    There is a free product called Toad.exe that can find that for you and has many other uses.  Download it from http://www.toadsoft.com.

    Once you have it and connect to the...

  • RE: Convert positive to negative and vice versa

    I don't know about a function but just multiply by -1.

     

    For example:

     

    update InvoiceDtl set UnitPrice = UnitPrice * -1

  • RE: launch query analyser from enterprise manager ?

    Not exactly a Fx key but go to start, programs, left click on SQL Query Analyser, properties, in the short cut key box it will say none, start keying ctrl...

  • RE: SP_Showplan

    I don't know about a stored procedure but if you pull up Start,Programs, Microsoft SQL Server, Profiler you can set up a trace that may give you what you want.

  • RE: Printing in Query Analyzer

    I think your going to have to wait on Microsoft.  A free third party tool that makes working with queries easier, to me, and has much of the functionality of...

  • RE: Need script for Search and Update in all columns in all tables using keyword

    I found this a while ago and only tested it once.  Good Luck:

    CREATE PROC SearchAndReplace

    (

     @SearchStr nvarchar(100),

     @ReplaceStr nvarchar(100)

    )

    AS

    BEGIN

    SET NOCOUNT ON

     DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110), @sql nvarchar(4000), @RCTR...

  • RE: Really basic question..

    Maybe creating a view of the data you need might b a way to go.

  • RE: Top Urgent Question

    I'm not exactly a guru but I thought part of the process of backing up a database was clearing out the log file.

    Go to Enterprise Manager, right click on your...

  • RE: Top Urgent Question

    Try running a backup to clear out the log file.

  • RE: Need Sources to learn Peoplesoft

    A Google search on "PeopleSoft Training" will get you lots of hits.  Looks like they all cost money.  At least I didn't see any free materials.  I did see this:

Viewing 15 posts - 16 through 30 (of 37 total)