Hello, I am building a packge where an FTP task needs to pull down a single file every day from a specific location. The location will only have...

cdun2

04-04-2007 03:28 PM
cdun2

I have a need to perform pagination while using dynamic sorting. As an exmaple - SELECT TOP(10) * FROM...

rmturner76@gmail.com

04-04-2007 12:48 PM
--CELKO--

I have users that need to schedule jobs (SQL 2000, SP4). They can create jobs, but can only see the core databases when they go to enter a step...

traceable1

04-04-2007 11:07 AM
traceable1

Hi All, I have a DTS package that runs calling a few stored procedures and an activeX module. The package does some data cleanup and load. It...

Query Builder

04-04-2007 09:46 AM
Query Builder

Hello All, Merlin Data Compass version 2 is available now. It is a Web based OLAP data access, analysis and interactive reporting tool. It provides...

_mubashir

04-04-2007 08:22 AM
_mubashir

Hello I have problem with reading from XML when XML is to large. Program delare 1-n variables where is declaration but can no make...

AJA

04-04-2007 07:38 AM
M A Srinivas

We are trying to migrate databases and DTS from SQL Server 2000 to 2005. A BULK insert with in a DTS is failing showing the error. Bulk load data...

deepakgeorge@gmail.com

04-03-2007 10:39 AM
deepakgeorge@gmail.com

I got the following definition tables: CREATE TABLE VENTAS ( CLIREAL INT NOT NULL, MATREAL CHAR(10) NOT NULL, QTY SMALLINT NOT NULL DEFAULT...

David Méndez

04-03-2007 08:39 AM
David Méndez

Newbie transiting from VBA to TSQL, using SQL Server 2005 Enterprise: Need help to do this: Open Table_A WITH TableA DO UNTIL .EOF Read value from...

bubbles

04-03-2007 01:14 AM
Ed Murphy

Keep in mind this is my first compiled SQL program Stored Procedure (SP), copied from a book by Frasier Visual C++.NET in Visual Studio 2005...

raylopez99

04-02-2007 08:00 PM
raylopez99

I'm running Vista Business edition on 2005 Virtual PC. Installed SQL Server 2005 Express latest download, with instance of MSSQLSERVER and service...

ianforgroupuse@hotmail.co.uk

04-02-2007 05:50 PM
Erland Sommarskog

I want to use Filemaker PRO/Server as a linked server in SQL Server (2000) I have a ODBC Driver (DataDirect ODBC 5.4) for Filemaker database When I...

Martin

04-02-2007 06:31 AM
Martin

I want to use Filemaker PRO/Server as a linked server in SQL Server (2000) I have a ODBC Driver (DataDirect ODBC 5.4) for Filemaker database When I...

Martin

04-02-2007 06:29 AM
Martin

This is how the data is organized: vID Answer 12 Satisfied 12 Marketing 12 Yes 15 Dissatisfied 15 Technology 15 No

franzey

04-01-2007 02:40 PM
Erland Sommarskog

I have a SQL 2005 database that's created by a survey data collection system. Users of this system are fairly non-technical and have little to no...

pinney.colton@gmail.com

04-01-2007 11:20 AM
Erland Sommarskog

This is a very basic question, perhaps more of a Windows XP Professional OS permissions question than a dB or programming question: how to create and...

raylopez99

04-01-2007 05:02 AM
Erland Sommarskog

how could I start learning SQL SERVER Im just student

any_Girl

03-31-2007 08:00 AM
Luuk

Hi. I just downloaded and installed Sql 2005 from the MS site. I see that my instance of Sql 2000 is still on the same computer. I assumed that Sql...

pbd22

03-30-2007 05:43 PM
Erland Sommarskog

I would like to allow a particular user to truncate a log file in a stored procedure that the user runs every day. At this moment the only personnel...

hedgracer

03-30-2007 05:41 PM
Erland Sommarskog

How can I create a field in a view that takes a date field and converts it to a month? For instance, if I have a field called "CreatedOn" with a date...

lisa.moffitt@gmail.com

03-30-2007 05:34 PM
Erland Sommarskog

Hello, I have a resultset as follows: fields: Name, RankID values: Prorduct A, 4 Product B, 33 Product C, 221 (etc)

Mike

03-29-2007 10:31 PM
Plamen Ratchev

I am encountering a weird issue with SSIS. I have a very simple SSIS package that executes a .bat file. Here's the actual file it executes: @Echo...

ansonee

03-29-2007 12:41 PM
ansonee

Hi all, I'm having a problem restoring backup from 2000 to 2005. The actual restore process went ok. However, the database user of the...

Gerd

03-29-2007 03:08 AM
kb

im writing a service that will be on a app server this is one of many service's to process Recordsets from Sql Server... 1 service may have 20...

DaveP

03-28-2007 06:41 PM
Erland Sommarskog

Please bare with me here: I have been running an SQL Express backend for a small project i've been working on. We've recently added a "small...

MacRae

03-28-2007 06:36 PM
Erland Sommarskog

Hello I watchet some posts but did not find answer to my question : how to import data from xml into mssql 2000 using t-sql? i tried: USE...

AJA

03-28-2007 07:35 AM
AJA

Following is our test steps. 1. Create directory E:\firefly in E:. 2. Create a test file a.txt in E:\firefly. 3. Create E:\firefly\test.bat file ...

Amber

03-27-2007 09:33 PM
Amber

Hi all, ISSUE: ==================== In SQL 2005 (sp2) I get the following error when preforming a bulk insert with an associated xml format...

Peter Nofelt

03-26-2007 06:36 PM
Peter Nofelt

Once I've added Files for a database across mulitple SAN drives will SQL 2005 automatically partition data across the Files automatically? Will it...

Erik G

03-26-2007 05:25 PM
Erland Sommarskog

Hi, We have a SQL-cluster with over 6300 databases, most of them pretty small in size and usage. For this reason all these databases are on...

Icemokka

03-26-2007 05:21 PM
Erland Sommarskog

Hi, We have stored proc name proc_test(str nvarchar(30)). So far this proc has been invoked from a .NET application assuming that only...

yashgt@gmail.com

03-26-2007 03:34 PM
Razvan Socol

I am MCDBA, I like your group, and i need to join it as a member but i do NOT know How . Please help Thank You maged.

magedsql@gmail.com

03-26-2007 12:38 PM
AlterEgo

Hi friends, First I would like present me. My name is Eduardo, I am publisher of the Mr.Bool Portal (that can be accessed through the address...

Eduardo Spínola

03-26-2007 11:05 AM
M A Srinivas

Hi, I would like to know details about the table name starts with prefix in sql server 2000. Actually i'm working on existing code. The existing code...

plmanikandan@gmail.com

03-25-2007 10:56 PM
DickChristoph

I have the following 2 tables: (BATCHES) BatchID KEY ID OrderID Action1DateTime Action2DateTime Action3DateTime Action4DateTime

Henrik Juul

03-25-2007 06:56 PM
--CELKO--

Hi, I am bloody amateure and I was wondering if someone could help me edit the statement below so it groups the field SCDMASTER.SCTY_CLASS_CODE and...

Andreas

03-23-2007 09:14 PM
Ed Murphy

How do I make a view non updateable? I want to create a view so that I will not be able to update, insert or delete the view so that base table is...

othellomy@yahoo.com

03-23-2007 06:05 PM
Hugo Kornelis

Hi, very new to SQL queries, and strugling with join concept I had to do a join based on a single field: select * from tableA, tableB

dave

03-23-2007 02:30 PM
Plamen Ratchev

Some of my receiving service side applications usually work offline, and they only are supposed to get connected to the network once/few times a...

fireball

03-23-2007 01:09 PM
Alan Brewer [MSFT]

Hello, I am trying to develop a database solution for an organisation in Indonesia. This organization has a number of offices and users throughout...

Michael

03-23-2007 05:54 AM
lyle fairfield

Hi! I need to refresh an entire database. I can recompile SPs with sp_recompile (or DBCC FLUSHPROCINDB), and refresh views with sp_refreshView, but...

Ben

03-22-2007 05:48 PM
Erland Sommarskog

Does anyone know where to start if I want an exported copy of home appliances, cars, cell phones etc. I just need to populate my database and I want...

vilasack.phothisan@gmail.com

03-22-2007 05:31 PM
AlterEgo

W23K 64 bit SQL 2005 SP1 64 bit (clustered). Whenever I start mail with sysmail_start_sp it starts and then stops with the following entries in...

DBA99

03-22-2007 11:33 AM
DBA99

Hi, I have a Sybase dataserver containing lots of (huge) tables that I would like to access from SQL Server (two different applications, using two...

arshad.tanveer@gmail.com

03-21-2007 11:44 PM
arshad.tanveer@gmail.com

We are planning a SQL Server 2005 install on VMware ESX, as the backend to a Sharepoint Services 3.0 web front end.. Do I gain anything at all by...

tlyczko

03-21-2007 10:45 PM
Tom van Stiphout

I have two tables (T1 and T2). In T1 I have a field FT1 that is a primary key in T2 I have a field FT2 that is a foreign key linked to FT1. These...

ebade2000@gmail.com

03-21-2007 06:06 PM
ebade2000@gmail.com

my query: select Product_List.*, Product_Sales.* from Product_List left outer join Product_Sales on Product_List.ID = Product_Sales.ID this works...

knowzero

03-21-2007 05:56 PM
Ed Murphy

create table t1(c1 int, c2 varchar(10)) insert t1 values(1,'Hello') insert t1 values(2,'') insert t1 values(3,NULL) select * from t1 c1 c2 1 Hello

othellomy@yahoo.com

03-21-2007 03:01 PM
Hugo Kornelis

Hi, I would like to compare two sql server databases. I need to find the difference in the two database(i.e table, colums, data type) Is there any...

plmanikandan@gmail.com

03-21-2007 12:55 PM
darek

I discovered that many of my very busy colleagues are having an extremely difficult time pulling themselves away to take vital training when it...

whosesocks

03-21-2007 12:51 PM
tlyczko