Hi I have an access mdb frontend/backend app. To use sql server as backend, is it better to keep the mdb frontend or should I switch to adp instead? Thanks Regards ...more >>

Every article which I've seen proposing Stored Procedures makes the same comparison: Stored Procs are faster than submitted SQL because Stored Procs are precompiled. Fine, but there's a third alternative, which I haven't seen mentioned at all. How do Stored Procedures compare with VIEWS? No...more >>

We have VB clients connecting to a SQL 2000 server and some are using named pipes and some are using TCP? does any one know why this would happen? Thanks ...more >>

I want to create the procedure in my dynamic database like that but it's not working... can any one add their idea regarding this... Thanks DECLARE @SQLSTATEMENT VARCHAR(200) SET @SQLSTATEMENT = 'CREATE PROCEDURE '+@DBName+'.dbo.Portal_AddEvent ( @ModuleID int, @UserName nvarcha...more >>

I have created the stored procedure and I want to handle the error like Create Procedure MytablePro as select fld1, fld2 from mytable GO EXEC MytablePro if some one changed the table name at the back end then I have to give problem error but right now when procedure execute it gave m...more >>

I am creating a plan to upgrade our SQL Serve r2000 servers from SP3 to SP4. Is there a service pack for the client as well? Or do I run SP 4 on my client installations as well? Any guidance would be greatly appreciated. Thanks in advance...more >>

Hi All Having 'Google-ised' I've found that there does appear to be a problem connecting to an MSDE 2000 DB from a remote machine (either LAN or WAN), but I haven't found what the concrete solution is. It definitely appears to be a Windows inflicted problem, as I can connect to the DB no pr...more >>

I took the back from Enterprise version of sql server and trying to restore at MSDE Version... it restored successfully but after that when I try to see the tables and procedures it gave an error and like the database is not the valid schema.. can any one tell me what I have to do ? ...more >>

Hi everybody: I am developing an application that uses SQLServer 2000 as its data repository. I have a varchar field in one of my tables, and when I do: update PolicyInfo set policyInfoName = N'ñ,á,é,æ,ä,å,û,ý,ß,?,?,?,?,?' where id = 1 I got a policyInfoName = ñ,á,é,æ,ä,å,û,ý,ß,ß,e,...more >>

I have a user who would like to connect to a SQL Server database using SAS (a statistical application) and have the system tables not be displayed Currently, when the user connects they are shown all of the tables (including system table). We have inquired on the SAS side and have been tol...more >>

Can any one tell me about the comparision of SQL Server 2000 & SQL Server 2005. Like any website where I can find the enhacement like 1) SQL Server 2005 : We can pass the dynamic value of top in the procedure. Select Top @Top from T...more >>

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 edition and want to (forward engineer) generate it on the SQL Server. Visio keeps saying that the driver is incompatible with express. I've tried ...more >>

I want to know the password of one user... how can I know... I have a admin rights... I don't wanna change the password ... I only wanna know..... Thanks in advance.....more >>

can we connect named instance through IP like in the network utility I just defined the IP of the server where the named instance installed and define the port.... Client Netowork Utility > Alias > Alias: MyServer Server: 209.45.23.55 Port : 1434 Protocol: TCP/IP any thing else I n...more >>

I am trying to connect the named instance from my client computer... I can easily connect the default instance of my remote machine but when I tried to connect through named instance it gave me an error that SQL Server doesn't exist or access denied.... In the client network utility I have def...more >>

I couldn't connect to named instance in my client machine... I recieved the error messange.. SQL Server Doesn't exist or Access denied. Can any one guide me... Thanks ...more >>

I'm using a client software to connect to a server. Everytime I try to log in to that software an error: " ERROR 70: Cannot Create Servre Object". I currently use a Microsoft Advanced server with the clients having a WIndows XP OS. What do I need to do??...more >>

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections. What is the definition of a "connection"? For example, if I create a connection pool of 5 connections in an application, does that count as 5 against the 25? -Thanks -Tom ...more >>

Hello, I have a problem with MSDE sp4 and MDAC 2.81 I install this files to the client machine but I can't registered sqldmo.dll with regsvr32 SQLDMO.DLL 2000.80.2039.0 SQLDMO.RLL 2000.80.2039.0 SQLRESLD.DLL 2000.80.2039.0 SQLSVC.DLL 2000.80.2039.0 SQLSVC.R...more >>

I currently run the client tools on my WinXP Pro box, and connect to multiple servers throughout the country in our organization. Each server has SQL accounts that we use to authenticate, and we do not use domain accounts. Every month when our network password changes the list of managed serve...more >>

I'm using vb.net to connect to a MSDE 2000 database on a remote server. While in VB.NET, I'm able to view data using Server Explorer. In addition, I've configured an ODBCDATAADAPTER that fills the dataset under preview data. When I tried to retrieve data through webform/datagrid I get the ...more >>

Hi all: I am new to SQL and I am having a hard time trying to figure out the following error: Msg 2812, Level 16, State 62, Server PANCHO, Line 10 Could not find stored procedure 'deletej'. My code is as follows: *****file name: jpak.sq use spjdatabase; drop procedure insertj; drop...more >>

I am writing an Active Server Page application that will get all of the databases that a user can access. Is there a way I can do this with Active Server Pages? I also will provide the users with the option to change records, table structure, etc with this application. I will also be developin...more >>

Hello Does ANSI SQL support conditional selects ? I have a table with say 15 fields tblTale1 ID F1 F2 F3 F4 F5 F6 .. .. .. F15 What I want to do is, add all the Fields from F1 to F15 and divide that total by the total number of fields which were more than 0. I know how ...more >>

How can I display filed name as a column, can any body help... There is one table name School and it contain 4 records and in the future might be it will increase but I want to display that records as a column like this 1.............. First School 2.............. Second School 3.............more >>

I'm learning aspx. I have the following code in my aspx: SqlConnection connection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Integrated Security=SSPI"); String sqlCommand = "SELECT * FROM Titles INNER JOIN MyTable ON MyTable.title_id=Titles.title_id"; SqlDataAdapter com...more >>

Hi All, I have a problem in displaying International characters in SQL Server 2000. There are a few Russian characters that are displayed as '??????' in query analyzer. i have the database setup on 2 machines. On one DB server the characters are displayed properly and on other it is shown a...more >>

I have a scanario like I want to push the data from SQL Server to dBase and dBase to SQL Server but the problem is that dBase database is on the different machine so can any body tell me before making the DTS Package what inforamtion I need ? Thanks ...more >>

I am trying to connect to different machine (SQL SERVER that is 172.131.31.211) but giving me the following error. --------------------------- SQL Server Enterprise Manager --------------------------- A connection could not be established to 172.131.31.211. Reason: Login failed for user 'sa'...more >>

I'm trying to create a database table whose primary key comes from the pubs database, titles table. The column name from the titles table is title_id. Its data type is tid. What is tid? Example: BU1032 See the pubs documentation at: http://msdn.microsoft.com/library/default.asp?url=/libra...more >>

In which cirumstances we have to use uniqueidentifier column.... like any specific conditions ? Thanks ...more >>