Well, you shouldn't use sp_sqlexec any more as BOL states for SQL Server 2000

>Removed; no longer available. Remove all references to sp_sqlexec.

It can be found when searching for sq_sqlexec

Why include posts anyway?

The procedure and the dynamic statement run in different scopes.

I think you can't use a table variable. *Better* would be a temp or permanent table like this

CREATE PROCEDURE USP_RULE

AS

CREATE table...

No, we should not be joking anymore.

It's pretty serious to me!

...and how is it over there?

Another two points

Please avoid cross postings. They make it hard to follow. We should leave it here

sp_sqlexec() ???

I think you mean sp_executesql()

Sorry, this is a real world example from one of my tables.

Replace with your table name and with your PrimaryKey or Unique Identifier.

HTH

Are you sure it's SQL Server 2000?

Here is a list of SQL Server versions. To be on SQL 2K you should at least see something like 8.00xx

If you don't mind that it's a german site you can have a look at this here. They also have a sample script. As this is mostly code it...

Posts containing any feedback like 'Thanks' are quite okay as they show a solution to the problem has been found.

Sorry, for posting this as a separate post, but editing the...

How would I do this with DOS commands?

From this point on, I would only be guessing and I don't want to do this.

Sorry, but I'm sure someone else will jump right in.

DECLARE @text_var varchar(8000)

SELECT @text_var = MsgNoteText

FROM mails_header

WHERE MsgID =

'0000000052473604077444499F10F4A2A11C085E0700EE482D8B9388E841ADE11B0CF1FA

A1DC0000008750640000EE482D8B9388E841ADE11B0CF1FAA1DC000000A438B30000'

SELECT LEFT(@text_var,20)

...

xp_regread

xp_regenumkeys

xp_regwrite

xp_regdeletevalue

xp_regdeletekey

I would search for them here or on the net. None of them is documented in BOL for a very good reason.