Recent content by comtec

PS it is sql 2000 w sp3a Paul D dontneednew.com

My Sql database is in need of a little tuning up ;-) Every time I try to run the tuning wizard I get this message. I have tried tuning scripts profiles, many tables, one table, tuning SP's, everything and this is what I get every time about 3 seconds after the wizard starts. "an error...

I change it from the query analyser for sql server and with enterprise manager for the table. It seems to have changed it ok both view with new settings just doesnt work when I run it If I keep my size under the original 256 then it is fine something is not swithcing values the problem...

I have a web form inputing to a description table field using a SP I need more data in the field so i went to the sp and changed from varchar(256) to varchar(500) for the field I then went directly to the table and changed the same thing the same thing. varchar(256) to varchar(500) I have...

I am using access 2002 and sql 2000 Paul D dontneednew.com

I have upsized an access database using the upsizing wizard to my sql database. I am now unable to create any stored procedures using adp. although I can select the tables necessary, the table field boxes are empty and I can not proceed. Help PS: Please move slowly, I am a little out of my...

Everything is as you would expect SELECT [mfgID], [mfgName], [mfgLogo] FROM [wsrv2].[dontneednew].[dbo].[exportManufacturers] does work on its own but not in the sp I did get it to work I just replaced SELECT [mfgID], [mfgName], [mfgLogo] FROM...

here is where we are now no errors but no update either SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO /****** Object: Stored Procedure dbo.insert_sfManufacturers_1 Script Date: 8/4/2003 3:41:11 PM ******/ /****** Object: Stored Procedure dbo.insert_sfManufacturers_1 Script Date...

If these are the problem, why when you use the wizardfs does it continue to place them there? Paul D dontneednew.com

BTW I wad all kinds of things going on tryingto make this work. this why there are unsued variables in the original calls. I had originally tried coding it my self but I really am not a coder Paul D dontneednew.com

-SQLBill I am hoping to be a "wizard" You know nothing up this sleeve. tried waht you gave me and same thing Server: Msg 170, Level 15, State 1, Procedure insert_sfManufacturers_1, Line 8 Line 8: Incorrect syntax near ','. -SQLBill Paul D dontneednew.com

By no means am I SQL efficient! But this should be easy ( shouldn't it?) I created this query to update a new database structure from my old one with the query wizard in enterprise manager and modified it accordingly. We are trying to change to a new ecommerce solution if we can get the data...

I logged in as sa as directed. I then changed the default database back to master. Everything worked correctly afterwards Paul D dontneednew.com

Corran007 Problem Solved Thanks, so very much appreciated Paul D dontneednew.com

You have hit the nail on the head I can not login because I suspended the database. It is the administrator login database. when I type sp_defaultdb 'administrator', 'master' I get line 44 error the login 'administrator' does not exist how can this be? i am sure that it is a syntax, I am...