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

exec sp_sdidebug 'legacy_on'

That should fix it.

Try executing this:

sp_sdidebug 'legacy_on'

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

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

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

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

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

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

For example:

update InvoiceDtl set UnitPrice = UnitPrice * -1

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

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.

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

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 int

 SET  @TableName...

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

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

Try running a backup to clear out the log file.

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: