Hello All: I posted this in microsoft.public.sqlserver but didn't get a response. I am hoping someone here can answer this... Having some problems with the Oracle Instant Client 10.2.0.3 and SQL Server 2005. WinXP Pro on a very fast PC, 3 Gig RAM, plenty of HD space. I already got past the...more >>

Hi All, Getting the last day of the month, for the given date, by TSQL is bit tricky. Following user defined function provides you a handy general purpose function to get the last day of the month. It gets the last day of the month as follows: For example we have a given date 17-March-2007...more >>

I seem to be getting conflicting error messages from sp_addlinkedserver. Here is the problem: Exec master.dbo.sp_addlinkedserver @Server=N'SrvAlias', @Datasrc=N'ServerName\InstanceName',@srvproduct=N'SQL Server' gives me this: Msg 15426, Level 16, State 1, Procedure sp_addlinkedserve...more >>

We have SQL2000 with SP4 --an application server ri=unning windows 2003 sp1. Is anybody know what this means in the event viewer? I am not so familiar with SQL server. 1) This instance of SQL Server has been using a process id of 1724 since 6/22/2007. 2) Error: 15457, Severity: 0, State: ...more >>

Hello, Our application is running very slow, we have an application installed on (XP professional or Windows 2003) running SQL Server 2005 or SQLExpress on the same pc. We have realized that if we change "Local connections only" for "Local and remote connections", our application (VB6) runs m...more >>

SQL 2000. I was trying to move the system files, I managed to move the master, msdb, tempdb but then it died on the model. and I need to recover database... the sql service keeps failing. thank you!!! ...more >>

How can i connect to SQL server 2005 from classic ASP without trusted connection ? I have an application in classic ASP which is currently connecting to SQL server 2000. with connection string as Driver={SQL Server};Server=Servername;Database=DBNm;user id="DD"; password ="ff"; it is working ...more >>

I have an ODBC connection working for the Progress database system as tested through the use of Crystal & Access. I would really like to make a "linked table" similiar to the functionality provided from Access to the ODBC connected database. For the program I am writing I will only need to re...more >>

When trying to install sqlncli.msi on Windows XP SP2 I get the following error "The system administrator has set policies to prevent this installation" Given that I am the system administrator ... What do I need to do to resolve this ? What policies have been set ? ...more >>

My main development computer, XP Pro, (call it DEV) has 2 Ethernet adapters. Adapter A goes out to a router, and can see the world, and can see a remote SQL server (SQLREMOTE) that I have access to. I can use SQL 2000 Enterprise Manager, Query Analyzer, and SQL 2005 Management Studio to a...more >>

I Have SQL Express installed on 17 ships. Each ship has a VB6 Client application using OLEDB to connect to the database on local machine. Other workstations on network also connect - we think without error. The error above is thrown on 4 of the 17 ships. The workstations acting as the file s...more >>

When configuring SQL 2K5 on Windows XP Pro, Guest seems to be the only authentication available. Is there a service that I'm missing? I prefer to keep File Sharing available. Individual username and passwords are also required for the network. I've disabled firewall for now until I can lo...more >>

Trying to get a Vista PC to connect to the SQL Server 2005 Express on another Vista PC. The PCs do have access to each other. The PCs can access the shared folders from each other. Both PCs can ping one another. The SQL is the only item that does not allow access to. We have looked at a...more >>

Hello, First of all, excuse me for my very poor english : I just "speak" a bit of english... We recently have a problem with some PCs and ADO : we can connect our programs to databases (SqlServer 2000 or Express 2005) via ADO.Net or ODBC, but it doesn't work via ADO !? PCs are under Wind...more >>

Hi there, I have SQL 2000 and SQL 2005 Express installed on my XP Pro machine. I have VMWare running a 2003 Server session as I have something that I need to run to test the customers environment. However, I cannot connect to SQL Server 2005 from the VMWare session. I can conn...more >>

I'm using SQL Server 2005 Developer Edition on Windows XP SP2 with this setting: <add name="SqlServerTrustedConn" providerName="System.Data.SqlClient" connectionString="Data Source=localhost;Initial Catalog=GTSDB;Integrated Security=SSPI;" /> All worked great ...more >>

I am not a SQL person but was asked to work on it. The problem I am having is that I cannot connect to the SQL Server unless the old computer is running. I have transferred all the settings and files to the new computer and am able to run the sqlomgr.exe. But it will not stay active when th...more >>

Hi every body, Im using VB 2005 to create a program that open SQL Data base The problem that i want to detect the tables of a database so how can i know a data base tables instantly Thank you omar.abid@hotmail.com omar.abid2006@gmail.com Omar abid ...more >>

Is it possible to trigger a .EXE program to run on a Row insertion ... I want to run an .EXE program whenever a new row is inserted to create a directory somewhere on the server. I know that there are triggers that I can use but these seem to be to execute SQL statements ... many thanks...more >>

I have found several SQL instances with RTM in my environment. I would like to get them up to SP4. Any gotchas? Do I need to apply previous Service Packs, before I install SP4?...more >>

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Insta...more >>

Hi, During an asp.net page execution, is there a way to find number of open connecions or current query being executed? etc etc. Thanks, ...more >>

On my machine I have installed both SQL Server 2000 as SQL Server 2005. On another machine SQL Server 2000 is installed. I am able to connect to my local SQL Server 2000 Engine from within both Enterprise Manager as SSMS. Enterprise Manger also allows me to connect to the other machine, however...more >>

On my machine I have installed both SQL Server 2000 as SQL Server 2005. On another machine SQL Server 2000 is installed. I am able to connect to my local SQL Server 2000 Engine from within both Enterprise Manager as SSMS. Enterprise Manger also allows me to connect to the other machine, however...more >>

We are currently migrating our sequel 6.5 databases to sequel 2005 We have a handful of vb6 apps that connect to the current 6.5 database. Can anyone recommend the "best practice" for connecting vb6 apps to sequel 2005 databases ? Thanks in advance. ...more >>

I am using SQL server 2005 with multiple client databases with the identical structure. Is it possible to disconnect from one database and connect to another within the same ACCESS 2007 project? In Access 2007 connecting to the database through an ODBC connection (with linked tables) is slow...more >>

I am presented with... TITLE: Connect to Server ------------------------------ Cannot connect to LARRYTESTBOX\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, thi...more >>

Hi, I am trying to find the way to identify the name of the Windows NT workstation user using T-SQL in SQL Query Analyzer. Using user_name(), user, SESSION_USER, system_user, etc. gives me current SQL server login name/id; HOST_NAME(),HOST_id() shows the name of the computer not the username. ...more >>

This error has been showing up in tons of contexts in multiple report server forums. In my case, local sql mgmt studio can't connect to report server (soap error "object reference..."), but config tools can. Nothing remote can connect. Analysis, DBengine connects ok from everywhere. Can't ...more >>

I am trying to connect to Microsoft SQL Server 2005 through a program I am writing in Eclipse and am having problems getting connected. I have already created a database in Microsoft SQL Server 2005 and am trying to access that database without having to get open the server. I have also downl...more >>

In a Vb6 program i need to open a "read only" Sql Native Client Connection to a Sql2005 database. How can i do this? Is there something i can specify in the connectionstring? Actually i have found nothing. Note: i'm using SQLNCLI provider. Thanks. ...more >>

Hi, I create a webservice and impersonate a specific user only when you run a connection to sql server to insert the data. My connection string is as follows: Integrated Security=SSPI;Persist Security Info=false;Initial Catalog=cmcMail;Data Source=MASDD1;Network Library=dbmssocn;Packet Size=1...more >>

Getting "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server doesn not exist or access denied" when trying to connect to SQL 2005 SP2 from a workstation. From the SQL server itself there are no problems. The SQL server has a SQL 2005 named instance and SQL Express on it. The SQL Express is u...more >>

Is there a technical reason why Standard Edition does not support advanced SSIS features or is it a marketing decision? ...more >>