Après avoir installé le sp3 de sqlServer 2000, mas applis clientes n'arrivent plus à se connecter, j'obtiens le message suivant : DB Library :...

Laurent CLAUDEL

11-10-2005 03:48 AM
Laurent CLAUDEL

Hi I'm trying to deploy DDRK 3.0 in a Windows 2000 Server box, connecting to a remote SQL Server 2000 and i'm getting a Fatal Error message. Does...

Rodolfo Roim

11-09-2005 11:56 AM
Rodolfo Roim

Ok I have been trying to get use to this new interface for SQL server 2005 for a few weeks now and honestly I am halting ALL of our migrations to...

Jim

11-09-2005 09:57 AM
David Gugick

Can any one why I am facing the following error.. bcp pubs..authors out 'c:\Testing.xls' -c -S{local} -Usa -PDbPass Syntax error or access...

Rogers

11-09-2005 08:57 AM
Rogers

Hello I am running SQL Server 2000 with SP 4 on Windows Server 2003 Enterprice Edisction. I receive several notifications with the...

salvoWJ

11-08-2005 09:54 PM
Sue Hoegemeier

I'm not able to run queries on a MS SQL Server 2005 using the Query Analyzer from an XP Pro machine running MS SQL 2000. I'm able to connect to the...

Sal Young

11-08-2005 05:28 PM
Jim

Hello, I have a Microsoft Access front-end for a SQL 2005 database. The Access front-end was in SQL 2000 and worked perfectly. When I migrated it...

Stewart

11-08-2005 03:00 PM
Stewart

Hello Nada, Is SQL 2000 an absolute requirement? This might be much easier with SQL Server 2005. Thank you, Kent Tegels DevelopMentor

Kent Tegels

11-08-2005 09:32 AM
Kent Tegels

Hi, I am looking for a way to recognize differences between two sql server databases. Also preferably auto generate scripts to synchronize table...

Nalaka

11-04-2005 10:02 AM
Brad White

I want to search the value by specific match but I couldn't... can any one let me know.. select object_name(id) from syscomments where text like...

Rogers

11-03-2005 04:08 PM
Hugo Kornelis

I want to use only float datatype but the problem is that it return more than two decimal, I want to minimize to two decimal points? I don't want...

Rogers

11-03-2005 04:05 PM
Hugo Kornelis

I have default instance of SQL Server 2000 Workgroup edition installed on XP Professional. And, a default instance of SQL Server 2000 Enterprise...

Nam

11-02-2005 09:17 PM
Nam

With SQL Serve 2005 what version of MDAC is needed for named instances? Anything else need upgrading? Thanks.

Randy K

11-02-2005 06:26 PM
Brad Sarsfield [MSFT]

SQL Server 2000 w/SP4 FrontPage 2003 running on a 2003 Datacentre Server I'm having a few problems displaying data from a database on a...

Wayne

11-01-2005 01:26 PM
Wayne

hi...trying DTCPing.exe between xp & wk3.. xp connects with wk3 but vice versa is problematic Error visible at MSDTC Simulation V1.9 window of...

umer.zafar@gmail.com

11-01-2005 04:08 AM
umer.zafar@gmail.com

hi...trying DTCPing.exe between xp & wk3.. xp connects with wk3 but vice versa is problematic Error visible at MSDTC Simulation V1.9 window of...

umer.zafar@gmail.com

11-01-2005 04:08 AM
umer.zafar@gmail.com

Hi, is there a SQLServer utility or tool to equip regular non-techie users with the ability to create, run and save their own reports? That would be...

Levent ORER

10-26-2005 05:51 PM
Jasper Smith

A problem of security: From a vb.net form I created the chance to add an SQL Server user with role as administrator. To create it, username and...

fasttrack via SQLMonster.com

10-26-2005 02:39 PM
Sue Hoegemeier

Hello I am running SQL Server 2000 with SP 4 on Windows Server 2003. Every hour I receive several notifications with the following: Reply: Message...

Brett Davis

10-26-2005 02:38 PM
Sue Hoegemeier

i have a table name:NAMES Name Surname City Country ------------ ---------------- ...

bafidi

10-25-2005 04:17 PM
Hugo Kornelis

Hi , I have a sproc in sql server yukon ctp . which returns an xml blob. However on the client side , using ado.net when i try to call the...

Alok

10-24-2005 06:49 PM
Alok

i have a table: RECORDS1 fields: DATE1,NAME1 data is 21,10,2005 10:24:34 ANDY 21,10,2005 15:24:45 DAVID i search date with this sql

bafidi

10-21-2005 09:56 AM
David Gugick

How do you execute a SQL Server stored procedure or query from an Access mdb? Thanks.

John Lane

10-18-2005 08:44 AM
Mary Chipman [MSFT]

I am facing memory leaking problem and its increasing more and more. I would appreciate if you can guide me regarding this. O/s:- Windows 2003...

Rogers

10-17-2005 03:55 PM
Mike Epprecht \(SQL MVP\)

Situation: 1st time using Oracle for a training class. 1st install Problem: I just went through the instructions for " Installing the...

Taishi

10-17-2005 12:32 PM
Hilarion

Does anyone know how to change the delimiters on SQL Server 2000 SP4 Client software? From " " to ? For example: "dbo"."myTable" to

John Smith

10-16-2005 11:17 PM
Linchi Shea

What started this is that I was having the following problem with my SQL Server Client. The problem was in the Enterprise Manager SnapIn...

Dave K.

10-15-2005 01:09 PM
Sue Hoegemeier

I was able to connect to a SQL Server 2000 instance using ODBC on a Windows 2000 workstation (Service Pack 4). But after installing several...

Alton Chinn

10-15-2005 01:00 PM
Sue Hoegemeier

We're getting error messages on XP Pro clients connecting to an SQL 2000+SP3a server running Windows Ent. Ed.+SP1. The clients have SP2 installed...

GaryC

10-13-2005 11:33 PM
Matt Neerincx [MSFT]

Could anyone please help me out as to how we can save the excel workbook in the database and read it back. I was able to convert the text files and...

Jitender Khanna

10-13-2005 01:24 PM
SriSamp

I have a remote client accessing a SQL database via an internet connection to a public IP address on our SQL server. THe program needs to access a...

scottdog129

10-11-2005 10:31 AM
scottdog129

Hi Everyone, I have a problem while executing my application on the network. I don't know why this error "cannot generate SSPI context". I have been...

JoseTA

10-10-2005 07:19 PM
Sue Hoegemeier

A client has to insert many files with bulk insert. I start it using windows scripting host with VB Script and ole db provider for SQL Server. works...

Urban

10-06-2005 03:27 PM
Urban

Hello, I have a table with two field (name of the table : table_with_two_field) field1, field2 when i create a simple view with no clause...

toni

10-06-2005 02:22 PM
Mary Chipman [MSFT]

i go to security and open a user username=salih password=12345 i have a database name Stok i want this user to write and read only and execute...

bafidi

10-06-2005 05:35 AM
Hari Prasad

i am confused about inputing decimal numbers to access database and then to the sql database i use double at access and foalt dataype at sql server...

bafidi

10-06-2005 05:26 AM
Hari Prasad

I WANT TO KNOW HOW CAN I WRITE ONE QUEERY WHICH RETURN ME TOP 10 RESULTS FOR EACH MODALITY THAT BASED ON HIGH SALE AND I DO HAVE 10 MODALITY IN THE...

Rogers

10-05-2005 10:37 AM
Rogers

Does anyone know how to turn OFF Double Quoted Identifier Delimitation on SQL 2000 Developers Edition SP4 running on Windows XP SP2? All my...

John Smith

10-02-2005 05:57 AM
sekharsql

When I am trying to delete the record from flat table it gave me following error and that record doesn't have a constraints / triggers so why...

Rogers

10-02-2005 05:54 AM
sekharsql

Hello Forum readers, Any advise on the following, will be much appreciated : I have a customer who tries to extract some columns (fields) from...

Nick Dakoronias

09-30-2005 08:40 AM
SQL

I write you because I have a big problem with request access : when I use a sql server wiev in access (attached view) and i join it with a local...

toni

09-30-2005 04:57 AM
toni

Hi, I've installed the SQL Server Express CTP and can connect to it via sqlcmd I've made a database diagram in visio 2003 enterprise architect...

AnthonyG

09-30-2005 03:29 AM
AnthonyG

is there any solution to use null values to the parameter my sql commandtext= "select * from info where name=@name and surname=@surname" in visual...

bafidi

09-30-2005 12:26 AM
David Gugick

I don’t know to write SQL command filter. m_strQueryDelete.Format("DELETE FROM tab WHERE (Col1 = ’abc’ AND Col2 = ’abc’ AND ?????)" example: ODBC...

Joseph

09-29-2005 03:34 PM
Tony Sebion

Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are NOT in a domain. The second server has SQL 2000, the first has IIS...

Sam White

09-29-2005 10:56 AM
Keith Kratochvil

Hello All, I have SQL Server 2005 Installed and i have numbers of SQL Logins users which i want to use in my ASP.Net Application for...

Wajahat Abbas

09-29-2005 10:54 AM
Keith Kratochvil

Can any one help me regarding the postal code. As we have seen in the website we put postal code and it will display the nearest distance.... can any...

Rogers

09-26-2005 07:11 PM
John Smith

I am setting up a development box which will mirror production. Both boxes need to have the SQL client tools installed. I know that production has...

davidg@cuiab.ca.gov

09-26-2005 02:01 PM
David Gugick

Hi, one of our .Net 1.1 (VB) applications uses SQLDMO.DLL methods to get a list of available SQL Servers and display this list to the user. I...

Henry

09-26-2005 12:43 PM
David Gugick

Please tell me what is the purpose of these DBCC Commands? DBCC memospy DBCC memobjlist DBCC memorymap

Farhan Iqbal

09-26-2005 12:01 PM
David Gugick