This isn't what you asked for but maybe you can modify it or get ideas from it.  It searchs an entire database for a passed string:

CREATE PROC SearchAllTables

(

 @SearchStr nvarchar(100)

)

AS

BEGIN

 CREATE TABLE...

I don't know if this will help.  You can cut down on the information returned after you run it.

This is from the CMS database and the table Claims.

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS...

This isn't my answer.  I saw it posted from a Google search:

How can I find out the maximum row size for a table in which all the varchars are fully...

Just a couple more where the nth record can be picked:

DECLARE @var1 VARCHAR(12)

DECLARE @var2 VARCHAR(30)

SET ROWCOUNT 10

SELECT @var1 = id, @var2 = firstname FROM users ORDER BY id

SET ROWCOUNT 0

SELECT...

Well, I'm in the dark about what you are really trying to and just guessing that the one column table is to be used to generate a number that will...

My first thought is to set IDENTITY_INSERT on.

This will put an initial value in the table:

SET IDENTITY_INSERT OneColumnTable On

insert into OneColumnTable(ID) values (1)

This will insert a record one higher then...

You might try a google search.  I got a few hits on "SQL Debugger Problem windows XP".  Lots of different reasons for it.

This one: 

http://www.winnetmag.com/Article/ArticleID/42729/42729.html] 

might be what you mentioned.