I believe that Identity needs a seed. Also, I know that the limit on the
size of a row is somewhere around 8000.
Try:
create table [RADIOPrimary].[dbo].[testform2] (
[testform2ID] int NOT NULL IDENTITY (1, 1) PRIMARY KEY,
[testcolumn] varchar(7000) NULL,
[CMSUseOnlySortOrder] int NULL,
[CMSUseOnlyFeatureSortOrder] int NULL,
[CMSUseOnlyPublish] bit NULL,
[CMSUseOnlyDateTimeStamp] datetime NULL)
Steve
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 3:57 PM
To: CF-Talk
Subject: Executing the SQL statement is not allowed
I am completely stumped on this one. I'm trying to execute this query on my
development box (Win XP Pro, CFMX 6.1, MS SQL Server 2000 Development,
Apache 2):
CREATE TABLE [RADIOPrimary].[dbo].[testform2] (
[testform2ID] int NOT NULL IDENTITY PRIMARY KEY,
[testcolumn] varchar (8000) NULL,
[CMSUseOnlySortOrder] int NULL,
[CMSUseOnlyFeatureSortOrder] int NULL,
[CMSUseOnlyPublish] bit NULL,
[CMSUseOnlyDateTimeStamp] datetime NULL )
I get "Executing the SQL statement is not allowed." every time.
The datasource uses the MS SQL "sa" account and the query runs fine with the
MS SQL Query Analyzer using sa. The datasource has all permissions checked.
At one point this would have worked on my development box. Here's the weird
part, the same code runs fine on my Production Box (Win 2K Server, CFMX
6.1).
What could possibly be causing this issue? All other queries on this
datasource (SELECT, INSERT, DELETE) run fine.
Thanks,
Jonathan
__________________________________________________
Jonathan Mauney
Web Application Developer / Manager, Digital Media Properties
1110 WBT AM / 107.9 the LINK (WLNK-FM) / JP Radio Network
Jefferson-Pilot Communications Co.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
