|
|
|
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 Linked server connection intermittent Posted by jddotman at 1/14/2005 2:11:03 PM I have some SQL server jobs that connect to a linked DB2 on an AS400 and
fetches some data and inserts into SQL server. The AS400 is set up as a
linked server. The jobs fail at times and work at others. The error message
I get when trying to look at the tables through Enterprise manager is
...more >>
Enterprise Manager Server Registration General Network Error Posted by Scott Begin at 1/14/2005 1:29:58 PM I'm having problems Registering servers in Enterrpise Manager.
This problem is workstation specific.
Workstation is XP Pro SP1, in an Active Directory domain. Only protocol in
machine is TCP/IP.
I have 4 machines with identical hardware ghosted from one source image and
all have t...more >>
Problems Backing up database to a PC with 200GB drive Posted by Gordon at 1/13/2005 2:43:01 PM SQL Server 2000 on Windows 2000.
Is this possible. I try to create a new backup device and the only thing I
can locate is the local partitioned drives. I try to put in a UNC and it
does not work.
Is this not possible to put in a UNC to a shared drive on a PC. The backup
is needed ...more >>
SuperSocket Info: Bind failed on TCP port 1433 Posted by Geoff Swihart at 1/12/2005 4:17:18 PM Receive this error when starting SQL: SuperSocket Info: Bind Failed on TCP
port 1433
SQL Error Log:
2005-01-12 16:01:35.78 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-01-12 16:01:35.81 server SuperSocket Info: Bind failed on TCP port
1433.
2005-01-12 16:01:35.82 server ...more >>
Server query processed at local and not remote SQL Server Posted by DaveA at 1/11/2005 6:47:03 PM Hi, I have a client who is conneting to my server from theirs via a linked
server they've set up.
They perform the following query:
DECLARE @abcid int
SET @abcid = 123
SELECT abc_id
FROM [Server1\NamedInstance1].DB01.dbo.View01
WHERE (abc_id = @abcid)
The execution plan in Qu. An...more >>
Software for connecting to a remote SQL Server Posted by Joshua Beall at 1/11/2005 6:45:52 PM Hi All,
I would like to be able to connect to a remote SQL Server and fire arbitrary
queries, browse tables, and so forth. Very much like MS's "SQL Server Web
Data Administrator" (link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylan...more >>
Connection limits to database by operating system Posted by Gloria at 1/11/2005 6:33:07 AM Can someone point me to documentation related to the number of connections a
database can have before there is a degradation in the connection?
I was told that if you have a database on a computer with a Windows 2000
operating system you can only have 5 connections to the database or the
co...more >>
Can not connect to SQL from Client VB UI Posted by TOM at 1/10/2005 12:43:03 PM The error message that i get is: PROVIDER CANNOT BE
FOUND. IT MAY NOT BE PROPERLY INSTALLED.
When i run the same connection from the server to the
application installed on the server it works fine.
Any ideas would be helpful
Thanks
Tom...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Distributed Query Connection Issues Posted by Konstantin at 1/10/2005 10:55:01 AM I have the following situation: I have a database on ServerA and a database
on ServerB. My client app connects to ServerA and uses a stored procedure to
retrieve a dataset from both ServerA and ServerB.
While developing the app (using SQL 2K Dev on my workstation), I used a
linked server a...more >>
XP / SQL personal: Cannot find localhost Posted by Stephane at 1/10/2005 8:59:01 AM Hi,
I installed SQL Server 2000 personal edition on my Win XP sp2. In the
enterprise manager, I can manage my local database, but if I try to connect
via the Query analyzer, it says it cannot find the server or the access is
denied.
I added localhost in the Client network utilities and ...more >>
Change default port no. Posted by Rajendra at 1/10/2005 1:21:02 AM Hi,
As we know,SQL server listens on port 1433 by default. Is there any
dependency between client and SQL server for this port number?I mean, how
will know the client that on which port the target SQL server listens?
Suppose I change this port number to 1533 and restarted the SQL server.No...more >>
how to SQL Server register? Posted by sumathra nagarajan at 1/9/2005 11:09:02 PM my SQL Server version is 2000
How to register New Sql Server with local machine?
and how to connect?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
Connect across Internet through NAT router Posted by Bill Todd at 1/9/2005 12:33:56 PM I am attempting to use Enterprise Manager to connect to SS 2000 across the
Internet. The machine running SQL Server is behind a NAT router.
Enterprise manager shows that the TCP/IP port that SQL Server is using is
1061. I have forwared port 1061 on the router to the machine running SQL
Serv...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |