I need a free, redistributable JDBC driver from MS SQL Server. (MSDE2000a) ...more >>

I've built an application that relies pretty heavily on XML to enable flexible creation of data entry forms and storage of the data entered into those forms. Currently, it stores data as an XML document in an ntext field. This is great because it allows me a great deal of flexibility in crea...more >>

Hi, I have problem running this query. It will time out for me... My database are small just about 200 members. I have a site for swaping appartments (rental). my query should look for match in a triangle. Like this member A -> B->C A give his appartment to B. B gives his appartment to C and ...more >>

During testing of an application, i noticed a difference between SQL 2000 and SQL 7, both with identical config. In a nutshell: A table has a trigger for UPDATE and DELETE. When a column in the table is UPDATED the following happens: In autocommit mode, when entering a trigger the trancount...more >>

whatisthe meenign of this error message in general ? [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. Kind regards Arun ...more >>

DECLARE @LastID int DECLARE @RowsToSelect int SET ROWCOUNT @RowsToSelect SELECT @LastID = [id] FROM MyTable ORDER BY [id] SET ROWCOUNT 0 I think that value of @LastID will be equals to [id] in the last row of select(i.e. row with number @RowsToSelect). But I don't understand why it's true...more >>

Scenario: ---------- SQL server: 192.168.1.3 Server 2: 192.168.1.2, a folder named ABC is shared out. Both servers have the same password for the account named "Administrator" ---------- i tried to execute the following command in SQL server (192.168.1.3): exec master..xp_cmdshell ...more >>

We currently have an SQL db running on a web server. One of these fields is a large(ish) amount of text data – up to 400 characters – and has been cast variously as varchar, nchar and text type to overcome a problem. The problem appears to be in retrieving the data via ASP. I understand that AS...more >>

Hi. We are using MSDE2000 on a Point of Sale application. We need to keep a copy of a few key tables as up to date as possible for backup purposes. We are looking at using triggers over the source tables to update the target tables using a linked servers setup. Distributed Transaction Coordina...more >>

I have a function that returns a table: CREATE FUNCTION dbo.Example(@Param int) RETURNS @Tbl TABLE ( Field1 int, Field2 int) AS BEGIN INSERT @Tbl (Field1,Field2) SELECT FieldA,FieldB FROM DataTable WHERE FieldC = @Param ORDER BY FieldA RETURN END The statement t...more >>

OK, first let me say that I am no DB person. But I have a user here who keeps getting this error whenever she does, whatever it is she does, with databases... A google search takes me to various forums where I am forced to sign up before I can read any answers. Interesting note here is t...more >>

Let me know what you think about the following code: DECLARE @MaxIdValue int DECLARE @MaxSortFieldValue nvarchar(50) SELECT TOP 1 @MaxIdValue = [id], @MaxSortFieldValue = [SortField] FROM ( SELECT TOP PageNumber*RowsPerPage [id], [SortField] FROM MyTable WHERE (FilterCondition) ORD...more >>

Please help me debug this statement: Select vVehRegNAddr.RegContChar1 From (((vVeh LEFT OUTER JOIN vVehBrand ON vVeh.Plate = vVehBrand.Plate) LEFT OUTER JOIN vVehRegNAddr ON vVeh.Plate = vVehRegNAddr.Plate) LEFT OUTER JOIN vVehLegal ON vVeh.Plate = vVehLegal.Plate) Where ((vVeh.Active = 1) ...more >>

I am experiencing blocking problems on SQL Server 2000, SP3a. I have read the posts and set up a job SQL agent to report on these occurences I save the results to a table before executing an sp to kill the offending process id. I am puzzled as to how a process that does no updating can be guil...more >>

i have table Controller (ControllerID, ControllerNAme, isActive) and tables SendControllerForCitizenClaim (SendID, ControllerID, Region), table SendControllerForCompanyClaim (SendID, ControllerID, REgion).. and so on .. i have 14 tables of SendController each for a certain purpose. I have a...more >>

We have a customer who got their site developed somewhere else. Well, this host sent me all of the files along with a sql script to create all the tables, sps, views, etc. I tried running it on our customer sql box which is sql 7 and I got a number of errors. When I ran it on my own machine w...more >>

Hi, I used sp_addlinkedserver to link to a remote server through ODBC. When I execute select count(*) from LinkSrv.SI.DBO.SIHeader in SQL Query Analyzer. It returns 13705 records. But when I execute select * from LinkSrv.SI.DBO.SIHeader. It only return 885 records. If I specify some columns, ...more >>

Hi, I would like to programmatically move rows up or down an ordered list. I have created a column to ORDER BY and filled with ascending integer values. Swapping the column values with the row above or the row below changes the row position OK but things start getting complicated when rows are...more >>

Hi, I'm trying to store large strings to a database, so am using the text field type (LongText). I have used this before when storing the html of a webpage, and was able to store more than 255 characters by using just a normal update sql statement. Now I'm trying to store the body of research ...more >>

Hi, I am building a search Query which takes 7 parameters: Lets call them @P1 .. @P7 (all Int's) The query is a simple select query like: SELECT * FROM MyTable WHERE (Field1 = @P1) AND (Field2 = @P2) .... My problem is that if some parameters are -1 they shall be disregarded. Is th...more >>

This one is interesting... Is there any way to pass a joined parameter into a UDF as I'm attempting below? I have a temp table that I'm trying to create: create table #t3 ( bmkPerson int primary key, LangCode nchar(5), SName varchar(1000) ) insert into #t3 select t2.bmkPerson, t2...more >>

Below is a simple UPDATE that I have to perform on a table that has about 2.5 million rows (about 4 million in production) This query runs for an enourmous amount of time (over 1 hour). Both the ChangerRoleID and the ChangerID are indexed (not unique). Is there any way to performance tune thi...more >>

Hello Ian, Sounds like SQL enterprise mgr cannot get to the server, due to routing / firewall limitations. Has the support staff given you access via a remote desktop tool? You may be required to do this, as some ISP's are very restrictive in the ports that are open through their network. If ...more >>

I'm very new to using SQL Server. All I'm trying to do at the moment, is create a System DSN on a Windows 2000 Professional desktop machine to connect to a SQL Server 2000 server which is running on a different network. When I try the DSN while connected to the SAME network that the SQ...more >>

hello, My friend and I are working on a project involving oracle 9i and an old Unify database. We got the oracle to see the unify (oracle running on windows) by using the heterogenous services on oracle. However, that was a test environment. The production environment has oracle running on...more >>

Hi, How to automate database backup (MSDE server v8.0)? Is some free tool which can help on this or can I use some stored procedure? Plan: Complete - 1 per week Differential - 1 per day -- *Best regards,* Klaudiusz Bryja ...more >>

We use xp_sendmail in a lot of our jobs to send out notification of success or failure along with a text message. The xp_sendmail is called in the stored procedure that runs in the job. Lately it has been failing with the following error message. Executed as user: INFOCISION\MSSQLExec. xp_send...more >>

Hi, I'm trying to read a varchar(50) field writed in Japanese using this sentence: is = rset.getBinaryStream(num); at that sentence the JDBC driver shows the following error: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data conversion. Does anybody ...more >>

We are wanting to try SQL server on a client site with a view to them upgrading to SQL, where the Aceess database has grown to a over 300Mb (when compacted) and is slowing down the application,. 1.Does the 120 day trial include all the tools to backup the database and design queries etc or is...more >>

Hi, I tried to add column headers and delete all rows to excel database which is a linked server to my sql server db. I got an error message, "delete data through linked server is not supported by Isam". I tried to use FSO to write to the excel file, but seems like FSO support write to ...more >>

Hello, I am looking for a good and free :) SQL editor. I tried SQL Creator but i had problms using it due to JDBC problems. (I am using MSDE2000a, so there is no Window SQL tool) regards Sebastian ...more >>

I am getting a "Could not allocate space for object 'temp_trc' in database 'Test' because the 'PRIMARY' filegroup is full" The database test has unrestricted growth (All the defaults). It resides on drive c which has 4Gigs free. I added new data and log files on drive d which is about 30G fr...more >>

Hi, I'm trying to write a trigger that on the insert/update of a column, I want a directory to be created. If insert then create or if update rename existing dir. Has anyone done thins before? Any pointers would be appreciated. Thanks....more >>

Hi, I try to use MSDE2000a with JDBC dirver. However I got error message saying VM encoding error (Cp 1250). I think i have to change a Collation during setup to Polish. I did this way, but installation fails then. I really dont know why. Sebastian ...more >>