Hi there, I am re-organizing the database. We used to have field 'names' in our table for our first name and last name. However, I want to have...

portCo

03-12-2007 02:02 AM
othellomy@yahoo.com

After typing in the following I receive the Exception listed below: java -jar squirrel-sql-2.4-install.jar Exception in thread "main"...

tyrone_bak@yahoo.com

03-11-2007 07:29 PM
tyrone_bak@yahoo.com

hi guys. I have two table ; categories and products categories table; catid (int) catname, and products table has catid(int), catname I want to...

cemal

03-11-2007 05:09 PM
cemal

Relevant section of install log (all else was successful): -------------------------------------------------------------------------------- Machine ...

sherifffruitfly

03-11-2007 05:38 AM
sherifffruitfly

Hi, I know just about nothing about SQL Server. I am getting this error: The log file for database 'my_database' is full. Back up the transaction...

JA

03-10-2007 11:10 PM
Greg D. Moore \(Strider\)

I was in a bad car wreck and was not able to thank those who have helped me on several occasions. Thanks to all!!!

lwhite

03-10-2007 09:52 AM
lwhite

I think it's simple, but I can't get it to work. In English its: find records in TableA where the field has more than one unique value in...

paulmac106@gmail.com

03-10-2007 09:05 AM
--CELKO--

Is there a way to select records that do not contain a certain character string in char, vchar or text fields? For example records where the email...

Chris

03-10-2007 03:44 AM
Erland Sommarskog

Tony Nottingham England 9 March 2007 TO: All People Who Care A new European Chemical Testing Policy called REACH has now been ...

TONY

03-09-2007 08:55 AM
TONY

Hi, I have a C# web app that searches my database table using the following search parameters Search string, criteria (> < =) and the field you...

maflatoun@gmail.com

03-09-2007 03:18 AM
Erland Sommarskog

I found an unusual problem between 2000 and 2005 I haven't been able to decipher from any documentation. The query structure is as follows: select...

Luke.Schollmeyer@gmail.com

03-08-2007 05:54 PM
Erland Sommarskog

I am running the following script: begin set quoted_identifier off declare @pk int declare @where_clause varchar(100) declare @file_name varchar...

Connie

03-08-2007 01:56 PM
Connie

First a bit about what I' trying to do. I'm running SQL Server 2005 Developer edition on my dev box. I've got two instances set up and am trying to...

ceadtinneh

03-08-2007 12:46 PM
ceadtinneh

Hi, I want the change the SQL listen port of a named 2005 sql instance. Is there a way I can run an sql query against the named instance...

BF

03-08-2007 07:55 AM
BF

I have a long query which I have set off and would like to stop, and rename one of the tables used. My query is due to my lack of understanding of...

cheesey_toastie

03-08-2007 07:46 AM
Dan Guzman

I have three tables with a relationship I've never worked with before. Can anyone suggest/comment on the best way to create a third normal form...

bbcrock@gmail.com

03-07-2007 05:23 PM
--CELKO--

hi, on localServer i execute this query INSERT INTO table (A, B, C) SELECT A, B, C FROM LinkedServer.myDB.dbo.table everything is fine. But if i...

kuNDze

03-06-2007 11:29 PM
Ed Murphy

Hi All, I have a Access front-end,the tables are from SQL server 2000 and linked via ODBC using DSN. I have a Main table and several related...

Roy

03-06-2007 11:26 PM
Ed Murphy

Hello, I'm getting the following error message when I try add a row using a Stored Procedure. "The identity range managed by replication is full...

miller.brettm@gmail.com

03-06-2007 05:56 PM
Erland Sommarskog

I am using MS SQL Server management studio. I treid to see some system tables which are sysobjects, syscolumns, systypes, etc.., but i don't see the...

TGEAR

03-06-2007 05:42 PM
Erland Sommarskog

Hi, I have a table with 8 millions records. Some of the fields needed to be parse and modified. Example, "ABC DEF" will be parsed into two fields...

SQL Learner

03-06-2007 03:39 PM
Greg D. Moore \(Strider\)

Hi! I´m trying to create a merge replication publication for a SQL Mobile Application . Everything works fine creating the publication and I'm able...

CFTK

03-06-2007 03:51 AM
CFTK

I have a table which lists player names, teams played for and the years they played there and my code looks like this SELECT AlsoPlayedFor.playerID,...

Chris

03-05-2007 08:48 PM
--CELKO--

Hello, I'm trying to use a recursive CTE to find some data but I am having trouble crafting the CTE; maybe what I want isn't possible. I have the...

Mike

03-05-2007 08:35 PM
--CELKO--

Get control of our own life and time is the skills to be successful.This blog is strongly recommended. Recommended:How to get control of you life and...

erway

03-05-2007 08:12 PM
erway

Hi, I would like to convert real data type to datetime type. Example: I have a real data type which is: 23,613456 (23 hours and 0,613456). I would...

machina

03-05-2007 05:11 PM
Erland Sommarskog

On 05.03.2007 11:31, Dylan Parry wrote: SQL Profiler is your friend - for online as well as offline investigation. You can even have it include...

Robert Klemme

03-05-2007 08:15 AM
Jack Vamvas

Yellowfin has signed an agreement in conjunction with Chinese pharmaceuticals company Zuellig Pharma China. As we welcome in the Chinese New year,...

YellowFin Announcements

03-05-2007 06:20 AM
YellowFin Announcements

Yellowfin has signed an agreement in conjunction with Chinese pharmaceuticals company Zuellig Pharma China. As we welcome in the Chinese New year,...

YellowFin Announcements

03-05-2007 06:19 AM
YellowFin Announcements

I've recently migrated all databases to SQL Server 2005. I couldn't figure out how to create an SSIS package in the time I had, so I just stuck with...

jshunter@waikato.ac.nz

03-05-2007 12:56 AM
Russ Rose

I have an application which was developed on SQL 2000. I wanted to experiment with setting up live replication (Transaction based), so I took a...

Roger

03-04-2007 07:10 PM
Roger

Dose any one have a simple workaround to implement a connection from SQL 2005 SSIS 64 bit to Oracle 10 G

O-B

03-04-2007 06:42 PM
O-B

My office has adopted Team Foundation Server to track and manage the development and deployment process at our site. I have been asked to modify one...

davidz

03-04-2007 11:58 AM
davidz

I am trying to make a query on one table, an invoices table, and I want to see how many orders are in each month Year Month ...

DaBrain

03-04-2007 10:41 AM
--CELKO--

I am glad to announce that there is now a version of my article "Arrays and Lists in SQL Server" for SQL 2005 available on my web site. THe URL for...

Erland Sommarskog

03-03-2007 10:20 PM
Plamen Ratchev

We are in the process of doing a side by side installation of the SQL server 2000 and SQL server 2005 on the same server. To install the Reporting...

yhafeez1@gmail.com

03-03-2007 03:53 PM
O-B

IF (SELECT OBJECT_ID('t1')) IS NOT NULL DROP TABLE t1 GO CREATE TABLE t1 (c1 INT, c2 INT) DECLARE @n INT SET @n = 1 WHILE @n <= 454 BEGIN INSERT...

serge

03-02-2007 05:26 PM
Erland Sommarskog

I have 2 SQL Enterprise Editions running SP2 and same collation. When i try to start database mirroring I get the following error message: "The...

serge

03-02-2007 09:18 AM
serge

I have a SQL Server 2000 database and I need to insert and update data in the SQL Server databse and also post those same inserts and updates in a...

Lauren Quantrell

03-02-2007 08:33 AM
Lauren Quantrell

Hi all, I am new of the group and I hope that you can help me to resolve the "problem" that plagues me... I must unload the data of many tables (......

kabal77@gmail.com

03-02-2007 03:53 AM
kabal77@gmail.com

Hi, I have a table with 8 millions records. Some of the fields needed to be parse and modified. Example, "ABC DEF" will be parsed into two fields...

SQL Learner

03-01-2007 08:31 PM
Greg D. Moore \(Strider\)

I attempted to upgrade to SQL Server 2000 from SQL Server 6.5 using the SQL Server Upgrade Wizard and I immediately received the following error...

bob.ward@enron.com

03-01-2007 05:21 PM
Erland Sommarskog

Hello, I have a table that has a UserUpdated field which has a default value of SUSER_SNAME(). This works great when the record is created, but I'd...

Rico

03-01-2007 05:08 PM
Erland Sommarskog

We currently use SSIS to build DTS packages in which we store changes to our database schema, as well as scripts that need to be run upon each...

Ben

03-01-2007 03:37 PM
Mork69

Could someone please point me in the right direction on how to read in a large query with .net. I am trying to emulate a legacy database system so I...

troy@makaro.com

03-01-2007 01:59 PM
troy@makaro.com

Hi All, i am getting the error as posted below while executing Transfer logins using Dts package - sql server 2000 standard edition Can any body...

shark

03-01-2007 06:57 AM
shark

Hi My company buys new server( HP Proliant ML 570 with HP LTO ULTRIUM 232 Tape Drive. OS (Windows 2003 Enterprise - SP1) see it correctly (nt backup...

Leszekwl

03-01-2007 06:31 AM
Erland Sommarskog

Hi. I need to make a trigger which fires when after an UPDATE is done on table A in database X. The trigger must perform a statement which copies...

jcandersen

03-01-2007 01:42 AM
jcandersen

The iussue: Sql 2K I have to keep in the database the data from the last 3 months. Every day I have to load 2 millions records in the database. So...

Massimo

03-01-2007 01:25 AM
othellomy@yahoo.com

I do a lot of file processing and I usually run a little script I copy and paste to read directory information to see if a new file it there and then...

Utahduck@hotmail.com

02-28-2007 05:37 PM
Erland Sommarskog