|
|
|
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 |
SQL 2005 Linked Table in MS Access returns #Deleted Posted by Nate Scott at 8/29/2007 12:54:04 PM Using Microsoft Access (2003 and 2007) to link to tables on a SQL 2005 SP2
server is working most of the time. On some particular tables (MS Dynamics
AX database) the results of the linked table for all rows and columns is
#Deleted. It has the correct record count and importing the data or u...more >>
SQL Server To Paradox Posted by Brian at 8/27/2007 3:52:03 PM
Hello,
Is there anyone out there that has been able to successfully have SQL Server
2000 talk to Paradox databases, by using an ODBC Driver between SQL Server
2000 and the Borland Database Engine v 5.
We have been working with the Microsoft Paradox driver, with very poor
results. We h...more >>
uncommitted Transactions in Transaction Log Posted by Veeru at 8/23/2007 10:54:02 PM Hi
My Application sends huge huge data to the SQL Server, when initially it
sends the data, it inserts all the records into the tables, when the data
comes next for the same records it needs to be updated.
In Sql Server autogrow is enables.
After some time Transaction Log growed and fina...more >>
DSN and the Commandline Posted by John at 8/23/2007 1:57:05 PM All,
I have looked and not found anything on this. Is it possible to setup a DSN
through the commandline, or a startup script?
Thanks,
John
...more >>
SQL Server VARCHAR(MAX) column Returns error while Inserting recor Posted by Ravi at 8/22/2007 3:34:01 PM
SQL Server VARCHAR(MAX) column Returns error while Inserting records into
table(ODBC Driver: SQL Native Client)
Was this post helpful ?
I created very simple table with 3 columns and one is varchar(max) datatype
When i insert records thru VC++ ADO code i am getting this err...more >>
doubt in sqlserver 2000 Posted by erslmn NO[at]SPAM gmail.com at 8/17/2007 2:31:31 AM how to load csv files into a table in sql server 2000
...more >>
The dreaded Microsoft OLE DB Provider for SQL Server -2147217871 Timeout expired Posted by andrewbassitt NO[at]SPAM gmail.com at 8/15/2007 1:03:09 AM Hi,
I've recently started experiencing an error in one of our development
environments whereby the user is pressing "submit" and their query is
timing out. Now, i've ran a trace (using the SQLProfilerTSQL_REPLAY
template in SQL Profiler) while they were performing this process, and
attempted...more >>
How much more disk-space requires to upgrade the MSSQL 2000 to 200 Posted by Jodie at 8/14/2007 10:06:02 AM Hi All,
I had MSSQL 2000 and I would like to upgrade this server to MSSQL 2005 and I
were wordering how much more disk space requires for the upgrade process.
Is there any document that I need to read before upgrade process to upgrade
the server from MSSQL 2000 to 2005...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Query Get Data a Month Old Posted by Gabe Matteson at 8/7/2007 4:10:27 PM Does this part of the query look correct? It's formated so that it doesn't
use the time feature and zero's it out to midnight...
where datecreated between
DATEADD(m,-1,CAST(CONVERT(CHAR(10),GETDATE(),120)as DATETIME)) and GETDATE()
order by datecreated
how would i create a query that ret...more >>
Missing Records in Linked Table Posted by Neil at 8/6/2007 8:17:20 PM I'm running Access 2000 with a SQL 7 back end, using ODBC linked tables in
an MDB file. The db is used by about 30 users on a LAN, and an additional 10
or so on a WAN.
Recently, one of the WAN users complained of intermittently not being able
to find certain customers in the customers table...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |