Wes,

The @Priority variable is getting populated with the output from the dynamic select statement.

In theory you should be able to build in your while loop and modify to fit...

It almost had me. Syntax Anyway, this example works...

declare

@Priority varchar(32)

, @ColList varchar(32)

, @ID varchar(10)

, @Table varchar(32)

, @Sqlstr nvarchar(128)

set @ID = 1

set @ColList = 'LastName'

set @Table...

Wes,

I'm confused at what you are trying to accomplish. The script works (?)(except there is missing declares for @cmds and @cmdstr) but I am not sure what you are hoping...

This is an example of an old file rename that I have that shows you how to build the string and execute it.

/*Rename File.*/

declare

@monthname varchar(32),

@sqlstring varchar(250)

set @monthname = (select...

Did you check out the other two articles that are referenced in Q312995? They really don't list any registry hacks but instead point to two scenarios with the page file...

Christine,

You may have already found this but it is documented in the 7.0 BOL as being undocumented with the following comments;

"Finding Supplemental Error Message Information

Over time, more information about error...

Supernova,

Check out this link and it should get you started on a resolution. Hope this helps.

http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;Q312995

**In case that link doesn't carry, you can search on article Q312995.

David

Couldn't agree with Brian more. This is a great product! Great review!

David

You poor folks must be with me and only have the professional edition where I believe Bruce has the Enterprise edition. See MS comments from overview of product;

"Microsoft Visio® 2000...

If you apply Q322853 you should be all set. Read the following from the page (I usually gloss over this but if you read it carefully it makes sense);

Microsoft distributes...

Right click on your source server and select "Disconnect". You should be able to continue then.

Hope this helps.

David

I understand about the relationships and your boss's opinion and I was hesitant in putting in the relationships question because of the potential for debate.

As for an integrated graphic design...

I like Visio. I know there are a lot of tools out there but this has always worked great for me.

As for creating one in SQL 7.0 without defining...

Good article Chris and this is a good way to design the app. Less release and greater flexibility.

Andy - my thoughts for seperate procs would be less regression testing. Everyone...

Very cool problem Tom!! Never come across something like this in the past but I will be looking out for it now. Thanks!

David