Microsoft SQL Server Forum

I need to connect to several .dbf files every day and retrieve its information in a job every morning. Right now I run a seperate program to export the .dbf to text and then I BULK INSERT them in. I would like to skip the seperate program and do it directly. Anybody have an idea of how to create a connection to those tables? Any help...

Hello there, Im trying to change the owership of the DTS package but am a little confused. sp_changeobjectowner changes the ownership of table, view, or stored procedure in the current database... How could i change the DTS package ownership?

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

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"

Hi, I'm on SQL Server 2000, say, I have a table named , how I find if there is any column which has a formula in it? In other words, how to identify formula column programmatically? I've looked at information_schema.columns view for clue but to no avail. Thanks.

I'm using SQL 7. Trouble is i've changed the name of my server from ADMIN to ADMINDESK, since the name change SQL won't run. How do I fix this? Cheers Craig

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) Connection to db 2) Creation of one View...

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

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

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.

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 starts around 2:30 pm. The job GZIPs the trace file...

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

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). Any help would be greatly appreciated. I know...

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

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 and I wanted to verify that it is indeed an...

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 calculation. I need to implement this in SQL Server.

Here is the table in question. Number of records 5512825 not a big table and plenty of good indexs i think? that is the big questions. Could some one help? After the table creation and index you will see a query that takes almost 2.3 minutes to run this is totally bad. That time is through the query analyzer. Any help here would be greatly...

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 check execution time in a stored procedure? The...

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_change_users_login 'Report', and the logins...

Hi, I need to purge date of a table with 290 million records up to 50%. I'm planning to do in chunks but also needs to truncate the Transaction log manually(in a SP) after every purge operation. If somebody can tell me how do truncate T-log in a SP? My DB is running in simple recovery model and we don't take T-log backups. Its a OLAP db. ...

Hi, I would like to know how I can replicate an sql server from another one. I want them to contain at all times the same data. Thankz

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 to put an image field in each table OR make a...

How can I add a DTS package into a Job on the Server agent. I have read here about many problems peolple have encountered using this, but havent found any instructions how to set it up. i am also interetsed in creting the DTS package as a executable file so that anyone could execute the Job or DTS package. any help will be appreciated....

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 a question about option 2.

I'm fairly new to sql stored procedures. ok, I currently have a stored procedure that dynamically sorts as well as pages through a recordset: ___________________________________________________________________________ PROCEDURE dbo.ViewAllSales @Page int, @RecsPerPage int, @SortSQL varchar(100), @varSession_ID varchar(4),