Hi : I have a TableA with around 10 columns with varchar and numeric datatypes It has 500 million records and its size is 999999999 KB. i believe...

rshivaraman@gmail.com

05-04-2007 05:17 PM
Erland Sommarskog

Rancho Santa Margarita, CA -- 1 May 2007 -- theKompany.com, producers and distributors of high-quality open source and commercial Linux software, are...

shawn@thekompany.com

05-04-2007 12:59 PM
shawn@thekompany.com

Calling ALL SSIS GURUS I am trying to import identical MDBs (Access Database) columns into SQL Server 2005 using foreach loop in SSIS. The data and...

Silly Milly

05-04-2007 12:27 PM
Silly Milly

I am using SQL server express as my web site's backend and need to store more than 8000 characters in a varchar field. When I use Varchar(Max) the...

t8ntboy

05-04-2007 11:22 AM
t8ntboy

I appreciate how difficult it is to resolve a problem without all the information but maybe someone has come across a similar problem. I have an...

Jane T

05-04-2007 08:58 AM
--CELKO--

I'm coming from a MS Access background and so I'm very used to and comfortable with the hungarian (Leszynski et al) naming conventions. However, I'm...

BillCo

05-04-2007 05:47 AM
BillCo

If anyone can help... I have a function that takes one parameter and bring back quite a lot of records. but with a conventional function the field...

Sibongile Khanyile

05-04-2007 03:20 AM
Erland Sommarskog

Hi, I have selected a field name and declared it as varchar, since it is varchar in table and performed some numeric operation with numbers, even...

meendar

05-04-2007 01:26 AM
meendar

Dear All, To return the recordsset I wanted I had to use 3 view OR IS THERE A BETTER SOLUTION ( 1 view, 1 SP ) ????????? TABLE1= ORDER (ORD_ID,...

Filips Benoit

05-04-2007 12:00 AM
Filips Benoit

All, I have the following table: CREATE TABLE ( IDENTITY (1, 1) NOT NULL , NOT NULL , NOT NULL , NOT NULL ) ON

hharry

05-03-2007 11:40 PM
--CELKO--

I do not know this is the correct way to do this, but somehow this isnt working. All I want is not to have a null value in field A if there is a...

jay_wic@yahoo.com

05-03-2007 06:24 PM
Erland Sommarskog

I'm very new to SQL Server 2005, so please be kind. We had a vendor in and they loaded their software and the database that was created is...

Dave

05-03-2007 06:19 PM
Erland Sommarskog

Hi I'm new to SQL and am having trouble figuring this one out. Any help would be very much appreciated. I have 2 tables 'A_Totals' & 'B_Totals'...

rich

05-03-2007 06:19 PM
Hugo Kornelis

Hi, I've been trying to export/import a table from a DB with Chinese_PRC_CI_AS collation, and I can't seem to get it working at all - the export...

InvestorTrade

05-03-2007 06:14 PM
Erland Sommarskog

Hi everyone: Using Sql Server SQL 8 I'm trying to INSERT records into a "can software package" batch table. I have a work-table that mimics the...

eighthman11

05-03-2007 06:06 PM
Erland Sommarskog

Hi EveryBody... I am using SQL server 2000 and i was working on Strore procedure and manupulating tables.Sql Server shows me messages that ur log...

Meonline

05-03-2007 04:48 AM
Erland Sommarskog

I'm basically a database noob hoping to find a shortcut if at all possible. I've created an ER diagram for a site I plan to build and have used that...

Mark S

05-03-2007 12:38 AM
Ed Murphy

I have a table with: Name, Qtr, Amount Tom, 1, 100 Bob, 1, 123 Tom, 2, 234 Bob, 2, 456 Steve, 1, 565 Steve, 2, 898

gwhite1@kc.rr.com

05-02-2007 10:38 PM
Plamen Ratchev

We've got a SQL 2000 Server running the Enterprise 120-day trial. Normally you can retain the information by upgrading it to the full- blown version...

Utahduck

05-02-2007 05:40 PM
Erland Sommarskog

(Config: SQLServer2005, MySQL5.0 and MySQL4.0 all running on Windows2003 server) I've created linked servers to my MySQL servers from SQL server,...

cybertoast

05-02-2007 05:34 PM
cybertoast

I have approximately 400 column descriptions stored in an MS Word document in MS Word tables that I want to insert into SQL Server utilizing the...

bbcrock@gmail.com

05-02-2007 04:50 PM
bbcrock@gmail.com

I have the following table. GO /****** Object: Table . Script Date: 05/01/2007 10:42:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO

Designing Solutions WD

05-02-2007 11:39 AM
Shuurai

Hi, I have some MSDASQL database files and I don't know this database at all. Can I get from somewhere SQL standard for this database? Greg. --

Grzegorz Meus

05-02-2007 11:06 AM
Erland Sommarskog

Hi, I'm using a 3rd-party app's back end which stores SQL statements in a table, so I have no choice but to use dynamic SQL to call them...

downwitch

05-02-2007 11:04 AM
Erland Sommarskog

Hi to all, I have a problem about a importation of a file *.csv with SQL Server, through a bulk insert, called in a store procedure that a c# sw...

AB@

05-02-2007 10:48 AM
Utahduck

In a message posted some time ago somebody had asked if there was a maximum number of indexes. I don't know if that was answered or not but I...

Utahduck

05-02-2007 10:41 AM
Utahduck

Hi all, I have a MS SQL server 2005 in a clustered environment (with 4 physical servers/cluster nodes). I need to move the cluster to another...

aleu@vp.pl

05-01-2007 11:47 PM
aleu@vp.pl

I would like to drop the leading 0x on a binary value so I can do a bitwise operation. Here is simplified code: select right(0x88186000,8) I...

tfeller

05-01-2007 05:39 PM
Hugo Kornelis

hi, CAn i have one trigger for both Update and Delete Delete Trigger --------------------- create Trigger on . for delete as begin insert into...

satish

05-01-2007 05:02 PM
Hugo Kornelis

SQL Server 2005 Help. I have a problem: On a 2000 box, I am calling the sp_send_dbmail stored procedure on a 2005 box (they are linked...

kataoki@gmail.com

05-01-2007 04:57 PM
kataoki@gmail.com

Hello there... I had an intrusion into my DB and I'd like to analize the log looking for the moment and the IP the modification was. Does anyone...

ing.edmundo

05-01-2007 01:28 PM
PBsoft

I'm new to SQL Server, so if I'm doing anything stupid don't be mean :) I have a procedure that I use to return data based on optional parameters....

BillCo

05-01-2007 09:06 AM
Greg D. Moore \(Strider\)

Hello! I have an big table with 50Gb data, written som functions that cleanup data and want to do something like this insert into newtable select...

B D Jensen

05-01-2007 07:42 AM
Erland Sommarskog

I am writing a function which will take two parameters. One the field to be returned from a table and second parameter is the ID of the record to be...

SQL Server

05-01-2007 07:16 AM
BillCo

I am looking to make a program using express edition Visual C#. I want my application to interact with Microsoft SQL server, create tables,...

Shane

04-30-2007 05:33 PM
Erland Sommarskog

Hi, Looking to port a very simple ASP application to XML Templates. I need to ability to search, receive user input, and update the DB. No problem...

hsomob1999@yahoo.com

04-30-2007 05:25 PM
hsomob1999@yahoo.com

I am replicating an 80GB database between NY can CT and would like to know why table sizes are different between the two. Here is an example of...

war_wheelan@yahoo.com

04-30-2007 03:11 PM
MC

What's New Yellowfin Business Intelligence 3.2! -------------------------------------------------------------------------------- Release 3.2 of...

YellowFin Announcements

04-30-2007 06:56 AM
YellowFin Announcements

The Topics Covered In This Book Are: Understanding the Oracle Environment; Understanding the Oracle Instance; Understanding the working of Oracle...

takveen@gmail.com

04-29-2007 11:41 AM
DA Morgan

I have SQL Server Manager 8.00.2039 installed because I have one program (app) installed that requires it be installed. For the first little while...

Sam

04-28-2007 04:05 PM
Erland Sommarskog

Hi, I have a funny situation. Within: MSSQL 2000 SP3, everything below described is running on same PC. there is a program running, which sends...

Matik

04-27-2007 06:04 PM
Matik

How can I change a character in a string of text. I have a bunch number that have a lower case l in them and I need to make them an uppercase...

Brian

04-27-2007 05:43 PM
Erland Sommarskog

I am looking to populate a Schedule table with information from two other tables. I am able to populate it row by row, but I have created tables that...

Nate

04-27-2007 10:04 AM
AndrewC

Hello everyone, I face currently a problem where I could need some input for searching the source of the Problem System: SQL Server 9.0 I fill...

pascal.baetscher@gmail.com

04-27-2007 09:39 AM
Dashu

Hi; My company just installed MS SQLServer 2005 ( see below the dotted line ). When a user logs into management studio all of the databases on...

Steve

04-26-2007 06:09 PM
Erland Sommarskog

hi, Does MS2005 JDBC Driver 1.1 support integrated security on Solaris and if so how? Thanks, MarcM

Marc Melancon

04-26-2007 11:45 AM
joeNOSPAM@BEA.com

I would like to remove an index from my database, but I need to verify that it is not being accessed before I do that. I tried running Profiler, but...

traceable1

04-26-2007 11:42 AM
traceable1

I had thought that I had posted this yesterday but since I cannot find it here we go again. I have searched the archives but either the code I want...

Mark D Powell

04-26-2007 11:28 AM
Mark D Powell

Hi, I'm trying to do retrieve some data from a table where the content is in Greek, however, the query is not working. It's a very simple statement,...

Ryan

04-26-2007 07:07 AM
Erland Sommarskog

Hello everyone, I'm looking into SQL Server 2005's Notification Services and wasn't able to find a way to create a notification event service based...

Anthony Paul

04-25-2007 10:53 PM
Anthony Paul