I'm running Small Business Server 2000 (upgrade from NT4). I have a new XP Pro client that needs the SQL Query Analyzer and Enterprise Manager. How can I install these tools and where do I get them??? Thanks, Tod...more >>

Hi, i'm willing to upgrade from an Access to Sql Server. I've been told that it is possible to install a free version of Sql Server, not just a trial, but probably a version with less features. I do not know if it true, but if so, i'd like to know where i can get it. Thanks Sylvain...more >>

Sql Experts, I use Sql/Analyzer (Developer edition) on my XP client to execute a procedure on SQL/Server 2000 instance installed on Windows Server 2003 Standard Edition. I got the following error: { Server: Msg 16917, Level 16, State 1, Procedure MyProcedure, Line 591 Cursor is not ope...more >>

Are you able to have a sql 6.5 client and a sql 7.0 client on the same pc? Are their any compatibility issues? If so, are you able to use them at the same time? Can a VB app access both 6.5 and 7.0 at the same time? Also,can 6.5 and 7.0 reside on the same server? Are there steps you ...more >>

I have a VB 6.0 application that is accessing Sql 6.5 and Sql 7.0. The application is returning a ADO error:"Error - 2147024769 Method '~' of object '~' failed". This is only occurring on one machine. The machines is setup to be a Terminal Server. Other clients in the enviroment are working...more >>

According to the release manifest for the MDAC2.6 http://support.microsoft.com/default.aspx?scid=/support/servicepacks/MDAC/2.6/SP1manifest.asp it already contains ODBC driver, network libraries, OLE DB provider and even client configuration utility for the SQL Server. The question is why shou...more >>

I have 100s of stored procedures and I wanna change that stored procedures according to my changed naming convension.. Like one of my procedure is as follow. CREATE PROCEDURE [dbo].[CmsGetPatientMedicalHistory] ( @MedicalHistoryID INT, @PatientID INT = NULL, @IsActive...more >>

When changing a domain password in XPsp1, after logging off and back onto the PC Sequel Enterprise Manager loses all of it's Server Registrations. How so I get them to stay put? Thank you, John Carter...more >>

Ladies and Gentlemen, I am using a connection string like : 'Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=sa;Initial Catalog=DataDemo;Data Source=SERVERNAME';Network Library=DBMSSOCN;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ...more >>

I am in the process of purchasing MS SQL Server 2000 Standard (Retail) with 10 Clients MS P/N (228-00691). I am now trying to find out how to purchase additional CAL's for 5 extra clients (which will be per device) but am unable to find these. Are they available for purchase,a nd if so what is th...more >>

Hi all, I use DBServerEnum function from ntwdblib.dll to get the list of SQL servers on the network and it works perfectly unless there are secondary SQL server instances. In this case it only lists the primary instances. Actually I think it lists not the SQL server instances but the machines ...more >>

Hi, I run my .NET application For example, I keep a form that displays the result of a query open,and keep it idle for abt 30 - 40 minutes. (My application connects to a server running SQL Server 2000) Afterwards, when i try to requery data using that form, i get a network error stating t...more >>

I am attempting to change the data in a description field of our parts table. We are changing two words in the the descriptions. For example, Description = '96 inch, blue wood, 1/2 inch thick' to Description = '96 inch, walnut red, 1/2 inch thick'. The Description field has different de...more >>

Can someboby helps me hows to find and download free 70-228 exams?? Thanks all. ...more >>

Hello, Is there a way to get the username of the user connecting to your database when you use active directory as your authentication? I have VB desktop client. Thank you, Brandon...more >>

I get the following message when I'm inserting a row into a table. The statement is very simple, but there is a large amount of data going into one column. Internal Query Processor Error: The query processor ran out of stack space during query optimization All the KB articles I've found so...more >>

Can someone point me to or Does Microsoft have an article that lists the files installed when installing the Client Tools only option? I have searched Microsoft's Knowledge base but can seem to find any documentation. Thanks Kurt...more >>

Dear Prefessional I just wanna ask one question to you is that I have 55 procedures and in which I used PersonnelID, now I have updated my whole database structure and changed PersonnelID to VPersonnelID through information_schema.columns table but the problem is that I wanna update Personnel...more >>