I get the following message when attempting to insert a new column into a table in design mode: - Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state Only SQL Server 2000 is connected to the database. What does this mean and how does one fix it? Than...more >>

Hi tmp_table company_name char(33) prd_yr char(4) prd_month char(2) value char(25) select company_name, sum (case prd_yr when 2001 then convert(numeric(25,5),value) else 0 end) as yr1, sum (case prd_yr when 2002 then ...more >>

I am setting up a stored procedure command inside Dreamweaver MX. I get an error: Invalid scale value What values should I be using below? thanks ---------------------------------------------- CreateParameter("@OrderNo", 200, 1,20,UpdatePrices__OrderNo) <-- varchar(20) CreateParameter("@APrice...more >>

Hi, I've looked at a post earlier that suggested an article on doing Error Checking and Management in SQL Server 2000, and I've taken on board the ideas, but coming from a C++ background, I'm trying to enhance the situation. I have a plan, but I'm looking for thoughts before I pursue it.... ...more >>

The below query finds all the records that have a matching OrderNo. How do I find the OrderNo(s) in ItemStock that do not have a matching record in ItemPrice? ---------------------------------------- SELECT ItemStock.OrderNo FROM ItemStock INNER JOIN ItemPrice...more >>

I'm writing an app in VB6 (using ADO) that will be making a query and then an update every few seconds (SQLserver 2000). The query will return a single record and then a couple of fields on that same record will be updated a second or two later. The query will look something like this: SELECT...more >>

I was given an example to query a derived table. I get the following error in QA... Server: Msg 156, Level 15, State 1, Line 7 Incorrect syntax near the keyword 'SELECT'. What am I doing wrong here? thanks! --------------------------------------- DECLARE @Column varchar(50) SET @Column = 'ma...more >>

Hello! Can someone tell me if this is the right way to execute a stored proc = from an asp page.... I'm having trouble deleting a record and could use = some advise...=20 Thanks, BillB MY STORED PROC CALL: ------------------------------------ 'Create a Command=20 Dim objConn, p=20 ...more >>

Hi, I wrote this code that is supposed to print the KEYS of all the tables, but the 'exec' statement inside the while loop gives me a syntax error for some reason. Can someone please tell me why? When I use a print statement to print what is in the exec, the statement comes out as i expect it to...more >>

Hello I have a custom install program which installs the MSDE 2000 engine by executing Setup.Exe (SP3a). It all works OK except that I don't want the user to be presented with the choice to reboot now or reboot later. My setup program should do this itself at the end. With the option "/q...more >>

(1) If I'm using the updlock hint on a table, is this equivalent to repeatable read on a transaction (2) practically speaking, why does one need to know about intent locks - is there any particular query where knowing about intent locks helps TIA John...more >>

Does anyone know the DateTime syntax for getting the Names of the week-days? Using datename/datepart(dd, d or day, getdate()) does not seem to cut it. I am looking for actual names instead of varchars. Joshi...more >>

if have two update triggers with different on same table, will all two be executed? only one? which one will be called? ALTER TRIGGER tr_OutboundQueueItem_Update ON dbo.OutboundQueueItem FOR UPDATE AS thanks! ...more >>

I have a installshield script AND a vb app that both do late-binding on SQLDMO.SQLServer. I know the SQLDMO lib is indeed registered (I've checked in the Registry CLSID and in TYPELIB AND on the same machine I have a C# app that does work with SQLDMO but it does early binding). Essentially, I'm do...more >>

Hello Experts, I'm confused with the DB Application-Standard Roles, DB Users, Server Logins and Roles. What I want is the user (Simple user, administrator...) that accessing my DB, have specific rights on my tables, views et.c. Also I dont want "Simple users" to access my db from any o...more >>

i want to now how to optimize my select stsments in order not to get timeout expiration exception?,iam using .net tool with sql 200 server database...more >>

Hi. I have a table in MSSQL database, that stores events. These events, in most cases, run over several days. In one of the fields, we have simply listed the month, by name, that the event takes place in (January, February etc). Some of the records have two months listed in this field (Janua...more >>