We have some SQL 7 servers and some SQL 2000 servers. I have loaded the client utility for SQL 7 and SQL 2000 on my workstation. I have connected...

Anne-Marie

07-10-2003 10:35 AM
Andrew J. Kelly

I'm new to SQL server. I installed SQL server on windows 2003 server. And I installed the client on my windows Xp workstation. When I try to...

ann

07-10-2003 10:34 AM
Andrew J. Kelly

Hi Andrew, From your description, "When the users first open a form, it takes a couple of minutes before anything happens". I would take the...

Bill Cheng [MSFT]

07-09-2003 05:54 PM
Andrew Kidd

Does anybody know when SQL Server came to a market? Thank you. Lilia Roumiantseva

Lilia Roumiantseva

07-09-2003 12:59 PM
Andrew J. Kelly

Is it possible (or will it be possible) to extend stored procedures using .net languages (not C++)?

Jason

07-09-2003 10:12 AM
Dinesh.T.K

I'm shooting in the dark...I have a customer running Windows Server 2000, and our software which uses Interbase Server 5.6 SQL server. I am currious...

thayer

07-09-2003 09:45 AM
thayer

Hi, If i install a 1 User licence on a SQL Server and write an application that connects as that user, do i require a license for each machine that...

clarissa

07-09-2003 08:24 AM
Andrew J. Kelly

Hi, Whenever i try to fetch text data from the text column data type to the client i get some just chracters. For example, suppose i am retrieving...

Jack

07-09-2003 02:49 AM
Jack

xiaowei (xiaowei.cao (AT) state (DOT) mn.us) writes: From which program did you try to connect? Since ODBC does not appear to even know to what...

Erland Sommarskog

07-08-2003 06:20 PM
Erland Sommarskog

I would like to backup/restore my database from my client application. What can I do ? Thanks in advance

Willy

07-08-2003 06:05 PM
Andrew J. Kelly

I need to be able to run SQL queries from Solaris against MSSQL 2000. I had been doing this using isql and Open Client from Sybase (version 10.x). ...

Stephen Lynch

07-08-2003 10:58 AM
Stephen Lynch

Which is exactly what MDI's database gateway does :-). Without a gateway, the app has to be re-written to use ODBC or OLEDB and then using an...

Blake Cheatham

07-08-2003 05:00 AM
Tibor Karaszi

This may be the wrong place to ask this, but here goes... How programmable is MMC? Can it be used as a front-end for a SQL Server app (it would...

Steve Jensen

07-07-2003 07:00 PM
Sethu Srinivasan [MSFT]

Hi All, I would like to know whether SQL Mail 2000 works properly with Outlook 2002? In the Sql mail, when I type in a domain profile and click on...

Mahita Gundala

07-07-2003 02:19 PM
Mahita Gundala

Ricardo (ricardoa (AT) infocorp (DOT) com.uy) writes: Of course you can store a URL in a table - but SQL Server is not going to anything special...

Erland Sommarskog

07-04-2003 06:56 PM
Erland Sommarskog

Hi, I have a rather 'busy' Access DB used by no more than 10 users at the mo', it doesn't have lots of records, (under 100k), bu the user drag and...

Vince

07-03-2003 04:03 PM
Mary Chipman

How to create SQL server database connectivity without a dsn? I am using ASP as frontend. *** Sent via Developersdex http://www.developersdex.com...

Sutapa Das

07-03-2003 04:10 AM
Allan Mitchell

When I save a file in Query Analyzer the program freezes up for 20-30 seconds at a time. This is getting very frustrating because out of habit I hit...

Tim Shults

07-02-2003 02:41 PM
Tim Shults

Hello! Using on other DBMS I am today needing to do some work on Sql Server 2000. My question is, are Subqueries "really" illegal in insert...

Jeremy Moncho

07-02-2003 10:58 AM
Vinodk

The Error, Could not find database ID 102. Database may not be activated yet or may be in transition, occurs when your query is too complicated. try...

jbaldwinson

07-02-2003 06:45 AM
jbaldwinson

Schedule a restart at early morning. :-) "Rocky" <rockwell.cc (AT) attbi (DOT) com> wrote

Gary X

07-02-2003 05:02 AM
Gary X

Snap-in failed to initialize. I know I need to register a dll on the client to give it the ability to use the snap-in, but I can't find any...

Andy Moon

07-01-2003 11:14 AM
Andy Moon

i have one big table with many records. I want to use one "append only" recordset with the oledbprovider. When i open the recordset, this take...

rulkin Guy

07-01-2003 09:37 AM
BlueGI

Check to make sure you have the Autoclose option for each database set to False (off). -- Andrew J. Kelly SQL Server MVP

Andrew J. Kelly

07-01-2003 08:41 AM
Andrew J. Kelly

Any of your clients that have MSDE or SQL on their machines should be upgraded, if they simply connect, no need to upgrade. HTH Ray Higdon MCSE,...

Ray Higdon

06-30-2003 06:35 PM
Ray Higdon

Hi, I need to separate certain data in a large text field into distinct columns, however I need to use regular expression to extract the data, as it...

Alex M

06-30-2003 01:59 PM
bruce barker

Go to the server in Query Analyzer and issue Exec sp_who2 You will see who is in the database -- Allan Mitchell (Microsoft SQL Server MVP)

Allan Mitchell

06-30-2003 09:58 AM
Dinesh.T.K

Meh (meganhudson (AT) today (DOT) com.au) writes: Seems like you should double-check how the server is set up, so that it really accepts SQL...

Erland Sommarskog

06-28-2003 06:13 PM
Erland Sommarskog

Maybe master..xp_cmdshell 'NET START' http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_8ak8.asp John "Farhan...

John Bell

06-28-2003 03:12 PM
John Bell

The VB 6 App receive the packet, then pharses it and fill a lot of variable. Then the App call a stored procedure (With ADO) called t_recepcion...

Javier Villegas

03-28-2003 08:44 PM
Javier Villegas