I have an Access 97 database that I connect to a SQL Server 2000 through ODBC. I have to manually set up the ODBC connection on each user's machine...

aperez@easternbk.com

04-22-2005 08:37 PM
MGFoster

I am trying to add a simple case statement to a stored procedure or user defined function. However when I try and save the function/procedure I get 2...

Gary Besta

04-22-2005 03:20 PM
Hugo Kornelis

Hi, I have the following query: SELECT p.employee_code, p.employee_name, CONVERT(VARCHAR(12),t.tran_date,101) AS...

mchen716@gmail.com

04-22-2005 02:55 PM
Hugo Kornelis

When I create a report without parameters it works fine. In preview (Visual Studio 2005) and when I deploy it. When I add parameters, in preview it...

Joško Šugar

04-22-2005 08:47 AM
Joško Šugar

I'm getting a type mismatch error on the mid(strRecord,1,1)="H" line. I used to do this all of the time, but I haven't done any VBScript for awhile,...

mychevworld@yahoo.com

04-22-2005 06:01 AM
Alex

Try: SELECT CASE WHEN @d1<@d2 THEN @d1 ELSE COALESCE(@d2,@d1) END or:

David Portas

04-22-2005 05:22 AM
David Portas

Hello ! I have a DTS package which I can run it fine from command line using one SQL account who is not a also a user in the windows 2003 machine.If...

Marios Koumides

04-22-2005 04:03 AM
koumides@gmail.com

Hi All, I am accessing a linked server (also a SQL Server) from a stored procedure. There is an insert statement that I run on a table in the linked...

mahajan.sanjeev@gmail.com

04-22-2005 02:19 AM
Gregor

Hi, I have installed a 120 day Reporting Services Evaluation Edition and today when I go to the Report Manager it shows me: Microsoft Reporting...

Karthik Guruswamy

04-22-2005 12:00 AM
Karthik Guruswamy

I have a web site on a remote, shared host with a bunch of individual Access databases. I want to switch my databases from Access to MS SQL and have...

Rupe

04-21-2005 06:48 PM
Rupe

I have a web site on a remote, shared host with a bunch of individual Access databases. I want to switch my databases from Access to MS SQL and have...

Rupe

04-21-2005 06:48 PM
Rupe

Good Day; I would appreciate assistance developing a query that I haven't been able to develop without using a second table. I wish to count...

Bill

04-21-2005 04:11 PM
Hugo Kornelis

Using Query Analyzer, I can right click on an object and select "script object to new window as create" and I get the text of the object's definition...

David

04-21-2005 03:42 PM
angsql

Greetings all, I am a network security professional rather than a MS SQL admin, so I apologize in advance if this is a bit of a basic question for...

tinbox@nyct.net

04-21-2005 11:08 AM
christopher.secord@gmail.com

Hi techies I have set up a Transaction replication from My Primary Server to Secondary Server on Orders table. Thousand of records gets inserted...

rajender_4@yahoo.com

04-21-2005 09:47 AM
rajender.mahato@gmail.com

Hi all! Are there any other way than using rights or Triggers to prevent a DELETE or an UPDATE on a specific column. The "problem" with rights is...

Jon

04-21-2005 09:37 AM
David Portas

Greeting, below is the complete SQL taken from aspfaq.com (retrieved from this newsgroup I believe) The query takes about two minutes to run. Does...

pb648174

04-21-2005 09:18 AM
pb648174

I'm using SQL Server 2000 and yesterday I seem to have lost my diagrams. Not the diagram icons themselves, but the data diagrams you see when you...

Tom Loach

04-21-2005 07:20 AM
Tom Loach

Hello all! I have such question to all of you. I have some tables linked from MS SQL Server 2000. Is time of processing query based on these linked...

Kamyk

04-21-2005 04:50 AM
Simon Hayes

Hi all, I need some help to access an SQL db on another machine. I am using VB.NET and remoting to make a client/server connection...although I...

Phil

04-21-2005 04:44 AM
Simon Hayes

HELP!!! I am trying to fine tune or rewrite my SELECT statement which has a combination of SUM and CASE statements. The values are accurate,...

gilgantic

04-20-2005 06:07 PM
gilgantic

would someone me so good as to help me out with the script for a basic customer table ? , usualy fields, userid (primary key) name,...

strawberry

04-20-2005 05:06 PM
Mike Epprecht \(SQL MVP\)

Can someone help with this syntax? I have a non-sensicle example below, but it illustrates the problem if you copy/paste into...

john.livermore@inginix.com

04-20-2005 03:48 PM
Gert-Jan Strik

Hello! I have data exported from a Reference Manager 11, and need to import it into and SQL database. Each record has different number of fields. ...

Tmuld

04-20-2005 02:58 PM
Thomas R. Hummel

Can you call a DTS package using VBA (specifically from Excel). I would like to have a command button to launch a DTS package that extracts data from...

Chad Richardson

04-20-2005 01:42 PM
Thomas R. Hummel

I hope I can get this across clearly. I have a table that needs to be broken into 3 tables. Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col1 and Col2 need...

The Bear

04-20-2005 01:05 PM
The Bear

I'm trying to learn how to make and use aliases for two tables in in this update statement: ALTER PROCEDURE dbo.UpdateStatus AS UPDATE...

shumaker@cs.fsu.edu

04-20-2005 01:02 PM
shumaker@cs.fsu.edu

I heard that you can store photos with the row in the new SQL Server (a photo data type?). Is this true? If so, is there a speed advantage if you...

Frank Bishop

04-20-2005 11:15 AM
Serdar Yegulalp

A word of warning, although creating or rebuilding a clustered index, moves a table to a new filegroup it does not necessarily move all database...

csomberg@dwr.com

04-20-2005 09:59 AM
johnbandettini@yahoo.co.uk

Im trying to recover my database using the mdf and ldf files. I dont have any backup and i have recovered two of the mdf files using a tool which...

mediodia@gmail.com

04-20-2005 08:38 AM
in_the_middle

Hi, As I wrote my message the solution came to me, so I thought I would post anyway for others to see in case it was useful: Here is some sample...

Thomas R. Hummel

04-20-2005 07:53 AM
Thomas R. Hummel

I am new to sql and very familiar with access. I am using a very large database(130M records) in ms sql2000 and think I need to front end it with...

bmeyynospamnospam@bmegroup.com

04-20-2005 07:38 AM
Simon Hayes

Dear All, imagine I have a server template like the one below <?xml version="1.0" encoding="UTF-8"?> <Root...

RolfK

04-20-2005 06:39 AM
RolfK

I have two servers: progress as transational server and mssql as warehouse server. I did DTS that "pumps" data from progress to mssql (via ODBC)....

Piotr Lipski

04-20-2005 04:35 AM
Alex

I am a retailer whose software back-end has just been upgraded from Access to SQL Server 2000. (The front-end is an independently-written shop Point...

James R

04-19-2005 06:54 PM
Bill

When I create a DTS to export a text file from a table, if I click on the Define Columns button and then Populate from source, then execute, it...

Krissy

04-19-2005 04:22 PM
Simon Hayes

Hi all, I am pretty new to dB programming and a have a few questions which I will put in separate threads. I have only coded as a hobby and some...

Phil

04-19-2005 03:55 PM
Phil

I am in a situation where I need to get a copy of test database that is on production server running MSSQL 2000 Standard to my local machine running...

len

04-19-2005 02:34 PM
Simon Hayes

Since there is no native support for 64bit integers in dbExpress, it is not trivial to fetch a BIGINT from SQL 2k. If it is possible, how can a...

Jon

04-19-2005 02:17 PM
Simon Hayes

Hi MS Newsgroup I am using SQL 2000 SP3 + latest hot fixes and I am editing a DTS package. When I save the package I get a SQL Server Access...

Rolf

04-19-2005 02:15 PM
Simon Hayes

I'm trying to diagnose deadlocks in SQL Profiler. The deadlocks were generated by Loadrunner scripts (stress testing) simulating application SQL via...

Robert_Couldry@linfox.com

04-19-2005 01:58 PM
Simon Hayes

-----Cross posted on comp.databases.ms-sqlserver and microsoft.public.sqlserver.programming----- Can someone please explain cardinality to me? I am...

Rizyak

04-19-2005 01:34 PM
Lee

Hi there, I have an Access front end application that uses a SQL Server 2000 Desktop Edition backend. I have created a package with the Access 2003...

Barb

04-19-2005 01:29 PM
funkybarb@gmail.com

Hi, I use Xorg's XWin in rootless mode on cygwin on XP Pro for quite a bit of my work. Unfortunately it seems to slow down SQL Query Analyzer's...

AM

04-19-2005 12:31 PM
AM

Hello; I have just been hired at a new company which is a small auto insurance company. They have a package they purchased a couple of years...

lsumnler@gmail.com

04-19-2005 09:05 AM
Akinja

Hi all I am new to SQL , what is the best way to learn SQL ? Is there a FREE online tutor ar ebook ? Thanks ec

ec

04-19-2005 05:43 AM
ec

Hi, I would like to prepare a data dictionary for my database (northwind). I have framed the below SQL SELECT 'NAME ' = a.name, 'DESCRIPTION' =...

anuu

04-18-2005 07:02 PM
anuu

Hi there, I sincerely hope that someone out there can help. I have two instances of the SQL 2000 Desktop Engine running. One is on my...

Barb

04-18-2005 09:34 AM
funkybarb@gmail.com

Hi, I'm designing a simple database for filing system: There are two levels of files (both look_up tables): tlkpFile1, tlkpSubFile1 and a...

grawsha2000@yahoo.com

04-18-2005 08:34 AM
John Gilson

Hi, Can someone give me advice ( or link to a webpage ) about how can I use primary key in my database and how can I use it for optimizing the speed...

John.Arthur@gmail.com

04-18-2005 05:14 AM
Simon Hayes