Hello all, I have a question about the SQL Server JDBC driver. I was wondering if anyone knows what the default prefetch size is (in number of rows). Also, does anyone know if an entire packet is sent (i.e. padded with null values) if there is not enough data to fill it? Thanks for your hel...more >>

I am trying to determine the changes an application makes to a database. The plan is to copy the existing schema (active) to a reference schema, run the application and then diff the table data between the reference and the a active schema. I have found one software vendor who has a tool to do...more >>

It has been suggested by our DBA group that all developers when working on objects within a database create objects not under the DBO owner but under individual owners eg instead of dbo.sp_getUsername the stored procedure would be smithJ.sp_getUserName I have never seen this used befor...more >>

Dear Madam/Sir, You are invited to participate in an international research study. This research project is headed and led by Cambridge student Nico Baumgarten. What is it all about? It is a well-known fact that there exist many differences between cultures. However, how these difference...more >>

When trying to run ODBC from Control Panel->Admin Tools->Data Sources I get an error about the odbcad32.exe file - stating it is corrupted or unreadable. I have installed SQL Server 8 with sp3a. Does anyone have any ideas - I need ODBC to connect an application to my database. Thanks ...more >>

I'm trying to devise a query for use on SQL Server 2000 that will do what was previously done with one query in MS Access. The MS Access query was like this: SELECT Count(*) as [Opened], Abs(Sum([Status] Like 'Cancel*')) As [Cancelled] FROM Detail_Dir_LocV Where (Detail_Dir_LocV...more >>

Hi everybody, VARCHAR has a higher precedence than CHAR. If you have a query SELECT COALESCE(c1,c2) FROM T1 where c1 is CHAR(5) and c2 is VARCHAR(10), I would expect the return type to be varchar(10) similiar to UNION. However it turns out to be CHAR(10). Does anyone know why that is so?...more >>

Hi techies I have set up a Transaction replication from My Primary Server to Secondary Server on Orders table. Thousand of records gets inserted on Orders every hour which get replicated on the secondary server. it works fine reporting apps uses Secondory server's Orders table data fo...more >>

Dear All, Access adp on sql-server 2000 After upgrating to A2003 updating data with 1 perticular combobox causes the program to hangs without any error-msg. Traying to change te combobox recordsource i get this error: This version of Microsoft Access doesn't support design changes to the ...more >>

Hello all, SQL 2000 on Windows 2000. If I go into all tasks, maintenance plan, it gives me an option to reorganize data and index pages. When I check on it, it populates the line "change free space per page percentage to" and puts in 10 in there. Is this the default for free space? Is it th...more >>

Hi, I have a table in which two fields(FirstID, SecondID) together make the primary key for the table. Let's look at the following example: FirstID SecondID ******* ******** 2 2 2 3 2 5 5 5 5 7 8 7 9 ...more >>

Hi there, I sincerely hope that someone out there can help. I have two instances of the SQL 2000 Desktop Engine running. One is on my local machine for development and the other is on another machine on our network which is the production environment. I have built an Access 2003 front end ...more >>

I have four total tables. Table One (Documents)- List of Documents. Each record has two fields related to this issue. First field (Document_ID) is the ID of the document, second field is the ID of the record (Task_ID) it is associated to in Table Two. Table Two (Activities)- List of act...more >>

I have code that instantiates a sqlserver object and starts a job. I have used this on numerous XP workstations successfully, when I tried to move this to a Windows 2000 Application Server attached to a Small Business Windows 2003 network and run the code, I am receiving the error: Automatio...more >>

Hello, I need to do a seach in multiple columns for a certain word. With SQL I have to use one specific column right? I.E. select * from DB where Column1 like '%search%' That works. But what if I want to seach multiple columns in the table for the search word? You can't do this: ...more >>

HI! I am importing .txt files. How can i check the errors? I have created a log file, but the problem is that i lose some characters. I import for example: Code ABC FZH JHN from a text file, but sometimes Code can be 4 caracters long I import this 3 characters long now. When i add the...more >>

Well guys this may be the wrong place but an earlier post by an "expert" about how a table was poorly designed has piqued my interest. The question is this. What are the do's and don'ts of sql development? Please list what you consider to be good and bad practices in general and/or specific o...more >>

Hi all, Since yesterday I'm unable to lauch the enterprise manager, it gives the following error : Unhandled exception at 0x0101f07e in mmc.exe: 0xC0000005: Access violation reading location 0x00000064. The weird thing is that except installing the office xp PIA's I can't image what else...more >>

Hi all! In a insert-trigger I have two joins on the table named inserted. Obviously this construction gives a name collition beetween the two joins (since both joins starts from the same table) Ofcourse I thougt the using bla JOIN bla ON bla bla bla AS a_different_name would work, but it ...more >>

Those who is interested in computers, games can check out a free massive online strategy scifi game at http://www.spacefederation.net This game is also looking for staff, especially those in the computer line like programming, development, it and Internet security. to apply, goto the game and ...more >>

Hi, I am writing a small dating site and now I am designing the DB. At some point I realized that I will need to create a table with more than 12 columns and I felt that it is not such a good idea. I?ve tried normalizing the database, but It was with no effect. So let?s sat that I have t...more >>

Hello, I am currently trying to assign some string to a TEXT output parameter of a stored procedure. The basic structure of the stored procedure looks like this: -- 8< -- CREATE PROCEDURE owner.StoredProc ( @blob_data image, @clob_data text OUTPUT ) AS INSERT INTO Table (b...more >>

I have a query I developed and optimised as well as possible before converting to a view. When running in query analyser the query runs in 15 to 18 seconds - which is acceptable. When "converting" into a view ( This is necessary for operational reasons) and running with the same param...more >>

Greeting, below is the complete SQL taken from aspfaq.com (retrieved from this newsgroup I believe) The query takes about two minutes to run. Does anybody have a better set based way (sub-second response) to determine business days? CREATE TABLE dbo.Calendar ( dt ...more >>

Is there any easy way to pass (dynamically) parameters to pass-through queries, when working with MS Access as front-end for SQL Server ? Thanks. ...more >>

We currently have a routine that "forks" out (to use the unix term)TSQL commands to run asynchronously via SQL Agent jobs. Each TSQL command gets its own Job, and the job starts immediately after creation. Sometimes we can have too many of these jobs running at the same, and the box crawls to...more >>

I am using Access as a front end to SQL and have a combination of two fields set as primary keys. I have two tables, and am trying to delete all occurences of the compound primary keys in one table, that do not occur in the second table. We can call the columns for the compound primary key ...more >>

Here's a quick and dirty example of a legitimate bug in SQL Server. I've seen other examples, but they were all very complex, some even involving cursors and such. This one will produce the error with just 13 lines. A police department has a database that contains, among other things, inform...more >>

Does anyone know much about this tool? Also, if anyone can point me to a TSQL coding standard, please let me know. -- Dave ...more >>

What is the best way to go about merging the results of two fields in the same table? I have two different fields that hold lists of names, some of them identical, some different. From those I'd like to generate a merged list with all the distinct names. For example: Field1 contains: Jac...more >>

Hi, I am writing a small dating site and now I am designing the DB. At some point I realized that I will need to create a table with more than 12 columns and I felt that it is not such a good idea. I've tried normalizing the database, but It was with no effect. So let's sat that I have the ...more >>

I'm having trouble with joins... TableA includes the fields name, order_number and value1. Tableb includes the fields order number and value2 I'm joining on Order Number. I want to return Name, TableA.order_number, TableB.order_number, value1 and value2. I want to return all order_number...more >>

I have a column in a table... ColumnA ColumnA contains positive and negative numbers What I want to do is insert an expression that basically does the equivalent of the following excel formula.. If(ColumnA>=3D0,"Use","Ignore") What should I change the following syntax to? SELECT *, C...more >>

I am in need of an ad-hoc reporting tool for generating reports from a database on an SQL server. Crystal Reports has all of the functionality I need but the price tag is too high. Are there any free tools out there like crystal Reports? ...more >>

Hello Eveybody, I have just joined as DBA.My problem will be simple for you all gurus.I have a table with 50 lakh row,when i am writing a select statement for this table it takes around 7 minute to display result.I used DBCC REINDEX for this table but it was not effective. So please pass ur s...more >>

Using the data below as an example I am looking for help with script that will return all rows of data where neither Field A or B are not 0 or Null Name A B John 2 John 1 John 0=09 John =09 Ste 1 Ste =09 Paul 5=09 Paul =09 Paul 0 Regards, Ciar=E1n ...more >>

Hello everybody, I need to know if Microsoft always officially maintains Microsoft Sql Server 7. My society is an editor also, if Microsoft does not maintains SQL7 we must say taht ou new versions are only compatible with MSSQL2K or more. Thanks for your answers Best regards Axel THIMO...more >>

Hi All, During the past couple of years I have been maintaining the company's Access databases, in the coming weeks I will be migrating data to SQL server, I will be using the Access forms as a frontend to access data while we developed a new front end through VB.Net. I was wondering if anyon...more >>

Hi, This is kind of last minute, I have a day and a half left to figure this out. I'm working on a project using ms-sqlserver. We are creating a ticket sales system, as part of the system, I need to be able to do a search for specific tickets withing price ranges, different locations within t...more >>

Hi All, I am banging my head against a brick wall over this problem, so any help in the correct direction would be muchly appreciated! I have 2 SQL (MS SQL) server tables, realated to - a Property, Sales of that property. A property is uniquely identifed by its Roll, valuation Nu...more >>

a problem is preventing windows form accurately checking the license for this computer error code: 0x800703e6 who has this kind of experience. Thanks Jeff...more >>

I have a stored procedure spGetAccessLogDynamic and when I try to call it I get the following error: Server: Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'S'. I dont know why because I dont have anything refering to stored procedure 'S' I have ran my SQL String ...more >>

We were trying to remove duplicates and came up with two solutions. One solution is similar to the one found in a book called "Advanced Transact-SQL for SQL Server 2000" by Ben-Gan & Moreau. This solution uses temp tables for removing duplicates. A co-worker created a different solution that a...more >>

Hi all, we are developing an internal application that involves "Timesheets", "Support" and "Project Management". Imagine that there are 3 different databases for the above scenario, under SQL Server 2000. My task is to create one or a few table triggers for INSERT/UPDATE/DELETE operations. ...more >>

Hi, I want to create a tool that run over Windows Server 2003 and checks the sql server 2000 edition (Enterprise, Standard, Personal, Developer). I know I can do from the query analyzer - "Select @@version". But how can I do it from code, is there a WMI API that can tell me what's the editio...more >>

Is there a function that will extract part of a string when the data you want does not occur in a specific position? Field "REF" is varchar(80) and contains an email subject line and the email recipients contact name Example data: Rec_ID REF 1 Here is ...more >>

Hi! I need to write a t-sql-script like this: (case-1) IF {stored procedure SP is not exists} BEGIN CREATE PROCEDURE SP AS BEGIN //dummy body END END ALTER PROCEDURE SP AS BEGIN //real body END and dislike the case below because it is possible that CREATE fails aft...more >>

Hello; I have just been hired at a new company which is a small auto insurance company. They have a package they purchased a couple of years ago which uses MS Sql as their database backend, ASP as their user interface, and Micro Focus Cobol as their business logic engine. Right, wrong, or ne...more >>

Hey @ all, I have a question: It is possible to convert an existing SQL Server 2000 Database to SQL Server 2005? best wishes! ...more >>

Hey, did anyone know a good paper or a good ms link about SQL Server 2005 - because I have problems to install the Beta Version.. thanks very much ...more >>

I have a table in a database that has just over 1 million records, each record about 50-60 characters. I need to transfer this data to another database. I implemented two options: 1) Read the data record by record and insert into the destination database, using ODBC. I played with different...more >>

Hi! We have Sql Server 2000 in our server (NT 4). Our database have now about +350.000 rows with information of images. Table have lot of columns including information about image name, keywords, location, price, color mode etc. So our database don?t include the images itself, just a path to th...more >>

Hello, I'm relative new to sql and databases and the last few weeks I learned myself a lot. I'm trying to make a hotel reservation application. I have a database with a table Booking, a table Room, a table RoomsPerBooking. So a booking contains date/time etc and a field RoomsPerBookingID. T...more >>

Hi, I am learning Ms Sql and I found that a lot of the tables I am finding ( in different tutorials ) are using special names for their column names such like au_username, au_salery ... Is the any naming convention for column names, or just at all is there any reason for naming the table colu...more >>

I need to make a system dsn connection on 50 pc. It's a system dsn connection with sql users I have though about to make a registry key, but I don't know where user and password are in the registry. My question is where in the registry can I find these keys? CD ...more >>

I need advice on how to approach this. To simplify with a sample, below is a list of various calculations based from ITEMS table: ITEM_NO FIELD_CALCULATION 123 cost*qty 111 cost-discount 222 sales*discount 333 cost-freight etc... ...more >>

Please help, I am trying to install MSDE 2000 so that Backup exec will run on this server. I have gotten so far as to find an entry in my SQLSTP.TXT file that says that c:\mssql7 was detected so the install fails. Now, to start with there is no directory called C:\mssql7 on this server. I...more >>

In SQL Sever, do the size of computed columns gets added to the total size of the tables? Does SQL server stores the actual values in computed columns? Thanks _GJK ...more >>

i'm trying to write a batch that will perform a complex task using set-based selects instead of a row-based cursor. let me know if you can help me figure out how. description of what i'm trying to do: there is TABLE1, TABLE2, and TABLE3 i want to select each row from TABLE1, do some analy...more >>

Hello My department has a SQL server database that is used to all facets of production within our department. This includes key production job steps, project names, numbers and descriptions. The calendar is currently done manually as an Excel document. The user recieves hard copies of the r...more >>

Hi, I have an application that causes a dead lock at random. The issue I am having is, when the deadlock occurs, my applications is not recieving any errors from the DB. ie, during the deadlock SQLServer is returning an empty recordset and user is seeing a blank screen. The app logic does not g...more >>

buddies, situation: a processing must take place on every row of a table, and output results to another table, that can't be done via an insert into..select query (let's assume that it's not possible for now). There're 2 solutions I have in mind: 1) open a cursor and cycle through each row (The...more >>