| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 BUG Posted by Lisa Pearlson at 8/13/2004 2:10:32 AM Why does this crash SQL7 with SP4 and latest MDAC?
CREATE TABLE #test (
[year] smallint,
[month] tinyint,
[product] varchar(100),
[value] money
)
GO
INSERT INTO #test VALUES (2000, 2, 'p-01', 1.00)
INSERT INTO #test VALUES (2000, 2, 'p-02', 2.00)
INSERT INTO #test VALUES (2001, 2, 'p-0...more >>
PostgreSQL Posted by Venkat at 8/11/2004 5:44:01 PM In a Union query, I have initialized one new column for sorting purpose. For
ex :
select ORD = 1 , t1.a, t1.b from table1 as t1
Union
select ORD = 0, t2.a, t2.b from table2 as t2
order by ORD.
ORD column is not present in thw table. It is used here for putting all the
rows of the second ...more >>
Convert User DSN to System DSN Posted by Yair Sageev at 8/11/2004 1:00:33 PM Hi all,
I stupidly setup a database as a userDSN but now want to make it a system
dsn so that I can access it from another machine. I have an access db that
uses msde linked tables for the back end, which is installed locally on 1
machine in the network. I want to be able to add new features...more >>
Linked server using the OLEDB for ODBC Driver Posted by Charles J Ryan at 8/11/2004 12:37:48 PM I have an ODBC driver to a non-SQL database that contains legacy data that I
need to reference in my application/reports. I had originally hoped to use a
linked server using the OLEDB for ODBC provider to access the data and so be
able to create applications/reports using data stored in SQL Se...more >>
SQLServerAgent will not start - "Event ID: 103" - URGENT HELP Posted by badri at 8/11/2004 4:49:01 AM Dear Support Team,
I had installed sqlserver 2000 with sp3 on windows 2003 server. Navision ERP
client software 3.70 installed in this server. Sql server service is running
as local system account and sql agent service is configured to run as local
system account. sql agent service is not ...more >>
Need help with DAO and SQL Server locking issue Posted by George M. at 8/10/2004 3:59:02 PM Problem: SQL Server 2000 blocking locks on Access upsized database.
Tools used: SQL Server 2000 SP3a, Access 2003, DAO 3.6
My project is to upsize an Access 2000 database to SQL Server 2000. I have
migrated the data to SQL Server, re-linked the tables, and converted the
database to Access...more >>
Problems deleting a column from SQL2000 Posted by Vi at 8/10/2004 3:25:04 PM Hello,
I'm trying to delete an existing varchar(10) column called "abc1" o in a
table on a SQL 2000 database and I'm getting the following error message in
Enterprise Manager.:
'web_cartOrders' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Lin...more >>
Memory error Posted by ven at 8/10/2004 2:17:46 PM "The instruction at 0x4174f6ff referenced memory at
0x4174f6ff. The memory could not be read" i am getting
when i am working on sq server enterprise manager...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Connect to DB2 in a stored procedure Posted by René at 8/9/2004 2:57:02 AM Hi
I read data from a db2 database on an IBM mainframe through ODBC and
transfer it to a dabase on our SQL Server. Everything is done using a DTS and
it works fine. For serveral resons I would like to implement a stored
procedure doing the same task. Does anybody know how to solve this? Speci...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |