I have two SQL Server installed on a Server. One is using default port 1433, the other is using another port 1400. Due to virus infected, may I block the port 1434 and setting the alias for the non-default port 1400 at the SQL clients? Will there be any other impact ? Thx...more >>

I have a local mdb file and remote sql server 2000 database.. i know only my remote table user name and password... my mdb file and sql database are same... I tried to link my remote database I click link table and odbc from my mdb... i choose machine data source and new ... i cho...more >>

I have SQL 2000 SP3a EE on Compaq hardware. I have all user data and system data on SAN Drives. I am noticing that even though SQL Server is set up as automatic on start up still it doesn't stat the server automatically. I have to manually start SQL Server service after the machine is booted u...more >>

I have quite a few queries that I have written using Excel and MS query. I basically connect to an outside ORACLE 8i database and retrieve data for analysis using Excel tools. I have been very succesful using this method, but for some reason I am no longer able to 'Edit my queries' I can refr...more >>

We have a web service that accesses an SQLServer database. The database has hundreds of thousands of rows. We open a cursor in order to allow the user to page through output, but processing takes too long and the cursor consumes too much memory. I understand how to limit the return set by us...more >>

I am hoping this is the right place to post... I am trying to find out some information on .NET over wireless. Currently I have an application that makes sql querries to a sql database. The application works fine over a wired connection, how ever when taking the application wireless it ti...more >>

While we update our datawarehouse we don't want the users to be able to connect to the database and update their reports. So we want to block access during certain hours. What is the best way fix this? The users use a SqlServer login with permission to read data....more >>

Good day In my application ADO Connection’s Open() method is used to open connection to SQL Server. Using profiler I see the following for Audit Login event: -- network protocol: TCP/IP set quoted_identifier on set implicit_transactions off set cursor_close_on_commit off set ansi_warni...more >>

Hi, We have our SQL Server 2000 Ent. Ed. SP3 set up to use Windows authentication from a Windows Server 2003 domain controller running Active Directory in Windows 2000 compatibility mode. From the office, everything is hunky-dory. However, we have many employees that need to connect to th...more >>

I get the following error after trying to do update to an Oracle 9i table from SQL Server 2000. : The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction. Any ideas to solve this? ...more >>

Experts Please reply I am developing MDI parent with multiple child forms. All the child form would have only database records. So I need SQL Connection to connect the SQL Server 2000. Which is the best procedure to connect the database. Either connecting the SQL Server while starting the ...more >>

Is there anyway of connecting to a remote SQL Server other than via a VPN. The remote SQL Server has a connection to the internet via a firewall which has a static public IP Address. Thanks LC...more >>

for the past few days, SQL Server 2000 ( 8.0.0.936 ) has been using aup all the threads in the database. During the night when web traffic slows it releases some but not all of the threads. What causes SQL to keep grabbing threads at an alamring rate, then never release them? What ca...more >>

I need some help. I have to connect from external network to MSSQL server. There is no problem to conect to first (main) instance of SQL (just forwarded port 1433 on firewall). But another instance is using port 1033 to exchange data (I am guessing). I am trying to connect via MS ACCESS. Ho...more >>