|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Cannot Connect to MS SQL 2000 server Posted by Biju at 9/28/2003 10:07:22 PM Hello:
We are using MS SQL 2000 server on one of our
sites. We are unable to access the databases folder in
the server. After connecting to the server through
Enterprise Manager and clicking on the databases folder,
the server does not responds for long and later hangs. As
mentioned by...more >>
SA Trusted connection fail after critical update Posted by greg at 9/28/2003 7:36:38 PM Hi All, I had posted this is security, but this looks
like the right group for this.
I just put the blaster patches on our SQL servers
and now all kinds of problems have appeared.
When trying to connect as SA using Enterprise Admin, the
error appears
Reason: Not associated with a ...more >>
SQL Server 2000 ID Number Posted by VideoSmeden at 9/27/2003 9:17:00 PM Hi
Please help me URGENT
How do i make an tableField with a
Auto-Incr, the same like in an access DB where it's
called AutoNumber
Thanx in advance
__________________________________________________________________ Flemming
Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact m...more >>
MSDE is Running but Not Listening!? Posted by Eric Robinson at 9/27/2003 12:40:09 AM The MSDE SP3 installation went fine. Service is running, but not TCP socket is
listening on 1433, The log says SQL is listening on shared memory. What did I
do wrong?
--Eric...more >>
dangerous bug in sql 2000 Posted by Pete Gajria at 9/26/2003 3:07:03 PM Hi,
looks like sql server 2000 (no sp) can't distinguish between
2 rows with timestamps less than 3ms apart
in other words if you query a bunch of rows with a date > expression in the
where
clause in a select statement it will actually drop rows
heres an example
select top 5 id, modi...more >>
Editbin.exe Posted by bruce at 9/26/2003 11:07:30 AM Hi,
Does anyone have or know where I can get or download this
program. Thanks!...more >>
SQL Mail problem Posted by Naz at 9/26/2003 9:36:03 AM My sql Mail is properly configured. Every time i use
xp_sendmail , the result set confirms that mail is
sent.When i check my outlook, nothing shows up.
When i go to enterprise Man->SQL server agent->jobs->right
click->properties->Notifications-> assign any one of the
operators to be noti...more >>
"Inconsistent Metadata" error - Oracle OLE DB provider Posted by gdean NO[at]SPAM gadean.com at 9/26/2003 9:35:43 AM I'm connecting an Oracle linked server using the Oracle Ole DB
Provider (the Microsoft driver is trashing my Multibyte characters).
Any select query returns an error about "inconsistent metadata". A
search of this group indicates that others have seen the same problem,
but none of the threads re...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Detect SQL Server name from VB Posted by Hiran Coello at 9/26/2003 8:56:41 AM I need to be able to detect the name of all sql server
that are on the network...more >>
Cannot connect to instance from outside Posted by Mark Aslan Kuschel at 9/25/2003 6:42:11 PM Hello NG,
I have a problem with my SQL Server running on Windows Server 2003.
It is impossible to connect to that server from outside (that means from
another computer over internet). When I try it with oSQL I get: SQL Server
does not exist or access denied.
Local connections to the SQL Serve...more >>
Why would "(local)" stop working? Posted by JJ at 9/25/2003 3:03:12 PM I have an end user with SQL Server 7 and it has been working fine. Apps
connect to it through ODBC, including on the system running SQL Server.
They installed some address book program on the system running SQL Server
and after that, the ODBC data source could not connect to the server (on the...more >>
FTP Upload Posted by JAB at 9/25/2003 1:49:06 PM Hello, I was to be able to upload a file on to an FTP Site from SQL Server.
I know that there is a DTS Task that can download files/file from and FTP
site and this is not what I want to do. Instead, I want to be able to
transfer a file on to an FTP Site (more or less Uploading not downloading).
...more >>
The RPC server is unavailable Posted by Randy Seedle at 9/24/2003 9:42:15 PM Anybody seen this messege when using SQL Server
Enterprise Manager ?
An error 1722 - (The RPC server is unavailable) occurred
while performing this service operation on the
MSSQLSERVER service.
...more >>
Enterprise Manager and Query Analyzer Posted by charles_j_smith NO[at]SPAM yahoo.com at 9/23/2003 8:31:09 PM All,
I am trying to connect to a sql server (2000) across the internet
using Enterprise Manager (no vpn, no dial in,etc.) - strictly across
the internet. Now, I use the Query Analyzer tool to connect and it
works, I can access the server just fine. When attempting to do the
same within Enter...more >>
ODBC connection strings Posted by stephen excell at 9/23/2003 7:52:47 PM We have a prototyped access front end with linked ODBC
tables when we push out the front end to clients machines
so that they can run it locally the WSID in the ODBC
connection string refers to the developers PC. How do you
change this so it refers to the clients PC. Unlinking and
relinkin...more >>
SQL-DMO SQLServer.Start and Instances problem Posted by Paul Buxton at 9/23/2003 5:38:00 PM Hi all,
I have a SQLServer or MSDE Instance called X, which I am trying to start
through SQL-DMO.
I've noticed a difference between the OS's
Using the following......
set o=CreateObject("SQLDMO.SQLServer")
o.Start 0, "(local)\X"
This only works on Win98/ME machines!
To start an...more >>
Different passwords on 'sa' for different servers Posted by Ethan Stinar at 9/23/2003 4:17:10 PM To make this short, I'll ask the questions first and outline the problem
further on:
Can I run two different instances of MS SQL Server on the same physical
machine using **two different** passwords for the sa account in each
instance?
If so, can I access both servers with Enterprise Mana...more >>
SQL Server Alias Posted by Steve Roszko at 9/23/2003 3:05:30 PM We are creating an offline version of all of our web apps and SQL server
databases for a fully disconnected training / demo session.
IIS 5 Web Server Hosting Multiple Websites -> Copied to laptop server
4 Separate SQL Server Database Servers -> Copied to laptop server
All to be copied to...more >>
server does not exist or access denied Posted by Ray at 9/23/2003 1:48:56 PM I use Enterprise Manager and IP addresses to connect to
several Sql Servers in another city. When I have a
project on a particular DB I am given a SQL Login for that
DB and away I go. I recently got a project on a new
server (Windows 2003) and couldnt register it. I have EM
as result of...more >>
are these groups still moderated? Posted by Andy Svendsen at 9/23/2003 10:09:15 AM It is bad enough that my email address got harvested for the fake Microsoft
IE 4.01 product alert email that has a virus attachment as a security patch.
But I think the posts should be more closely censored as you can see from
some of the posts in this newsgroup.
--
***********************...more >>
SQL Mail Problems Posted by Bill Mell at 9/23/2003 10:04:47 AM Server OS: W2k sp2 + security patches.
SQL Server 2000 sp3
Mail Server OS: W2k sp2+security patches
Microsoft Exchange 5.5
Steps I have taken:
1. Created a Domain User with Admin Rights for the SQLServerAgent Account
2. Added that user to the Machine Admin group on the SQL Server
3. Logged ...more >>
SQL Server Network Connection Problem Posted by Mike at 9/22/2003 1:13:16 PM I have SQL Server installed on my PC along with an App
that connects to it and manipulates various tables, etc.
For this app, I do not utilize any network connections
and only access my own local database. Also, I use an
ODBC connection for connecting to the Database on my PC.
The problem...more >>
User Connectivity Posted by Mary at 9/22/2003 12:44:33 PM Applied security update 815495 (cumulative patch for SQL
Server) and MDAC 2.8 on Windows NT 4.0 Server SP6a with
SQL Server 7.0 SP4 installed, and users cannot connect to
database.
Attempted to rollback security updates with no luck.
Troubleshooting steps?...more >>
exporting sql resultset to excel sheet Posted by Nikhil Verma at 9/22/2003 9:43:31 AM Hi,
Is there a method to export sql resultset to excel sheet?
Thanks.
...more >>
ASP trusted_connection? Posted by jwillems NO[at]SPAM xs4all.nl at 9/22/2003 6:42:23 AM Hello,
I've installed a local version of SQL server personal Edtion on a
Windows 98 PC and IIS on a Windows 2000 server.
Under IIS a virtual map points to a directory on the 200 machine. In
this map I created an asp page that points to SQL Server on the 98
machine.
A simple html page with no...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |