Terminology question: Is there a term for a set of records related directly or indirectly by key value in several tables? For example, a single invoice record and its line item records -or- a single customer, the customer's orders, the order lines for those orders, the customer's invoices, an...more >>

I have a table in sql 2000 that is storing Financial Tick data. The database size now appears at about 30GB and I have decided to backup the database and store the data offsite. Here is where I am confused about whether only a Database (complete) backup is necessary or whether I must also incl...more >>

Hi.. Im newbie on Report Services with VS.NET... I made a cube on olap.. and I try to lear some mdx for my reports.. But, in the report designer... I need a lot of help.. Please.. anybody.. can help me¨?? Thanks a lot...! Karina Gamez *** Sent via Developersdex http://www.de...more >>

How to upload a content of a table into sql-file (the set of INSERTs) using standard MSSQL utilities? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

How to upload a content of a table into sql-file (as a set of INSERTs) using standard utilities? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi, Is it possible to know workstation name from data in column net_address from master..sysprocesses? TIA...more >>

Hi, I have a tree structure which is maintained through the use of a path enumerated column: CREATE TABLE items ( item_id NUMERIC NOT NULL, path VARCHAR2(64) NOT NULL ); The path is is a colon separated list of ids of the nodes of the tree. So, for example, in this structure: 0 ->...more >>

Hi, I am trying to avoid a horrendous amount of coding and see if i can get away with a complex sql statement. I have data values (measurements) which I have stored in the database in the form of STRING so that i can keep the original format. They look like this: 000078 -> 7...more >>

Hi all I'v got a Windows XP Pro SP1 Box with MSDE sql2k SP3. The installation was not the problem, but if i would connect with a client like dbamgr2k or the MS Enterprise client, the client hangs up. If i try a nonlocal server, it hangs too. What's the problem? Markus...more >>

We are running SQL Server 2000 Developer Edition. I don't want to make the developers the sysadmin or even the dbo in the user databases. Is there a way to give them access to only view the permissions for the stored procedures in the user database without making them dbo? When I take them...more >>

This is maybe a dumb question but I couldn't find a definitive answer on BOL. Looking at my backup script. If I issue a CHECKPOINT, does this truly force all transaction log entries to the data file? Therefore, making it unnecessary to BACKUP log (just BACKUP database is needed). Louis...more >>

I've looked through many suggestions and partial examples all over this newsgroup and still am not coming up with anything that does specifically what I'm wanting to accomplish. I'm writing a VB 6.0 application which uses SQL Server as the back-end. Here's an example of what I'm wanting to ...more >>

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 >>