Could you please explain what is the difference between Linked server and remote server .. I wanna remove all the remote server from my Server, how can I do ? Any commands regarding this ... Thanks in advance Noor ...more >>

We want to install SQL Server on a windows 2000 PC. i was told there is a sql server enabler that can be installed on the 2000 pc so SQKL server can be installed. Is this correct? anmy idea on the cost? ...more >>

Hi all, I can aggree that its not possible to install sql server 2000 in win 2k3 web edition server. But it should allow me to install atleast the sql client on it. Is there anybody who knows about it? or how to trick the installation to install only the client thanks shiv...more >>

I have created the linked server.. the query are as follows EXEC sp_addlinkedserver @server='192.168.0.13', @srvproduct='sqlserver', @provider='MSDAORA', @datasrc='dataserver' EXEC sp_addlinkedsrvlogin '192.168.0.13','false','sa','sa','ngsol' it ...more >>

Can any body tell me that how can I replicate the DDL commands into Subscriber ? Waiting for your reply Noor ...more >>

Dear All I am carrying out a bulk insert from a csv file into a SQL Server table using the 'Bulk insert' statement within a stored procedure. This operation works okay whenever I manually run this sp on the server. However it generates the error message shown below whenever I call this sp ...more >>

Hi! Is it possible to have a log an a mssql client?...more >>

Hello! I have had a web-based application running on a server for about a year and a half. We had no problems whatsoeverwith the app. It is simply retrieving data from the database and displaying them on the screen. Recently my hosting provider upgraded to Windows 2003. We have been pulling our hair...more >>

Hi all there After installing my SQL Server 2000 on a pysical server, I wanted to test a first connection from my desktop pc (connected to the server), using MS Access 2003 as the front-end. I am not able to connect to the sql server, since I get message "access denied or no sql server exis...more >>

I am trying to execute a stored procedure thru the Object Browser and the DEBUG process doesn't work. I have tried it on other PC's and it works. Not sure what I have done to disable on this PC. Any help will greatly be appreciated. Thanks! Phill ...more >>

Dear Professional, I wanna know all the query which has executed by specific user, like i have a user name "noor" and I wanna know that from yesterday noor has executed which queries and I don't wanna use Profiler, any help in this regard ? Waiting for your reply ! Noor ...more >>

Hi, I am running 7.0 SQL Server database. Can I install and use the 2000 Client against this server? Are there any data corruption issues with this?. thanks gtriarhos@kingschools.com ...more >>

Need help with Sql access. I have an Office 2000 access project front end to an sql database. I normally use win98 with the sql connectivity client and have no problems. I upgraded to xp and got the error "no such interface supported". I have office 2000 installed with all the latest p...more >>

I need to obtain the hotfix in kb 830767 as I am having quite a bit of trouble with Query Analyzer hanging. Doug Heeren ...more >>

Hi, I have developed some cubes on my local machine with SQL analysis server. Now I want to take them offline and send them to the client to see them. I read on the miscrosoft website that I can do that through client services, but I don't know how to install that and how to work wi...more >>

Hello, we have a problem on one of our SQL servers. When I execute the ISQL command on SERVER1 ISQL -S SERVER2-E -Q"select @@servername" it returns not SERVER2, but SERVER3, the name of yet another SQL server on our network!!! How on earth is this happening? The IP addresses of all S...more >>

Hello -- We have a SQL Server 2000 machine that has approximately 500 user databases. Don't ask why -- I did not create this mess. Anyway, we have about 200 users access the SQL Server as a DSS machine using SA. We've finally weaned all users off of SA and each have their on ID per custo...more >>

Using Secure Remote VPN from Checkpoint, on Windows XP Client. Trying to create ODBC connection to SQL 2000, on Windows 2000 server. Kerberos Key Distribution service is disable on SQL Server. I Can create ODBC connection using SQL Authentication, but not NT Authentication. Error message is "Cann...more >>

We have had issues with letting users put thier notebooks into sleep / hibernate mode with MSSQL server service running. Is this a known issue? Thanks....more >>

Are there any SQL-DMO .NET native version available for download? Does Microsoft provides it for development?...more >>

Dear Professional I have one question regarding the Return 0 or Return 1 like I have the following procedure. CREATE PROCEDURE [dbo].[AspUpdateVPersonnelLogin] ( @VPEL_VPersonnelID INT, @VPEL_LoginName NVARCHAR(20), @VPEL_LoginPassword NVARCHAR(20)=NUL...more >>

Hi there, I'm looking for a quick way to setup/deploy an SQL alias on multiple clients? Due to an hw upgrade, we are moving our cluster to a new server, and we need to setup on multiple clients a new SQL Client Alias and an ODBC System DSN. I found that Sql Client Alias configuration are st...more >>

Hi After using a sql database, I want to detach it . But some connection are still openned from the application. My question: How can I stop those connections ? ...more >>

I have two subnet on my company. The connection is a 256K Lease line. Subnet A cannot use the enterprise manger (and other SQL tool) to connect the SQL server in subnet B. And got a "SQL Server Does Not Exist or Access Denied" message. But in Subnet B, I could contact all SQL server in Subnect A...more >>

How do you recover from a condition where you begin a transaction, then modify half of the data you want to. Then somehow the connection to the database is broken such as an ethernet wire is unplugged. I am working on a "shaky" ethernet. I am connected across to a different machine. The et...more >>

Hi, I am getting this message "An invalid argument was encountered" when run my application(using ODBC connection) from Windows 2003 server, but its working fine when I use XP, or Windows 2000 Prof. Any Idea about this problem? Thanks...more >>

I have one move.bat file and I wanna execute it through sql server 2000. xp_cmdshell 'c:\move.bat' (not executing the file) how ? waiting for your reply Noor ...more >>

hi all Is there any way to identifiy Identity field's value within query? Farhan Iqbal ...more >>

i have a stored proc that contains a single select stmnt. the proc runs quickly enough most of the time (2 seconds). but it seems when the proc is called for the first time in a while, it takes significantly longer (10-15 seconds) to finish. is the improvement in speed on subsequent calls to t...more >>

for some reason SQL ent manager has stopped working on my server. SQL is up anmd running but I cannot get ent manager to work, I get the following error: MMC cannot open the file c:\program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC This may be because the fi...more >>

for some reason SQL ent manager has stopped working on my server. SQL is up anmd running but I cannot get ent manager to work, I get the following error: MMC cannot open the file c:\program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC This may be because the fi...more >>

Dear Professionals I have two colums in one table like FirstName, LastName and there are three rows in it. Steve, Rodger Khan, Fundas Brow, Fan I don't wanna alter the table ! when I wanna select the table so the record should disply like this.. means i wanna use sequence... 1,2,3.......more >>

SQL Server 2000 will not start. In the ERROR LOG file it states that the database model is undergoing a restore. Is there a way to stop the restore and start the SQL server ??? Here is the error log file: 2003-12-09 12:35:20.94 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 1...more >>

I am having issues connecting to a SQL server using XPs managed passwords. Here is the configuration: SQL 2000 server/Windows 2000 Cluster located behind a fire wall in a DMZ. SQL is installed on virtual server FOO with instance name BAR in domain FLUF. XP client is installed in domain FUZZ. ...more >>

we are writting a database application (currently) connecting to 3 database including Microsofty's SQL Server. we wonder if we could use the Microsoft's SQL Server logo in our documentation diagram to represent SqlServer. the guideline are not very clear and look much like you have to pay to p...more >>

i have a problem with MSSQL, my datatype is smalldatetime. when i open enterprise manager i can see the date display is 12/8/2003 = 6:14:00 PM. But when i want to retrieve that time cannot, it only = allowed me to retreived if my sql statement is select * from tbluserid = where TDateTime =3D '12...more >>

Dear Professional..... Can any body tell me the list of prometric centre in Pakistan. From where I can find out the list of that. Waiting for your repl Noor ...more >>

The 2 Machine having the problems are Win2k Workstation=20 SP4. SQL Server is another machine on Win2k Server SP4. =20 Both the Clients and Server software has been upgraded to=20 SQL SP3a Thanks ... Stephane >-----Original Message----- >One previous post indicated the issue was rel...more >>

After an inadvertant ip address change on a server running SQL Server 2000, I am unable to re-establish a connection to the instance of SQL Server over the network via Enterprise Manager. I am also unable to see other SQL Servers on the network from the Enterprise Manager on the server it...more >>

We have a situation where we are log shipping from the prod server to a report server every 15 minutes. However, as the logs are being applied to the report server DB, the DB is not available for a brief period of time. Most of the time it is just a few seconds, but it has taken up to 2 mi...more >>

Will be setting up a SQL Server DB that could potentially have 400-800 users off of 50-80 PCs. What are my licensing options for the client PCs? Can I do an ODBC connection at the clients or do I need a CAL for every client PC....more >>

Can I using the sql 6.5 client software, talk to a sql 7.0 database on another machine? Should be upward compatible, right? Please respond to william.carew@honeywell.com bill...more >>

DEV ENVIRONMENT: .NET and some COM DATABASE: SQL Server 2000 CLIENT OS: Win2K, WinXP SERVER OS: Win2K3 Greetings, I have a client who insists on having their customers in separate SQL databases for an online component. I instinctively feel that a consolidated database for all clients is ...more >>

does the sql server 7 desktop edition does not have the attach file option at all.. i donot know how to start it/.. help plz.. thanx mpax ...more >>

Hello, all: We recently reconfigured our Win2K/SQL Server to act as a domain server, and now the SQL Enterprise Manager in client PCs cannot connect to the server, unless Windows explorer is used first to navigate to the server. We have mixed authentication in SQL Server, and the clients do no...more >>

How can I have SQL 2000 client automatically install itself from a windows 2000 sever? thanks...more >>

Hi, I am using a connection to the database with the following: Try Dim conBO As New SqlConnection(Me.strConnect) Dim cmd As New SqlCommand(GetSQLString, conBO) cmd.CommandTimeout = 120 '-- 2 minutes conBO.Open() Dim rdrBO As SqlDataReader = cmd.ExecuteReader(CommandBehavior.Cl...more >>

I am having a problem with a simple delete, I can replicate the problem but have yet to find a viable solution: table xyz has roughly 40000 rows Foreign Key (it is the primary) to several (empty tables) can issue a delete from xyz with completin in 10-15 seconds UNTIL the case where the delet...more >>

Dear sir I have tried installing the SQL Server 2000 Client drivers on a client PC running NT (SP6) and win98, the install (for connectivity only - local pc) goes right through to the copying of the files. This is where it fails giving the following error message: Installation of the ...more >>

I need the service to start without user intervention with the following switches: scm -Action 1 -Service MSSQL$SQLDB -Server TESTBED I cannot simply place SCM.exe in the startup folder that is not going to work. ...more >>