Microsoft SQL Server Forum

Hi, I have developed an application using VB 6 (SP 5), MS Access 2000 and Crystal Reports 9. I migrated from from access to SQl Server 2000. This wasn't a problem as i could import all the tables to SQL Server. Also, i could make VB6 talk to SQl Server. The problem arsies when i run my application. The sql syntax for access seems to be...

MsSQL Server 2000 PowerBuilder 8 Application 20 client on LAN ethernet 2 client on 64 K router-to-router LAN on 2 remote client I have this error. There are two router Cisco whit idle-timeout on 1800 sec, but evry 1/2 minutes on the 2 remote clients there are the error: 10005 dbprocess is dead or not enabled.

I seem to remember reading many moons ago about a function where you can retrieve a count of the last recordset you opened. For example: I've got a stored procedure that returns a recordset using the TOP 10 so I only get the top 10 records. I need to know the recordcount but I dont want to reuse the SELECT statement because its quite...

I am relatively new to SQL Server. I have a command file with the following contents : osql -E -i%1.sql -d%2 -oq:\%1.log The sql script file has a number of insert/update statements. The log file produced looks something like this : 1> 2> (1 row affected) 1> 2> (1 row affected)

Hi - I know this isn't really a specific SQL Server question but I can't think of a better forum. I want to implement a more sophisticated UK postcode search on a site - "LIKE 'NW%'" etc, is not bringing back good enough results. A feature that would allow me to ask: "give me all outward postcodes in a 30 mile radius of NW10" would be...

Hi I am trying to import several master detail records from files to ms sql server. I have orders file and order_items file that has several rows for each order. If I insert programmatically these records how can find out which order ID was the last inserted, so that I can attach the subsesquent row items to a proper order.

I want to insert values into a table and the same time select a value from the same table. I insert a record of a parent type and use a function to create a subscriberType for the record. Next i insert a record of child type and want to select the subscriberType from the parent record. This do not work when i use

Hi all. I have an keyword table by 2000000 rows that is an int(4) key and a varchar(50) Keyword(Unique index) in Sql Server 2000. After about 80 seconds of starting full population, speed of adding new items t in Enterprise manager/Fulltext ctalog, decreases to (1/4) and more less.

Hi, I have (amogst others) three tables in my database named Bookings, User, and Representative. A User and a Representative are different types of user, however I now want to merge these tables into one - User. When a Booking is made, the User_ID and the Rep_ID are stored in the Booking table. I have now merged the two tables (User and...

We have a product that we were experiencing high recompile rates do to temp tables, we have re-written them to use table variables to reduce recompile rate. The problem I am having is that we have some customers still on SQL 7 where the table variables were not valid. I would like to have one installation script that would create the stored...

i've one dev and one prod, one of the table in dev database having 70 millions records and need to export to one of the table in prod database. both machine got 2 nic, one 10/100 mbps and the other 1gbps speed. databases on raid5. the transmission between two servers is very slow, it's transmitting 1000 rows per 4 secs. sql 2000 with sp3 on...

In SQL Server 2000, I've got a rather lengthy stored procedure, which creates a lot of temporary tables as it processes down through a few sets of data. When testing it through Query Analyzer, it runs fine (a bit slow though). But when I try to run it through the ade, it doesn't do anything. It runs through the procedure in milliseconds but...

trying to make a script to view data in a excell spreadsheet. I can get all the data I need except one. select ordernumber, itemcode, quantity, rate, total from dbo.charges where ordernumber = '45676'

I have a db maintenance plan which is set to backup (then truncate hopefully) the transaction log. In order to backup a transaction log the db must be in single user mode so the maint. plan fails. How do you automatically set the db, in single user mode, for the transaction log to be backed up then truncated? Also, I manually set the db in...

trying to make a script to view data in a excell spreadsheet. I can get all the data I need except one. select ordernumber, itemcode, quantity, rate, total from dbo.charges where ordernumber = '45676'

devo passare all'SQL una stringa where che mi applichi delle modifiche in un range di data ma soltanto il martedi e il venerdì per esempio, opppure soltanto il giovedì e la domenica: Riporto un esempio: ...... ...... ...... WHERE DATA BETWEEN 'Datainizio' AND 'DataFine' AND ...............................

We are writing a C application that is using ODBC to insert records into a database. We have a NOT NULL column that can legitimately have an empty value, i.e. we know the value and it is empty (i.e. a zero length string). We are using SQLBindParameter() to bind a variable to the parameterized insert statement <<in the form: INSERT INTO...

Hello. I have query performance question. I need to optimize procedure CREATE PROCEDURE dbo.SECUQUSRCOMPACCES @P1 VARCHAR(50), @P2 INTEGER AS DECLARE @IORGANIZATIONID INTEGER EXECUTE dbo.ORGNQGETORGID @PORGUNIQUEID = @IORGANIZATIONID OUTPUT

SQL Server 2000 Enterprise Edition Access 2000 Front End One of our clients has recently been experiencing problems with an app that has run satisfactorily (though slowly) for some time. To overcome the slowness, they have installed a new server with SQL Server 2000 Enterprise Edition with 'Log Shipping' enabled (to provide a subsidiary...

I have a SP that I use to insert records in a table. This SP is called hundreds of times per minute. Most inserts complete very fast. And the profiler data is as follows: CPU: 0 Reads: 10 Writes: 1 Duration: varies from 1 to 30

Hi, i am having problem to install sql2000 server, the steps i did are: 1. Local machine -> next 2. Create a new instance of SQL server -> next 3. type name and company -> next 4. accept -> next 5. Server and client tools -> next 6. Default -> next 7. Typical -> next 8. use the same account ... and Use the Local system account -> next 9....

Hi all, Question from a guy who knows PL/SQL, but is starting with Transac-SQL on SQL Server.... Is it possible to have a sub procedure in a Stored Procedure, like we do in a PL/sql package ? Or better yet, have a kind of general Stored Procedure that would contain procedures called by more than one Stored Proc?? I can't find anything...

Is there a way to set a default database for a server registration? I'm with a shared host and clicking my web hosts server entry in Enterprise Manager lists all the database on the server, which takes a few minutes of waiting. Maybe there's a way to set one default database for the server registration so that when I click the server entry it...

Seems the XMLBulkload does not support the "Trigger". But I really need to execute some rules after bulk load, anyone can give me some hints about this? I wonder whether I can fire a trigger in my asp code after I execeuting xmlbulkload? Or any other ways to fire trigger? Thanks for your assistance! DeeDee

Can anyone help with this error message I get with vbullettin Database error in vBulletin 2.2.9: Invalid SQL: INSERT INTO useractivation (useractivationid, userid, dateline, activationid, type, usergroupid) VALUES (NULL, 21, 1063544677, '27618960', 1, 3)