I'm planning to transport a desktop application to the web. A spin-off of this application has already been put on the web by another programmer....

07-23-2007 11:02 AM
Erland Sommarskog

Dear Group Please accept my apologies for this trivial question. I can't get it to work. What I'm trying to achieve is to find duplicate contact...

theintrepidfox

07-23-2007 10:24 AM
theintrepidfox

Hi, I'm trying to build a query that get only one row from a group of rows, but I need the values from that row and not the results of one function...

deluca.vicente@gmail.com

07-23-2007 02:35 AM
M A Srinivas

Hi, I have a SELECT FROM TABLE query and in that table there is a field of type image. Result of this select goes throug internet do its...

Koral

07-22-2007 08:43 AM
Dan Guzman

hello, I googled around some time but I found no solution for this issue (SS2000). I have a table tblB which has to be filled whenever in table...

candide_sh@yahoo.de

07-21-2007 11:59 PM
Serge Rielau

A Stefanini está com as seguintes oportunidade: Quem estiver dentro do perfil encaminha o cv atualizado para o e.mail: lpsouza (AT) stefanini (DOT)...

Recrutamento_Stefanini

07-21-2007 03:11 PM
Recrutamento_Stefanini

Why pay over $90.00 a month for Cable or Satellite TV services? Instantly Turn your Computer into a Super TV Get over 3000 STATIONS on your PC or...

C biz

07-21-2007 02:38 PM
C biz

Hi Group, I developed a intranet site using MSSQL7/win2000 some time ago. The target environment used MSSQL2000/8. We were (almost painlessly) able...

Erwin Moller

07-20-2007 05:23 PM
Erland Sommarskog

Hi. I have a "union" table which results of a union of two tables. Occasionally I could have duplicates, when the same PIN has been added to both...

Radu

07-20-2007 04:28 PM
Hugo Kornelis

I've written a small dos batch script that runs a simple query through osql and then calls an exe which sends an email if the returned value The...

Stephen2

07-20-2007 09:01 AM
Stephen2

hi i use sql 2000 server and windows 2003 standart server. i have problem, when i open the database in sql server, i see this error message "error 0:...

kucuktosbiii

07-20-2007 05:24 AM
Erland Sommarskog

I am having difficulty connecting to SQL Server 2000 on one of our servers via a VB6 program on Vista. I can connect fine to a different server, but...

TerpZebra

07-19-2007 11:49 PM
William Vaughn

If you think you can easily translate most relational division problems to sql you should write a book. If your not even sure what relational...

steve

07-19-2007 07:14 PM
steve

hi all I want to write a sotred procedure which has a parameter,called @name.The SQL statement must return all rows where this parameter is...

anoosh

07-19-2007 05:57 PM
Gert-Jan Strik

Hi, I am stumped and was hoping someone could help me out. Any help is appreciated. I have a view that looks sort of like this (but with a lot...

gaholmes@comcast.net

07-19-2007 04:59 PM
Erland Sommarskog

I am looking to try and connect to SQL Server via a DSN-less connection in a VB application. Setting up ODBC data sources is a headache for each user...

RLN

07-19-2007 11:43 AM
Erland Sommarskog

Hello all, Does anybody know if it is possible to set the default value of a field to equal the concatenation of 2 other fields? I.E. Field 1 =...

Drew

07-19-2007 11:36 AM
Erland Sommarskog

I need to store 256 bit hash (SHA-2 alogrithmn) in one of the table's primary key. I would prefer to use numeric data type rather varchar etc. *...

anilkmakhija@gmail.com

07-19-2007 11:32 AM
Erland Sommarskog

Hello all, Does anybody know if it is possible to set the default value of a field to equal the concatenation of 2 other fields? I.E. Field 1 =...

Drew

07-19-2007 08:18 AM
Drew

Hi, all friends. I'm using SQL-SERVER 2000.I have a table like this: NIF Name ---------------------------------------- A-1234 ...

simonshang@gmail.com

07-18-2007 08:48 PM
Ed Murphy

This is a Dataphor/Sql Server 2005 'demo' based on the concept of the ansi Sql-99 OLAP window for cumulative sums. Dataphor - An example of rapid...

steve

07-18-2007 06:15 PM
steve

Hello I'm calling a stored procedure in VB6 using the "execute" command of rdoquery. Does anyone know how to check whether or not the execute command...

David Greenberg

07-18-2007 05:50 PM
Erland Sommarskog

Hi! I'm trying to set up a full text catalog for my criminal database, but I'm running into some difficulties. Example (Just to start)... WHY Do I...

Piero 'Giops' Giorgi

07-18-2007 05:45 PM
Erland Sommarskog

Hi. We are using SQL Server 2005 64-bit on Windows Server 2003 R2 x64 Enterprise Edition. I have a really weird problem where I have people out...

SkyGringo

07-18-2007 05:31 PM
Erland Sommarskog

Using SQL 2000, how can you combine multiple records into 1? The source data is varchar(255), the destination will be text. I need help with the...

rdraider

07-18-2007 05:18 PM
Erland Sommarskog

SELF NOTE: Use DTSRUNDec.exe utilities Instructions: put ' sum -r/size 18641/11513 section (from "begin" to "end") sum -r/size 34729/8334 entire...

Anonieko

07-18-2007 04:07 PM
Anonieko

We're seeing something very strange on our SQL Server 2005 9.0.2047 DB on Windows Server 2003 x64 Standard: 1. Most open connections to the database...

sql_server_user

07-18-2007 01:27 PM
sql_server_user

I am brand spanking new to SQL and just learning all of it's intricacies and pecularities via the OJT route. I'm tring to import a comma delimited...

Philip Kline

07-18-2007 10:33 AM
Philip Kline

Hi, I'm using the 64-bit version of SQL Server 2005, SP2, on Windows Server 2003 R2 X64 Enterprise Edition. I've got a bunch of users out there who...

SkyGringo

07-17-2007 05:45 PM
Erland Sommarskog

Hi, We are trying to solve a real puzzle. We have a stored procedure that exhibits *drastically* different execution times depending on how...

sqlgirl

07-17-2007 05:38 PM
Gert-Jan Strik

Hello, I have been having a tough time writing the follow requirement for a query. On a table that the primary key is a tagId and an hourly...

mcdonaghandy@gmail.com

07-17-2007 01:34 PM
Roy Harvey

Hello, I am trying to use the SQl Server database reporting tools to create a report on the database to find areas for optimization including...

mail2suneelgupta@gmail.com

07-17-2007 12:47 PM
sqlmatt

hello, I googled around some time but I found no solution for this issue (SS2000). I have a table tblB which has to be filled whenever in another...

candide_sh@yahoo.de

07-17-2007 12:03 PM
Roy Harvey

Hi all :) My apologies if I posted in the wrong groups, but I just jumped in MS SQL waters, so any guidance will be appreciated. What I'm trying to...

Limunski Magarac

07-17-2007 06:54 AM
Limunski Magarac

Is there a way to back up the structure of the database only? i.e. backup without the data. I sometimes need to backup a database in one location...

Trevor Best

07-17-2007 06:52 AM
Trevor Best

Hello, I'm new to this group and I sincerely hope I'm not stepping on anyones toes or doing something the wrong way around by beginning my time...

alexander.arvidsson@gmail.com

07-17-2007 05:59 AM
Erland Sommarskog

HCL hiring IT professionals -- Noida/Gurgaon/ Chennai 1. VMWare Admins - 40+ Positions - Gurgaon 2. Sun Solaris Admins - 3+ Yrs Exp - 100...

dbaguru

07-17-2007 03:15 AM
dbaguru

We have created a Certificate for the purpose of symmetric encryption. We did not mention the expiry date explicitly, only later we found out that,...

mplpost@yahoo.com

07-17-2007 12:15 AM
mplpost@yahoo.com

Hi All: I need to make my database unavailable when i am loading the db. This happens daily and the db is not connected to any online app, to...

rshivaraman@gmail.com

07-16-2007 06:16 PM
Erland Sommarskog

Hi Does anyone know of a "test bank" for the Northwind (or any other freely available ) database? I'd like to go through some practice questions to...

FortisChet@gmail.com

07-16-2007 09:26 AM
FortisChet@gmail.com

Hi ! Has anyone got examples of calling an SqlServer stored procedure from a VB6 program using RDO ? Thanks David Greenberg

David Greenberg

07-16-2007 03:39 AM
David Greenberg

Am Thu, 12 Jul 2007 14:09:21 +0200 schrieb Zvonko Bi¹kup: .... You have to use the instance name too. If it would be a standard installation from...

Helmut Woess

07-16-2007 02:46 AM
Zvonko Biškup

want to download Infoarmatica powercentre..badly.searched in all the torrents.but didnt find..could anyone tell me abt tht.. thanks..

rrghosh@gmail.com

07-16-2007 12:43 AM
rrghosh@gmail.com

I was trying to retrieve all the records from a table, Crates that fall within a particular date range for the field ShipDate, which is of type...

Aaron

07-15-2007 05:08 PM
Hugo Kornelis

Hello, I am using a DTS package to import data from DBF files nightly. Recently, it has started to include spurious ì characters into the ì data;...

erik.myllymaki@gmail.com

07-13-2007 10:59 AM
erik.myllymaki@gmail.com

Bjørn (bjornsuneandersen (AT) gmail (DOT) com) writes: That is how I would read it to. I would still prefer to use sp_autostats turn autostats...

Erland Sommarskog

07-13-2007 04:32 AM
Erland Sommarskog

Hi, How to add new table to merge replication ? When I do this in Enterpriise Manager i got an error: Server: Msg 2758, Level 16, State 1, Procedure...

szaki

07-13-2007 03:16 AM
Damien

Assume the following table, where the columns represent two-word strings (word1 and word2) and the part of speech of the second word, along with...

markdavies2003@msn.com

07-12-2007 10:29 PM
--CELKO--

Hi guys, I've been asked to re-write a sql view. The view itself contains several calls to other views (embedded). Is there a way to get...

colabus@gmail.com

07-12-2007 10:21 PM
--CELKO--

In MS SQL 2005 when you do a Full Backup does it also backup and truncate the transaction logs or do I need to back the transaction logs up...

Brian D

07-12-2007 06:18 PM
Erland Sommarskog