Viewing 15 posts - 16 through 30 (of 37 total)
I thought I posted this yesterday but I don't see it today. Run
exec sp_sdidebug 'legacy_on'
That should fix it.
September 1, 2005 at 5:12 am
Try executing this:
sp_sdidebug 'legacy_on'
in Query Analizer in the same database you are debugging..
August 31, 2005 at 5:37 am
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...
March 8, 2005 at 4:48 am
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"...
January 28, 2005 at 7:10 am
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
January 27, 2005 at 4:29 am
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...
December 28, 2004 at 4:49 am
I don't know about a function but just multiply by -1.
For example:
update InvoiceDtl set UnitPrice = UnitPrice * -1
December 10, 2004 at 4:40 am
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...
November 30, 2004 at 4:32 am
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.
November 23, 2004 at 4:32 am
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...
November 11, 2004 at 1:10 pm
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...
November 8, 2004 at 6:31 am
Maybe creating a view of the data you need might b a way to go.
October 18, 2004 at 4:29 am
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...
October 5, 2004 at 4:34 am
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:
October 1, 2004 at 11:26 am
Viewing 15 posts - 16 through 30 (of 37 total)