I only have basic SQL knowledge and am trying to modify some previously
created views, the problem I have is the views were originally only accessing
tables on the local SQL 2000 server which was fine, but now one of the
databases has been moved to another server and I'm trying ...

I,ve tried to manage an SQL Server (MSDE) with Enterprise Manager.
The Server was successfully registered.
But when I try to show the servers properties, or to insert a new login
there is always the following error:

I am getting and error message and need some help.
The message is
Unable to attach to SQL Server SQLSERVER as PSI. The server
maybe down or improperly configured.

I would like to know if there is any no. of SQL limit
within a transaction.

Here's my dilemna:
I have an SQL 2000 server. We have about 10 people that connect to it using Enterprise Manager. Here's what we do: we register the SQL server using an sa account, no problem. The problem that we face is that we can view all the "options" (the management, ...

I am using ADO, VB6 and MS SQL Server 2000
Why is it that when I run this statement I get the wrong date format and
date
sSQL = "UPDATE tbl_MyTable SET tbl_BTP_Scenario.UpdateDate =  " & Date()

Hi, I'm trying to connect to MS SQL server using PHP Pear DB package. I
have 2 SQL server running on different machine. 1 is using SQL Server
2000 Standard Edition and the other is SQL server from .NET SDK.
I can connect to the standard edition but not to SQL Server from .net

Friends,
I am trying to run the following CREATE TRIGGER SQL
statement. I keep getting a Syntax Error from SQL Server
(near key word 'select' (line 11) and near '=' (line 13).

I have a concern, Well I wan't to connect to a sql-server,
without having the UserID and Password. But the server
exists in the same domain. The problem is that, the server
to which I connect, can change the IP Address and I may

I am running SQL 2000 sp3. I am getting an error in the
log files that states the SQL server "can not bind to
TCP: port 1433"
I can not find much info on this other than what is in

I have local sql server database on my server
I have also another sql database on my internet
I would like to transfare data from my local server to the internet server
at 12:00 pm every day

My win 2000 server is connected with MS SQL server 2000
There are around 10 applications on this server. Some webpage will be
refereshed itself within 20 seconds to retrieve update data in sql server
This server run 2 years till now.

The same problem existed with WMP:9 and TabletPC-SP1
I updated to
SP2-Tablet PC2005 on TC1000 and Installed WMP:10
When I try to search media files it just sits there, Ive tested local/my

I tried to manually start a job from Enterprise
Manager and got
' Error 22022: Unable to post notification to SQL
ServerAgent (reason: MapViewOfFile() returned error

I am writing an application that calls numbers of stored procedure wrapped in
an ADO.NET transaction. Some of the stored procedure implements T-SQL
transactions.
Is it safe to call Stored Procedure like this or there is potential of data