Hi all, Can anyone help me with a script which would delete files or move them to a different folder at some scheduled...

Raj

07-13-2003 04:18 PM
Erland Sommarskog

Use the replication tools that SQL2K server provides. But using identity columns for userids ... may create issues. me (AT) ray1 (DOT) net...

GoodDay

07-12-2003 11:40 AM
Thomas

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

Cobra Pilot

07-12-2003 06:07 AM
Simon Hayes

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

Senthil

07-11-2003 09:08 PM
Dan Guzman

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

Andrew Chalk

07-11-2003 07:57 PM
Ray Higdon

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

Peanut044

07-11-2003 05:47 PM
Erland Sommarskog

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

D. Buck

07-11-2003 05:43 PM
Erland Sommarskog

Thank you for responding, that's the problem there is no error. I just get a null result. @quantityInvoicedSumCurrent produces a null result, but...

smack

07-11-2003 05:22 PM
Erland Sommarskog

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

John Posada

07-11-2003 04:57 PM
John Posada

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

Mahesha

07-11-2003 04:28 PM
--CELKO--

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

Subodh

07-11-2003 10:57 AM
Subodh Goyal

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

Dave

07-11-2003 08:56 AM
clockworkoi

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

Subodh

07-11-2003 08:54 AM
Subodh

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

Iasonas

07-11-2003 06:25 AM
Iasonas

"Josef Ober" <j.ober (AT) ober-online (DOT) de> wrote This error usually occurs when you try to insert or update a value in UK format (for...

Simon Hayes

07-11-2003 04:44 AM
Simon Hayes

armusis (AT) yahoo (DOT) com (Armusis) wrote in message news:<73bbb637.0307100246.15f0c388 (AT) posting (DOT) google.com>... It's difficult to give...

Simon Hayes

07-11-2003 04:27 AM
Simon Hayes

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

Peter A.

07-11-2003 03:33 AM
uiukin

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

Meyzi

07-11-2003 03:24 AM
Meyzi

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

Nico de Groot

07-11-2003 03:17 AM
Simon Hayes

I'm fairly new to sql stored procedures. ok, I currently have a stored procedure that dynamically sorts as well as pages through a...

MEM

07-11-2003 02:45 AM
MEM

Heres a free sql server exam software.Will make you completely prepared for you interview. http://www.harisoftwares.com free exam vb6 , vb.net,...

shiv

07-11-2003 01:16 AM
shiv

Some options here... --#1 EXEC sp_tables --#2 SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE_TABLE'

Anith Sen

07-10-2003 05:43 PM
Erland Sommarskog

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

Dave Phelan

07-10-2003 05:26 PM
Erland Sommarskog

Ok..here is my problem. I have two SQL servers that I need to have identical, at least semi-real time data on. One is in a public DMZ with full...

Daniel

07-10-2003 05:09 PM
Erland Sommarskog

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

derochema

07-10-2003 04:08 PM
Anith Sen

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

Alpay Eno

07-10-2003 10:47 AM
Aaron Bertrand - MVP

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

D. Buck

07-10-2003 09:49 AM
A.M. de Jong

DBCC CHECKIDENT (tablename, RESEED, 1) Will start the ID back at 1. HTH Ray Higdon MCSE, MCDBA, CCNA *** Sent via Developersdex...

Ray Higdon

07-10-2003 08:07 AM
Ray Higdon

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

Jerome

07-10-2003 02:36 AM
GB

Fardad - try AJS from www.argentsoftware.com Neil Pike MVP/MCSE. Protech Computing Ltd Reply here - no email SQL FAQ (484 entries)...

Neil Pike

07-10-2003 02:21 AM
Neil Pike

Hi, At One of our PC (Windows XP) we are using a VB Application and which is connected to the SQL Server Remotely through VPN Setup. The Application...

Amit Kathuria

07-10-2003 01:09 AM
Amit Kathuria

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

Hightower130

07-09-2003 05:29 PM
Erland Sommarskog

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

Jan Willems

07-09-2003 05:23 PM
Erland Sommarskog

I am looking for SQL performance monitoring tools like SQLPower. Please share your real world experiences in using these tools. Thanks in advance.

Lou Bakos

07-09-2003 05:12 PM
Lou Bakos

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

Aleem

07-09-2003 05:01 PM
Erland Sommarskog

Hello, I have an ADO based C++ application (see code below) that is running the sql statements (see statements below) in sequence on SQL Server...

db dude

07-09-2003 04:21 PM
db dude

I am trying to run a trace on SQL Server 7 using the Query Analyzer tool (not the profiler). The commands that I run are the following: DECLARE...

db dude

07-09-2003 03:01 PM
db dude

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

Paulo Andre Ortega Ribeiro

07-09-2003 01:08 PM
Anith Sen

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

S G

07-09-2003 12:06 PM
nigelrivett

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

rjp

07-09-2003 11:23 AM
Anith Sen

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

gwaddell

07-09-2003 09:54 AM
gwaddell

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

Rolf Kemper

07-09-2003 09:39 AM
Simon Hayes

this is a known bug in sql server 2000 sp3 or higher. MS has a hotfix available if you call support (it's not yet released to the public). -- Posted...

mkbw

07-09-2003 09:17 AM
mkbw

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

Adam Ryan

07-09-2003 08:07 AM
Adam Ryan

You can come up with something along the lines of... SELECT ( SELECT COUNT(*) FROM tbl t1 WHERE t1.col1 <= t2.col1 ), col1, ... FROM tbl t2 ...

Anith Sen

07-09-2003 07:49 AM
WangKhar

I'm running SQL Server 2000 SP2 transactional replication. Periodically replication fails due to primary key errors. On investigation I find that...

Walt

07-09-2003 07:27 AM
Walt

I am trying to implement a very fast queue using SQL Server. The queue table will contain tens of millions of records. The problem I have is the...

Chris Foster

07-09-2003 04:47 AM
Chris Foster

Hi I have a table of containing a list of products that looks a bit like this Product Qty Available Allocated Sold CPZ 2 ...

Simon Bigwood

07-09-2003 04:39 AM
Simon Bigwood

hi all this is my first post to this group, so pls bear with me while i try to make some sense. i am trying to create a sproc which uses dynamic...

adrian

07-09-2003 03:30 AM
Erland Sommarskog

Goodmorning, I can't connect to a DbServer in my Lan ,because the server gives me an error ,"not trusted connection" when i try to connect with an...

RRoberto

07-09-2003 02:50 AM
RRoberto