I have a little problem that I think I solved with a sledge-hammer and thought I'd post here to see if there was not perhaps a more elegant and probably quicker solution. Essentially I have a unique display condition on a table that must return data in a certain way. The problem column in quest...more >>

Hello all, I need to return back to TSQL two numeric values from an Extended Stored Procedure developed in C. As result my C dll program produces two float values, the TSQL side expects to have exactly: numeric(10, 5) and numeric. Given that the structure to fill-up is DBNUMERIC defined as...more >>

I am using SQL Server 2000, SP3. I created an updatable partitioned view awhile ago and it has been running smoothly for some time. The partition is on a DATETIME column and it is partitioned by month. Each month a stored procedure is scheduled that creates the new month's table, and alters th...more >>

SQL Server 2000: ######################################################## I run the following as a normal query from Analyzer: ######################################################## SELECT encrypt(user_password) FROM emp WHERE user_id = 1 ################################################...more >>

Hi All, I've been struggling with how best to define a query to get a list of unique coordinates from a database table and my SQL skills are not good enough to work out a good solution. The basic table structure is as follows: CREATE TABLE [Readings Data Table] ( CY DOUBLE, PY DOUBLE, ...more >>

Create a table (each time different table) – we have a DTS to do that -- 1 There is a fixed delimited text file; we need to Import this file into the created table above and we have another DTS to do that. –2 We want to combine these two DTS into one. The problem is when the table does no...more >>

Hi I implement a manual standby by backing up Transaction log files every hour and database nightly and restoring these on a standby server. Every thing works fine but the Transaction log restore fail with error listed I am sure the database backup finishes before the transaction log backups...more >>

Hi, I am getting the following error when I run a stored procedure in which I am inserting/deleting data from a view that selects from a remote table. INSERT failed because the following SET options have incorrect settings: 'ARITHABORT' The first statement in the stored procedure is 'set...more >>

Hi all, Here is a brief description of a problem I encountered, and how I found a work around after 3 long days. I have a VB6 app that uses ADO and ODBC to get communicate with SQL server 2000 (sp3, running in win2003). Everything was running great for a few weeks, but one day an update st...more >>

Dear all, Any MS SQL server driver for JDBC for window NT ? Thanks for reply. Victoria...more >>

Hello all, I have spend quite some time now but don't manage to find out how to have the srv_describe function working properly for target NUMERIC(x,x) and NUMERIC types. Already tried several alternatives like e.g. // ... PVOID pvdata1; strcpy((char*)pvdata1, "12345.6789");...more >>

I was wondering what everyone felt about the fomats in character fields where the front end application accepts anything. I wouldn't want a customer table where the customer name was lower case on one, upper on another and who knows on the third. If character fields are not consistent, then ...more >>

Hi there Anybody know how to increase the MS SQL server buffer size? I get an error when trying so insert some pictures as OLE objects. When transfering to the server i get an error, that the buffer sizes needs to be increased. Regards Rudi W....more >>

I have the following table - Name Enrolment# File# x 422 011 y 421 022 z 444 023 a 345 024 I have to produce the following table - S.No Name Enrolment# File# 1 a 345 024 2 y 421 ...more >>

I am setting up a combination of transactional and merge replication on a very large database and do not want to apply the initial snapshot since this would take to long. I am doing this with scripts that were previosly created when the database was not this big. I want to copy the publisher D...more >>

Hi All, I'm not that great with MS-SQL, as I never really have any occasion to use it. However, I need to get this one thing working and don't have a clue where to start. I have a comma-delimited file that's delivered to the server every night that contains updates to one of the tables. I...more >>

Hello, is it possible to insert new data into a datbase alphabetically? For example when a user enters a new row of data, I want the row inserted in the correct order. I do not think this is possible. Thank you for the help!...more >>

Dear all, Where can I find JDBC for MS SQL server? Thx for reply. Victoria...more >>

Hi, I am trying to put SQL Server Stored Procedures into Sourcesafe as per the Microsoft Knowledge Base article 818368, but have run into a problem. The web server is SQL Server 2000 running on Windows 2003 Server. The client dev environment is Visual Studio 2003 Enterprise Developer Edition...more >>

We have some rows that we need to do some tricky string manipulation on. We have a UserID column which has userid entries in the format firstname.lastname and i need to change each entry to lastname.firstname Can this be done by some script? Thanks so much for your help. Sid...more >>

Am working on a SQL Server 2000 db with Powerbuilder 8 as the frontend. For months our endusers connected thru the SQL Server native driver for version 6. Now, have just ported the application to Powerbuilder 10, and I understand that the native drivers for SQL Server 2000 no longer exist in...more >>

I've read that stored procedures should use output parameters instead of recordsets where possible for best efficiency. Unfortunately I need to quantify this with some hard data and I'm not sure which counters to use. Should I be looking at the SQL Server memory counters or something else. ...more >>

I am in need of a utility (stored procedure, third party app, etc) that will help streamline the process of managing and auditing object permissions, users and roles on multiple sql server 2000 instances with multiple databases on each instance. That's a quick overview of what I need, do I need ...more >>

I recently performed an SQL server 2000 installation. Other than placing the program files on C: and data on D:, I saw no option to install transaction logs in an alternate location. What is the best practice with SQL server 2000 for location of transaction logs? I remember that Microsoft us...more >>

I have a production database that is in the low gigabyte size and growing steadily. No issue there. I wish to completely refresh the development database daily on a second server. What is going to be the fastest easiest way to do this with hindering performance on the production system ? Th...more >>

Hi all, Currently our product has a setup that stores information about transactions in a transaction table. Additionally, certain transactions pertain to specific people, and extra information is stored in another table. So for good or ill, things look like this right now: create table ...more >>

I am writing a datetime field value to MS SQL Server 7 in the following manner via a stored procedure: // item to be written is originally a java.util.Date object java.util.Date fromDate; // I'm inserting it here into the database cstmt.setTimestamp(8, new Timestamp(fromDate.getTime())); ...more >>

Is there a way to check the type of a variable in SQL? I want to know if a variable is a float or a string. Thanks, Ramzi...more >>

Hi, I need to move a database from an instance running SQL Server 2000 SP3 to another running SQL Server 2000 SP2. Can I just use backup/restore or detach/reattach and let SQL server take care of any downgrading (if any). Many thanks Giovanni...more >>

if i query like select * from table1 then i will get the following **************************************************** Ticker col2 col3 col4 col5 ---------------------------------------------------- BRK.A 2003-05-02 70400.00 0.00 78500.00 FARM 2003-05-02 326.25 3.60 370.99 ...more >>

Greetings I have been trying to write a script that will list out the size of each user table in a specified DB. I am running into a scoping problem when trying to format my display. I am sure there are several ways to derive the results. My method won't allow me to select count(*) f...more >>

Hi There, Being quite new to MS-SQL I would like to ask if there is a general opinion of what approach should be taken to storing things like external documents and images in databases. Should the actual files be stored within the database, or instead should links to the files on a file ser...more >>

I have a table that I want to have a precalulcate length on a character field and group and sum up. Thought I could do this by creating a view with a group by clause that includes the sum function. Unfortunately, the compiler complains with: A clustered index cannot be created on the view...more >>

this is probably a simple sql solution, but i could use some help. i've got one table that has rows of documents, and another table with any number of ratings for each of the documents. The rating table is linked with an id column. the issue i am running up against is returning a single average ...more >>

Hi there, I have a few MySQL scripts that I need to run in SQL Server. However the syntax is just slightly different and I was wondering if there is a tool out there that can quickly convert these scripts so that they will work with SQL Server? Anyone have any ideas (other than manually co...more >>

Assume I have the two following tables: Employee --------- ID HoursWorked Contract ---------------------------------- 1 50.0 01 Fund -------- FundType Rate EmployeeID ------------------------------------- HW 4.3 1 ...more >>

Is there a way to let an account have execute permission on a stored procedure but not let that stored procedure run insert , delete, or update records. Basically only let them run or create stored procedures that do selects....more >>

I have some records that will not delete, whenever I run a delete statement in the Query analyzer, it never completes the statement, and I am only deleting one record at a time. Can anyone tell me why a record wouldn't delete?...more >>

I am trying to update text fields where the field only has the value "closed." So a field that has closed and anything else will not be updated. update dbo.Hist set dbo.Hist.Notes = '' FROM dbo.Hist WHERE (Notes LIKE 'closed_') update dbo.Hist set dbo.Hist.Notes = '' FROM ...more >>

Hello, Well unfortunately, I have to get an Oracle back end working with my product and am having a hard time doing it. I was wondering if anyone has had the same experience and could give me a little insight into what I am doing wrong (if anything). I installed Oracle 10g on a machine whic...more >>

hello i have implemented joe celko's model to store heirarchy and it works well and nice i have a question about SQL this is the actual table member side left right ------------------------------------------ nancy L 1 36 andrew L 4 ...more >>

How can I find which record(s) cause this error: Server: Msg 8152, Level 16, State 9, Line 1 String or binary data would be truncated. The statement has been terminated. I have tried Profiler but I can't get it to tell me which records are causing the error. Here's the script I'm running: ...more >>

I installed SQL Server, created a database for a sql server user and noticed that the user has access to the master database even though the checkbox for master database for the user login is not checked. They can list sysusers and find out all the names. They can list all the databases as wel...more >>

I am looking for the right tools to do application monitoring. I'm hoping to find one single tool that can do the entire job but if it does not exist then a few monitoring apps would do as well. I need the ability to do the standard things like testing for ping, checking for windows...more >>

Hi there Got a interesting problem (depends on a point of view.....). Background :- Agent (within Domino) is run daily basis which extracts data from Domino Notes application to SQL Server 2000 database. Agent first removes ALL contents and then appends ALL data. Reporting Tool is SQL ...more >>

Hi. I've created a linked server to Oracle 8i. I want to save a view as follows: SELECT * FROM ORACLE8I..SCOTT.EMP EMP_1 From SQL Query Analyser, this returns a nice set or records. Running this from the view designer also returns a nice result. However, if I try to to s...more >>

Hi All, I'm a relative newbie to SQL Server, so please forgive me if this is a daft question... When I set "Show Execution Plan" on in Query Analyzer, and execute a (fairly complex) sproc, I note that a particular query is reported as having a query cost of "71% relative to the batch" - how...more >>

Hi, How do I determine what version of the MSDE running on a server. I want to know if SP3a has been applied. Thanks. Egbon *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi... Have a customer who's running version 1 of oracle on a DEC machine.. is there a driver out there for that stuff? How might one get the data from the DEC machine to Sql Server 2000???? All I have now are fdl/sfl files. thanks in advance. Steve...more >>

I'm searching for some alternate administration tool (permisions, rights, etc.) on sql server, something not so complicated as default. Does anyone have some info about that? Thanks Pete ...more >>

I am trying to connect a new LBM Laptop to an SQL server on the network and I get "test connection failed because of an error in initializing provider, [dbnetlib][connectionopren(connect()),] SQL server does not exist or access denied. The laptom has sql server running on it locally and I am t...more >>

Hi, my database size has grown out of control and I need help with the following issues. (I am very new to databases) I am storing financial tick data in one of the tables and after two months the database has grown to 30GB. I do not need a permanent record of this tick data after it has been ...more >>

I need to make a tigger on some tables that diffrent ppl have Admin access to them using Ent-Manger. is there a way to store the current windows login user-name in to a log Table ?? the problem is all our IT dep have admin access to this database and I noticed that some tables are missin...more >>

Is there a way in SQL manager to have 2 columns multiply each other in another column? I have a quantity column and an each column and I want to value of those to field to be multiplied in a column call total. Is that possible?? Thanks Chad...more >>

hello everybody, I'am new to SQLServer.I have records from table as follows. column1 column2 column3 column4 column5 -------- ------------------- ------- ------ --------- Y 2004-02-17 00:00:00.000 0.00 152.70 0.00 0.00 WSC 2004-02-17 00:00:00.000 1.34 285...more >>