|
|
|
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 SQL 2000 Server Enterprise Edition Compatible with W2k Server Posted by Stephanie Ong at 7/14/2003 9:13:52 PM Dear all,
Can i install the SQL 2000 Server Enterprise Edtion
into W2k Server Standard edition?
Please advise. Thanks
Regards,
Stephanie Onf...more >>
Server: Msg 7344, Level 16 (Linked Servers) Posted by R10 at 7/14/2003 1:03:13 PM -- I connect to server with:
exec sp_addlinkedserver '172.30.170.16'
go
exec sp_addlinkedsrvlogin '172.30.170.16', 'false',
NULL, 'sa', 'password'
-- Select statments like below work fine:
select * from [172.30.170.16].db_dibrs.dbo.rmt_db_table
-- HOWEVER, the following statements generate e...more >>
Connect using OLEDB Posted by Craig Hudson-Bennett at 7/14/2003 10:17:10 AM I would like to connect to SQL Server from Access using OLEDB. So,
setting up a ODBC data source. Does anyone have any code for that ?
Thanks, Craig
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
Run Time error [Microsoft][ODBC SQL Server Driver][TCP] Posted by Max at 7/14/2003 9:11:02 AM I am running an application that is running on the default
instance of a SQL server.
Users work on the application fine, but sometimes receive
the following error. I contacted the software company for
the application and they argue that it is a server issue.
The error is as follows:
...more >>
Linked Server vs. Linked Tables Posted by Michael at 7/14/2003 8:19:28 AM Hi,
instead of a pure linked server connection (which I have
set up successfully already), I would need the
functionality of liked tables (i.e. being able to access
tables in regular, not 4-part syntax and get the access
re-routed to the linked server).
Is there any way of setting up t...more >>
SQL Service Port 1433 Posted by Christo Oosthuizen at 7/14/2003 8:13:34 AM Hello,
I am having very strange behaviour from a SQL 2000 Box. We
installed the box and it appeared to be working fine for
some time. Recently it started giving problems for port
1433. SQL Server is started. If I telnet into port 1433 of
the SQL box, it answers, but when I do several
co...more >>
SQL Server Linked Table/Precision Problem Posted by S. Spencer at 7/14/2003 6:34:49 AM When I run the following query:
SELECT A.EMPLID, A.NAME, (CONVERT(CHAR
(10),A.PAY_END_DT,121)), A.DEPTID, A.ACCT_CD, A.DED_CUR,
A.EARNINGS, A.TAX_CUR, A.ACCOUNTING_PERIOD, A.FISCAL_YEAR
FROM PS_NSCC_PAY_DIST_V A
WHERE A.FISCAL_YEAR = :1
AND A.ACCOUNTING_PERIOD = :2
I Get the follo...more >>
Problem after install SQL Posted by gtr7 at 7/14/2003 1:37:03 AM
I have a problem after I install SQL and netSDK examples, I have problem
with my internet connection.
after instsalling the SQL I run my computer for about 30 mins to 1hr
the internet connection will go down, and after I restart my computer I
get connection againm but for about 30mins and 1hrs...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problems reconnecting to recovered db Posted by A_X_L_X at 7/12/2003 10:17:17 PM Hi,
I am having problems connecting to a recovered database.
I recovered .mdf file from failed harddrive. Put file on a new machine, used
"Attach Database" wizard, and am able to see it, run queries, etc. (as dbo,
sa). All tables and stored procedures in the database are owned by a user
(le...more >>
User Permissions in SQL Server 2000 Posted by Anthony Tanzola at 7/10/2003 8:43:23 AM Hey List!
I have a question regarding user permissions. When setting up a user to
have access to a database on SQL Server 2000 I am able to deny him
access to other databases on the server.
Although the user does not have the ability to access other databases,
the databases are still v...more >>
Transact SQL Connect to external database Posted by Bob Acker at 7/8/2003 9:48:02 PM I would like to run a stored proc in a local database and
do a select into a local table from a remote database.
I know the tcpip address of the remote server, and have a
login and password.
How can I connect to the remote database, do the select
and log off from within the local stored ...more >>
Login to SQL Server Failed Posted by Russell McCurry at 7/8/2003 2:40:22 PM This is the error:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'et'. Reason: Not associated with a
trusted SQL Server connection.
However, the thing is, I dunno why it is getting that. I
have created the 'et' user and it utilizes the SQL
Authentication to g...more >>
Error: Cannot Generate SSPI Context - to connect SQL2000 Posted by Claudete at 7/8/2003 1:08:15 PM Hi,
I have had a problem with an user trusted (DOMAIN\USER).
This user tries to connect to SQL2000 SP3 by a drive ODBC=20
for example and this message appears. This problem not=20
happen when used named pipes, but is too slow.
There are many users, but only one user has the problem.=20
The...more >>
SQL Traffic - Ports Posted by Vik Evans at 7/8/2003 12:44:27 PM Would like some references to read about the ports in use
for SQL traffic and Crystal Report queries to an SQL server.
We have a client who's SQL access may move from the local
LAN to a WAN access method and I need to determine how much
bandwidth it could take.
Much appreciation in advance
...more >>
MS Server 2003 and SQL 7 Posted by John Smith at 7/8/2003 8:54:29 AM Quick question:
I have a Server 2003 box that I need's an ODBC connection to a NT 4 Server
box with SQL 7 on it for old legacy home grown apps. When I try to setup
the connection on the 2003 box, after selecting the SQL Server driver, it
only shows our SQL 2000 boxes and none of the SQL 7 box...more >>
transfer data Posted by xiaowei at 7/8/2003 8:19:34 AM We have a windows 2003 standard edition server that we
use as a web server.We also install SQL server on it.
We want to transfer the data in SQL server databases to
our internal MS Access database(or synchronize the
database)on a daily basis.
The problem is our internal network is netwa...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |