Hi , I want to update the column in a table based on the updation of the other column in the same table, but not getting the desired...

abinesh.agarwal@gmail.com

05-21-2008 02:13 AM
Erland Sommarskog

I have a transfer data task that gets some data from a table and outputs it to a pipe delimitd text file. How can I configure a transfer data task...

grant@technologyworks.co.nz

05-20-2008 11:58 PM
grant@technologyworks.co.nz

Hi there, I'm having a really tough time with a SQL statement and I am wondering if someone is able to help out or point me in the right...

jephperro

05-20-2008 01:08 AM
Ed Murphy

Hello: I want to find that the ntext column data string have more than 2000 characters. I need to truncate those strings to the segments with...

Snow

05-19-2008 04:06 PM
Erland Sommarskog

If we are doing a 1-way replication from a SQL Server 2000 (Publisher) through a firewall to a SQL Server 2005 (Subscriber), do any ports need to be...

Mike Husler

05-19-2008 10:19 AM
Jim

hello, i cant find how to make this select : here is what i have : 2...

noumian

05-19-2008 02:56 AM
Iain Sharp

Hi, We have a SQL Server 2000 based system which carries 1000+ DBs primarily setup as: 1 security DB, 1 transaction management DB, 1 message support...

Vikas Rajput

05-18-2008 05:03 PM
Erland Sommarskog

Hi everyone I'm trying to lock my SQL Server Desktop Edition down which is running on a relatively fresh install of Windows 2003 Server Standard...

daz_oldham

05-18-2008 05:00 PM
daz_oldham

Hi all I am trying to copy data from one database server to another. I only want to copy one table's data, not the entire database. The part that I...

Guineapig1980@gmail.com

05-16-2008 03:04 PM
Erland Sommarskog

I've got a scratch databse that's gone into a production mode. One of the things that our standards call for is that we log and monitor all login...

byrocat

05-16-2008 02:59 PM
Erland Sommarskog

Hi, I recently detached and subsequently reattached a database, and now I've had to go back to each table and re-establish the primary keys, as well...

ll

05-16-2008 02:14 AM
Tony Rogerson

Here's the thing. We have a SQL Server with more than 25 Databases on it. Each database is completely independant (but they all have the same...

Patrick.Laprise@snclavalin.com

05-15-2008 05:13 PM
Erland Sommarskog

Please help. I'm stumped. I need to create a dynamic variable in a procedure that will be used to update a variable of the same name in a table....

bprocopio@lifespan.org

05-15-2008 04:58 PM
Erland Sommarskog

I'm working on a way to copy most data columns from another row in the same table to a new row and insert the courseID value from the form that...

ll

05-15-2008 04:51 PM
ll

Check out the just launched Most Helpful Professional award website: http://www.mhpaward.com Thousands of selfless individuals across the globe...

xman

05-15-2008 01:39 PM
xman

When I use "sql server enterprise manager" gui and write an expression like where a=1 and (b=2 or c=3) it gets transformed into where (a=1 and...

Leif Neland

05-15-2008 11:55 AM
Shuurai

We've got a problem with a 2005 publisher to a 2005 subscriber. We had a merge subscription that got four months out of date. It was fine when...

Jim

05-15-2008 10:42 AM
Jim

I am inserting a stored procedure that is supposed to display duplicate rows, and it sort of works, but still non-duplicated rows show up...

Charlie

05-15-2008 07:54 AM
Plamen Ratchev

Hey Folks, Experiencing strange problem with SQL 2005 running on Windows Server 2008. When trying to connect via named pipes or tcp, it takes...

GatorDBA

05-14-2008 05:09 PM
Erland Sommarskog

Hi, I need to figure out what some code that was maliciously executed against a database does. However, it's in a very strange format. It simply...

anojjona@aol.com

05-14-2008 05:05 PM
Erland Sommarskog

I'm looking for someone with extensive knowledge in advanced SQL cubing living inside the GTA/Etobicoke/Mississauga area. Email me or reply to this...

gishnobspam@gmail.com

05-14-2008 12:56 PM
gishnobspam@gmail.com

Hello folks. I am somewhat new to the SQL World, but have a basic understanding of the language. I have a table that I am trying to update, and not...

papa smurf

05-13-2008 10:06 PM
Dan Guzman

Hi I was just wondering where you found the news about this attack? Eric said "Based on what I've been hearing about in the news, I'm guessing it...

Pumba

05-13-2008 01:19 PM
Eric

I know SQL Server has a bunch of system tables that have interesting little tidbits of info in them, is there any way to tell who last edited a...

Hermes

05-12-2008 07:19 PM
eisaacs@gmail.com

This is not supported in MSsql. update T1 set (theUpdatedValue, theOtherValue) = (select theTop, theValue from T2 where T2.theKey = T1.theID) Is...

Leif Neland

05-12-2008 03:00 PM
--CELKO--

Hello there, I was wondering if anyone could give me some advice on orphaned rows and foreign key constraints. I am migrating a MS-Access database...

John Sheppard

05-12-2008 02:54 PM
--CELKO--

Greetings! Just a brief note to let you know about Release 2 of Altova's v2008 product line. From very large file support, to new functionality...

announce@altova.com

05-12-2008 12:59 PM
announce@altova.com

I have a stored proc that returns a resultset. I would like to deposit that resultset into a table. Kind of like a "SELECT INTO", but using a...

Deane

05-12-2008 08:34 AM
Deane

The ability to report on key business metrics via customer portals has become a deciding factor in today’s outsourcing contracts as businesses demand...

Yellowfin

05-12-2008 06:16 AM
Yellowfin

On a SQL Server 2000 db I would like to setup a stored procedure that accesses couple tables and runs the extended stored procedure xp..cmdshell. The...

acw

05-10-2008 07:28 PM
Dan Guzman

I am running SS 2000 and am trying to set up the SS Agent account. The machine that the db server runs on is not setup to be part of a domain. How...

acw

05-09-2008 11:21 AM
Tom Dacon

First a simple question: Is it allowed to provide a date range that has an illegal date. For instance SELECT * FROM tbl WHERE datex >= 2007-09-01...

metaperl

05-08-2008 04:17 PM
Plamen Ratchev

I've got a SQL statement that has me stumped. Consider the following scenario: A donor gives the following gifts: in 2006 they give $250 in 2007...

ckauvar@gmail.com

05-08-2008 03:24 PM
Plamen Ratchev

Hi, I'd like to prevent Excel and Access (well any Microsoft Office application) from gaining access to a SQL 2000 instance, via an ODBC...

Jimbo

05-08-2008 05:21 AM
Leif Neland

Hi all, So I have these tables of items and item-types, and the items can be of several types: Items: ID ; Name 1 ; Item1 2 ; Item2

Danny

05-07-2008 10:32 PM
Ed Murphy

Hello, We have a large database of our customers. Some of the important customers records are flagged and can be accessed only by...

Neil Jones

05-07-2008 11:40 AM
--CELKO--

Hello all, I am new to managing indexes on large tables and need some help. Hopefully, I am not repeating question here. I searched as much as I can,...

dsdevonsomer@gmail.com

05-06-2008 04:43 PM
Erland Sommarskog

Hello, I am using SQL server 2000. I have created 1 folder contains HTML files, which resids on IIS on one machin. And my SQL server 2000 is on...

abhy

05-06-2008 04:37 PM
Erland Sommarskog

Dear comp.databases.ms-sqlserver, Stylus Studio 2008 Release 2 is now available.The following highlights some of the new features included in our...

DataDirect Technologies

05-06-2008 12:44 PM
DataDirect Technologies

Hi everyone, I am on site and have a huge issue I need an answer to ASAP. I have a Touch screen application. This app has a bbrower with 1 cell...

Lcoggshall@med-net.net

05-03-2008 12:41 PM
Dan Guzman

I have an sql server 2005 database in a shared host environment. I have an access database that links to a few of the tables over odbc. I want to...

jbot

05-03-2008 12:16 PM
Helmut Woess

Hello, I have been given the responsibility of upgrading a client application to use Windows authetication. Previously the application was...

Nubie

05-02-2008 09:11 AM
Nubie

Having problems with SQL Agent in SQL 7. Just noticed that my backup hasn't been running since the 17th. Went into SQL Agent, and the 4 jobs that...

Neil

05-02-2008 05:35 AM
Neil

Hi, I'm currently experiencing a problem with ASP.NET 2.0 and SQL Server 2000. I have a web application and a windows service (on the same...

Bobby

05-01-2008 04:02 AM
Bobby

Hi all, I'm hosting a site on DiscountASP and since I have full text enabled I need to schedule the population. However, they don't allow using...

maflatoun@gmail.com

04-30-2008 03:42 PM
maflatoun@gmail.com

I wonder if anyone could offer some guidelines on the following problem? I need to transfer records from a SQL Server table to an...

D.Stone@ed.ac.uk

04-30-2008 12:03 PM
DA Morgan

I am able to extract dates in the correct format i.e. SELECT CONVERT(VARCHAR(8), GETDATE(), 3) => dd/mm/yy My issue is that my users are selecting...

shannonwhitty@hotmail.com

04-29-2008 07:51 PM
shannonwhitty@hotmail.com

I know that in order to reduce network traffic you should always select only the columns you require but I have a stored procedure which must...

Danny Burton

04-29-2008 01:30 PM
David Portas

I wish to make my trigger more efficient in that it only processes columns that have actually changed. I am currently processing 9 columns...

rcamarda

04-29-2008 08:01 AM
Dan Guzman

hello all, i have created my site, got it ready for upload and even found out that i need to create my d-bases online BEFORE i upload them... (stop...

Rob Eventine

04-28-2008 05:16 PM
Rob Eventine