Hi all. Have a SQL server with about 10 small databases on it. One database in particular, the tables are somehow being recreated each night at...

Doug

11-11-2003 10:05 PM
Greg D. Moore \(Strider\)

I'm proficient in Visual Basic and MS Access, How difficult is it to make the change to developing SQL databases? Anyone have a good place for me...

Bill Kearns

11-11-2003 09:50 PM
Asli Bilgin

Hi, I've a prob in my office.i have a table with the following fields, table : acc_file acc_cod nvarchar(6) P.key acc_name nvarchar(30), level ...

Raghuraman

11-11-2003 06:15 PM
--CELKO--

Hi, I want to setup one of the fields in a table so it increments sequentially(int data type). i.e the first record should be record 1 and the second...

Sumanth Suri

11-11-2003 05:32 PM
Shervin Shapourian

Hi, I've used the minus functionality which is available in Oracle and i would like to use it in SQL server, but i don't know how to. The folllowing...

Sumanth Suri

11-11-2003 04:34 PM
David Portas

MSSQL2000 I have a table that contains customer transactions CustomerID Transaction TransactionDate .... I need to select the most recent record...

Tim Morrison

11-11-2003 04:25 PM
David Portas

Hi All I found an error ( run time error 3669. Execution cancelled) when ran the following query via VB6 SP5. select crc,month,sum(v) as v from (...

anita hery

11-11-2003 01:50 PM
anita hery

I have a table(work_order) with time as varchar(5). The values in table looks like this work_order_id rtim 1 08:15 2 ...

Jaidev Paruchuri

11-11-2003 12:21 PM
Jaidev Paruchuri

Reading a lot about Nulls right now I still can't find a Technical reason to use it or not. For what I've understand is this: In an Ingres database...

A.M. de Jong

11-11-2003 12:20 PM
Joe Celko

I'm trying to determine the best way of implementing a search engine searching through help content/articles. I would like to allow the user to...

Azmarae

11-11-2003 10:24 AM
Azmarae

admittedly, this SP is probably a mess given that I am not a TSQL pro. its purpose is to, based on the arguments, do 1) paging or 2) return prev/next...

Alex Vorobiev

11-11-2003 08:59 AM
Alex Vorobiev

Hi all, I think I have the right group, if I don't then I do apologize. My problem is that I'm trying to run a SQL script within a VB Environment....

Mark Davies

11-11-2003 08:57 AM
Simon Hayes

I'm having a problem with an update operation in a stored procedure. It runs so slowly that it is unusable, unless I comment a part out in...

David Berman

11-11-2003 08:10 AM
David Berman

SQLSourceSafe 2.0 is the right version control solution for SQL Server database development projects. SQLSourceSafe 2.0 Integrates with both SQL...

Ray Mu

11-11-2003 07:59 AM
Jay Allard

Hi all, I have been wrestling with this problem all morning with no success so far where I have a need to bring back an excluded field. Basically I...

Sam G

11-11-2003 07:59 AM
David Portas

Hi, I am facing a problem using the DBLIBRARY API dbconvert(). When dbconvert() is used to convert a MS SQL Server MONEY data type to DECIMAL and...

Suvodip Mukherjee

11-11-2003 05:50 AM
Suvodip Mukherjee

I need to execute xp_cmdshell in a trigger and pass a command line parameter to the .exe program i.e. I have a .exe program c:\program...

Dan Bart

11-11-2003 02:28 AM
Simon Hayes

attached is my full query that I am currently working on: Declare @counterday1 int Declare @counterday2 int set @counterday1 = '20' set @counterday2...

dregier

11-10-2003 06:58 PM
dregier

Hi, i am trying to parse an XML using OPENXML in a SQL server procedure. The Xml was created by the DataSet.WriteXml command in .Net. Here is the...

Sumit Khanna

11-10-2003 06:00 PM
Sumit Khanna

I am looking for the SQL Server 2000 Licensing Setup Utility Program and cannot find it. Everything I read says, goto Control Panel->Administrative...

DTB

11-10-2003 04:30 PM
David Burke

Is it possible to have a conditional union statement in a stored proc? Here's an example on the northwind database. If says there's a syntax error...

Thomas Baxter

11-10-2003 02:31 PM
Thomas Baxter

Is it true that binary and varbinary has a max-kapacity at 8000 bytes? Im jyst unsure how to read the dokumentation and want to be completely...

Flare

11-10-2003 01:47 PM
Simon Hayes

How do I detect with a query which database is off-line. And how do I detect with a query the recovery model of a database. Bye Arno de Jong

A.M. de Jong

11-10-2003 01:42 PM
Simon Hayes

I am seeing some strange behavior in sql server. Running a procedure with a table variable, selecting from the table, and exiting the loop will...

Rick Razzano

11-10-2003 12:26 PM
Rick Razzano

We've been using CVS for our HTML, JAVA etc.. Now we would like to use it for our SQL CODE to. We have a large database with many stored...

CaptRespect

11-10-2003 09:39 AM
Ray Mu

Hi all, I have been left to modify an old unique index, which no longer works, as the two fields, which were used, are no longer unique. I’ve found...

Sam G

11-10-2003 06:40 AM
Sam G

Hey all, Recently we had a small re-org which combined DBA teams, specifically Oracle and SqlServer. Just wondering if anyone...

Dave

11-09-2003 11:06 AM
Dan Guzman

I am writing a database app which will run under MSDE on the user's systems. Other than limitations as to the number of concurrent users, are there...

Mike N.

11-09-2003 05:52 AM
Andrea Montanari

I have a copy of MS Visual Studio 2002 Professional ACADEMIC which I understand is the same as the regular Professional version with the addition of...

Paul S

11-09-2003 05:48 AM
Andrea Montanari

Hello, A while back I dropped a text column from a SQL Server 7 database roughly 3GB in size. I expected the size of the database to decrease by...

Thomas

11-08-2003 05:22 PM
Andrew J. Kelly

I have a recordset in my VB6 app that was created using ODBC and I would like to insert the data into a SQL db table. I already have the target Db &...

ddg

11-08-2003 04:25 PM
John Bell

I'm populating an Access continuous form with lots of icons from a SQL Server backend. If I remove the field holding the icons from the stored...

Lauren Quantrell

11-08-2003 04:17 PM
John Bell

Hello to all: First let me apologize for the length of this question, I've made an attempt to include as much information as is needed to help with...

Mike N.

11-08-2003 04:16 PM
Mike N.

Hi I am not a frontpage expert, but I guess you have used a wizard to produce this UI? It seems that it thinks that one of the columns should be...

John Bell

11-08-2003 04:12 PM
John Bell

Thank you all (Chad, --CELKO--,Louis) for taking the time to help. As a result I have managed to achieve what I needed to. Sorry about not posting...

Sean Farrow

11-08-2003 09:31 AM
Sean Farrow

Hi All I need opinions on how to approach my task. I currently have 3 tables: the master table, the archive and a temp table. MASTER: has 3 fields...

Alvin

11-08-2003 04:12 AM
John Bell

I am new to filemaker, and i was wondering if there is any solution out there to export date from filemaker to SQL Server in an automated process?

Jason Berg

11-08-2003 03:49 AM
John Bell

I need to develop a Cold Fusion application using SQL tables, I am not sure how to setup my tables or that this is the optimal way of setting my...

MB

11-08-2003 03:44 AM
John Bell

First, I know nothing about PLC's, but I was wondering is there a way to extract data from a SQL database file, feed that to a PLC is some manner,...

Razorbak71

11-08-2003 03:23 AM
John Bell

We are trying to import data from a sql 7 machine into sql 2000 using import wizard in DTS. One of the tables has in excess of 80 million rows. The...

John Gill

11-08-2003 03:03 AM
John Bell

We are running SQL 7 on a Windows NT Server. If you copy a 25Mb file from this machine to a W2K server, the file copy takes over 5 minutes on a...

John Finch

11-08-2003 02:55 AM
John Bell

Hi Everybody, I am facing another probs. I have created a trigger for table Tab1 for perticular column col1 for checking value ranges.But at time for...

Arijit Chatterjee

11-07-2003 11:54 PM
Dan Guzman

12.) Now you have two different tables - each with two columns. Table #1 Single Column 2 rows with a value equal to 1 and 2

TimG

11-07-2003 11:10 PM
David Portas

There is a table with a single column with 75 rows - 50 unique / 25 duplicates. How would pull back a list of the rows that...

TimG

11-07-2003 11:03 PM
David Portas

is there any way to import from filemaker with an automated process?

Jason Berg

11-07-2003 09:15 PM
Tim Morrison

My query: SELECT DateValue() AS , TimeValue() AS , ., ., .Postcode, . FROM WHERE (((DateValue()) Between And ) AND...

Lapchien

11-07-2003 07:06 PM
John Bell

i have two servers this is happenning on. each has a maintenance plan with the same options selected... General Tab - applies to all...

Bill Gates

11-07-2003 06:09 PM
Bill Gates

Hi all I have a bit of a dilema that I am hoping some of you smart dudes might be able to help me with. 1. I have a table with about 50 million...

Sean

11-07-2003 05:08 PM
louis nguyen

Hello. Looking for a smarter way to code the following. I have a stored procedure I will be passing several variables to. Some times, some of the...

jason@cyberpine.com

11-07-2003 04:57 PM
louis nguyen

Hello All, I am new to SQL Server 2000. I need to load a bunch of (*.doc) word documents into image fields to do full text searches on them. I...

Rajesh Kapur

11-07-2003 03:19 PM
Rajesh Kapur