When I want to copy data from production to test, I set up a DTS package that uses the Transform Data Task. There's an option on that task called...

When I clicked on the this script hyperlink (for running a job more often than every minute), I got the following message:

Articles with tags Administering, sqlserverjobscheduling, 2288, Job_30sec.sql

Search for...

This is a pretty interesting explanation on the phenomenon of 'remembering'.

[

Mattie

Prachin,

Thank you so much. While waiting for a response, I experimented with the various ways you could save a DTS package, and figured out that the text file was...

How else would I amass more than a thousand points?

Mattie

mrpolecat (10/4/2007)

---

Are we using the same QA? I would love to know how you get QA to build the query for you.

I bring up the Object Browser,...

Several years ago, there was a series of ESPN commercials that showed the Sunday Night Football announcing team in college. And whoever was playing the professor announced 'there are...

The print statement returns the entire phrase on the Messages tab:

(1 row(s) affected)

The quick brown fox jumped over the lazy dog

The version of QA is SQL 8.00.2039 (from the about...

Brian,

Excellent, at least there's a relationship between the number 30 and a known behavior!

Unfortunately, I'm not converting anything anywhere. In fact, I thought maybe I could trick the SP...

Well, I can clarify what I'm seeing, whether or not that clarifies what I mean is another thing...

In QA, there are usually three tabs: Editor, Grids, Messages. When...

When I run this

begin

declare @theoutput varchar(50)

exec stp_testovlimit 'The quick brown fox jumped over the lazy dog',@myoutput = @theoutput output

end

I get a recordset that contains the entire string (displayed on the...

John and Mr. Polecat,

Thanks so much for your efforts on this. I'll definitely post whatever else I find out about this. Do either of you have a web...

Yup, just output variables. No truncation whatsoever when returned as part of a recordset.

Mattie

Hi John,

I ran your code, and it does just what it's supposed to, return Retired Supreme Court Associate Justice. Returning the data as a selected value in a recordset...

Just so you know, there is no grinning going on here:crying:

It makes no difference. I've tried char(50), varchar(50), nvarchar(50), char(100), varchar(100), and nvarchar(100). Not only did deleting and...