I am designing a WEB BASED Accounting Software with ASP and SQL Server. For this I need some help for the Database design. My design is as follows. I)User table: User_id, UserName..... Users (e.g. John Smith) Each User would contain a following Group of tables a)Customers b)Supplier...more >>

I need a SQL statement to take data that would normally look like this in a result set (SELECT ID, Name FROM Employee): ID Name -- ------- 1 Aaron 2 Mike 3 Eric To look like this, in one row and column with commas separating each Name: Names ------------------- ...more >>

We're working on a new release of a software. In the existing version, each client connects and executes a long batch of analysis on some tables. In the new release, we need to allow each client to execute analysis on a subset of data, according to certain login information. Our idea is: 1...more >>

I have an Excel worksheet with 4 columns: F1 F2 F3 AutoNo A Y C 1 G C D 2 S W A 3 I have a table in SQL Server 2000 which corresponds to the above worksheet. What's the best way to update columns F1, F2, F3 in the table using the AutoNo fr...more >>

Is there some way to save a selection set in SQL so that another SQL query can further refine the prior query? ...more >>

Hi, I'am trying a very simple sql statement but it does not work. I use the SQL version 8.0 I use the "Northwind" sample database and the Table "Employees". The sql statement is: SELECT * From Employees Where City = "London" The returned message is: Server: Msg 207, Level 16, State...more >>

What is the easiest way to copy a record from one table to another (with identical structure)? Regards ...more >>

Hey All, We are running sql 2000 on 32 processor box. It is so weird that around 4:30 PM every day one CPU spikes upto 85-90%. It continues to go like that until rest of the day. We checked for jobs that will start around that time but no luck. Only thing that we doubt now is a job that star...more >>

Hi all, Can anyone help me with a script which would delete files or move them to a different folder at some scheduled time..! Please.....!!! Thanks in advance......more >>

I am hoping someone in this group can lead me to some whitepapers that discuss converting a legacy AS400 DB2 database to SQL2000 using DTS. I believe the AS400 is SNA so I'll probably need to connect through a Host Integration server. I don't need the details now, just a high level overview. ...more >>

Details: MS SQL 2000 dual Intel 1.2 GHz processors. 1 GB RAM 2.1 GB dB Dynamic Memory Managment. No other apps running on this server. First question: Since I have Dynamic Memory Managment setup, Is it usuall that the sqlsrv.exe process on the server steadily climbs and is in the 800 to ...more >>

Exponential Moving avg is calculated using the formula. EMA = (Today's Price)* K + (EMA yesterday) * (1-K) where K = 2 / (N+1) The user is going to Input the K. It is something like F(N) = Price * K + F(N-1) * (1-K) How can I reference, the previously calculated value in the Next row cal...more >>

Hi all! I am in need of writing a few stored procedures. The first one is to create a stored procedure to recover a database from backup and the second one is to create a stored procedure to execute a transaction log backup (even though I know this can be done through a maintainence plan). A...more >>

HI, I need to run same kind of transactions (basically deleting records) in a loop but I have only 1 hour in a day to run my procedure. So I need to set a timer in a SP so that SP terminates after one hour and then rest of the transactions will be done next day. Can anybody suggest as how to ...more >>

I am doing a complete backup on a sql 7 db and then doing a complete restore (with overwrite existing db) on a sql 2000 server. This is now our hot standby server. I have the process automated and it works great. The only problem I have now is the logins dont work. I have tried running EXEC sp...more >>

Hello all... I'm using asp to get records from an access database, very similar to the way datagrid would work. The title of each column in my table is a link that alternates the sort order between ascending and descending... my problem is that text WILL change its sort order just fine but nube...more >>

I am running SQL Server 6.5 on a W2K server. I recently encountered the problem described in Microsoft KB atricle 153455. The server has NO service packs installed on it. I have downloaded sp5a from the MS site and tried to install it, but I am told that SQL Server is not installed on the machin...more >>

I am trying to select many rows, but only the MAX rows of each distinct lead_seq. I don't want to actually select the MAX rows, just make it a condition. This is what I have: declare @in_report_date datetime SET @in_report_date = '07/06/2003' select lah.lead_seq FROM lead_action_history...more >>

Hi, guys...new guy here. Let me introduce: I'm a technical writer for B&N.com and I've been using ERwin Datamodeler 4, release 4.1.2771 to create data dictionaries. I'm not a DBA, though I'm slowly picking stuff up. I discovered something yesterday that from my perspective is quite serious ...more >>

I need a second opinion from someone out there. I have a database with about 20 tables. Each of these tables need to store one or maybe more images for each record. I cannot use a varchar field to point to an image file on the server. Therefore, I am trying to figure out if its better for me t...more >>

I have a 2 node Microsoft 2000 cluster with a shared storage device. I want to create automatic failover for MS SQL 2000 server. I can do that wit the following options: 1. Active/Pasive (one instance installed) 2. Active/Active (More then one instance/virtual sql servers installed) I have...more >>

Hi all, We have a VB App and MS SQL 7 driven web site running on a dual processor server. Lately, we've been suffering a problem whereby MS SQL Server seems to consume all available CPU power. The web application grinds to an unusable slow speed when this happens, and we tend to reboot the ...more >>

Hi all, I have a number like so 778625 and want to make this a more meaningful date (UK) so how difficult is it to add two digits in this case 19 to the front of this number? Many thanks Sam *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENE...more >>

I have a MS SQL 2000 dB that is 3GB, the transaction log is about 2GB. I do a full dB backup every night. My question is, shouldn't the transaction log shrink down to next to nothing after a full dB backup? D. p8oust7eh+...more >>

Hi, I'm using a SQLServer 7 SP3. I have noticed a connection of a login which is not declared on the server (in NT authentification and SQLServer authentification). I'm using the mixed mode authentification. May be the login is affected to a administrator group. Have you an idea of the w...more >>

Hi, We use a database with about 40 related tables. Some tables contain as much as 30.000 records. We use Access97 as an interface to the database. Now recently we have the problem that when we want to insert a row in one specific table (alwasy the same) the database makes blocks. Details:...more >>

Dear Experts, may be someone has a solution for the follwowing problem: I tried to get a columnproperty on an object which is not in the current database, but in one at the same server. The line below was tested with query analyzer. The selected db (selected by query analyzer) was 'smdb'. Th...more >>

I have a Microsoft SQL Server 7.0. I wrote a sql command that creates a temporary table with a ORDER BY clause. When a execute a SELECT on this temporary table sometimes the result is ok, but sometimes is not ordered. I didn´t see anything like that. Any clue? Is there any kind of lim...more >>

Have a BIG Problem with attaching a mdf-File to my MSDE! While attaching the following error appears: "The Header for this File is not a valid Database-Header. The 'PageAudit-attribute' is wrong. How can I attache (repair) this mdf file? Thank you for awnsers Michael Lorenz ...more >>

I am running a program that was created in VB that takes data from a scanned file and inserts it into our database. We have the column student id as the primary key and it is decremented every time it goes through the program so they are each unique and never overlap. The program has been workin...more >>

Hi, I am seeing very slow connections from some client enterprise managers to server. Even at server level it takes 1 minute or less to open a database. I have adjusted some of the memory for the SQL server, but there are only about 60 Dbs on the server, totalling about 2 GBs. CPU is ve...more >>

I need help in writing a stored procedure on SQL Server 2000. Basically the stored procedure's primary task is to generate invoice records and insert the records in a invoice table. In order to generate the invoice records, I have an initial table which are basically Day Records. The task that I...more >>

Hi, In our environment sp-spaceused returns: Allocated: 500 Unallocated: -100 Enterprise Database Taskpad shows that our total database size = 400 MB (320 used; 80 unused) Windows Explorer shows also that MDF file is more or less 400 MB. What does sp_spaceused exactly ??? How do I SE...more >>

I have an Access XP ADE application connected to a SQL Server 7.0 SP4 database. I have created a timestamp column in the main table. Unfortunately, I am now getting persistent write conflict errors. The order of operations are: 1. The application starts and loads the recordset into the form ...more >>

I have a database containing my own tables and data and I wanted to be able to query this against an accountancy program which has an ODBC driver. This was never a problem with MS Access and Jet but I hit Jet's limitations and have moved to SQL. Creating my own SQL database was no pr...more >>

I am currently migrating our Intranet from SQL Server 7 to SQL Server 2000 and have hit a problem with one of the applications. The application in question executes the folloiwing query against the database: select * from employee where emp_id = 760 In SQL Server 7 this works without a pro...more >>

i wanted to restore user DB from one sql server to another sql server , one database is having so many table and have user called digi he is created so many SP and some tables., when i restore the db it restored without any problem., after restoring application is not working how to ensur...more >>

COUNTING NUMBER OF SELECTS MADE table mytable { id, data, hits } users view data from the table: SELECT data FROM mytable WHERE id=1 --for example SELECT data FROM mytable WHERE id=20 --for example .... How do increment the hits column without replacing the above with...more >>

Dear all, I have created some triggers on tables for audit purposes. I want this process to be outside of the existing transaction for the application making the changes to the tables. - if for whatever reason an insert into the audit tables fails, I do not want the calling application to fai...more >>

Hi all, i'm working with SQL Server for about 4 years, and i have ever searching for a tool which can script my DATA in a T-SQL format to copy them very easy from one server to another. For example scripts like that: IF NOT EXISTS (...) INSERT INTO (...) ELSE UPDATE (...) I ...more >>