Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem running drop/create script

Status
Not open for further replies.

jjones794

Programmer
Mar 26, 2009
2
US
An example of one table in the script:
drop table HTMLEXTRACT
go
create table HTMLEXTRACT (
"doc_id" numeric(32) identity not null,
"parent_id" numeric(32) not null,
"doc_type" varchar(10) not null,
"pid" numeric(16) not null,
"doc_time" datetime default getdate(),
"doc_path" varchar(512) not null,
"status" smallint not null,
"html_body" image null
)
with max_rows_per_page=1, identity_gap=100 on data
go
create index HYMLEXTRACT_PK1 on HTMLEXTRACT("doc_id","status") with max_rows_per_page=1 on indices
go
sp_bindcache htmlExtractCache, S3, HTMLEXTRACT, HTMLEXTRACT_PK1
go
sp_bindcache htmlExtractDataCache, S3, HTMLEXTRACT
go
sp_placeobject imgData, "HTMLEXTRACT.tHTMLEXTRACT"
go
sp_bindcache imgDataCache, S3, HTMLEXTRACT, "text only"
go

My problem is that when I run the script all the tables and indices are created and place on the segments indicated. The last four commands for each table however silently fail. Then I have to go back and run each one on the isql command line. They succeed. Both cases are run under the same account and priviledges.
How do I avoid the extra work?
Jim
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top