| Groups | Blog | Home |
|
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 sp_provider_types_rowset and some other stored procedures keep being executed Posted by dragooon at 8/5/2006 5:58:31 PM sp_provider_types_rowset and some other stored procedures keep being
executed
We recently experienced a very interesting problem. When connecting to SQL
Server 2000 (SP4) using ADO, after the recordset is retrieved, we can see
the following stored procedures kept being executed every we su...more >>
How do I determine if a system is running MSDE or SQL Server? Posted by RobG at 8/4/2006 5:18:01 PM Also, how do I determine the version?...more >>
What is the difference between MSDE and a full-blown SQL install?? Posted by RobG at 8/4/2006 4:04:01 PM Do I use the SQL Server CD to install both?...more >>
MSDE user permission questions Posted by Christian.Schaeffler at 8/4/2006 12:00:00 AM Hello Newsgroup!
I got a problem concering Microsofts MSDE.
I installed it on my computer being locked in with administrative rights. I
tested the connection, created some tables...
So far, everything worked fine - but when I log in with my default account,
it is impossible to connect the d...more >>
MSDE Install rolls back Posted by Aztech at 8/2/2006 8:27:01 PM I get an MsiExec.exe error and the MSDE install rolls back after getting to
the end of the install. The actuall error that comes up is "The instruction
0x7c838bcb referenced memory at 0x0000000. The memory could not be written."...more >>
Connect with alias Posted by Rob at 8/2/2006 7:10:54 PM I have a user (client) that can not connect to a MSDE server, but can
connect to a SQL Server.
If I create an alias (on the client), and uncheck "dynamically determine
port" and specify the port number, it can connect.
I have a different user that can not connect without the alias, but...more >>
Remote connection to MSDE Posted by Krygim at 8/2/2006 11:06:32 AM I installed an MSDE in ComputerA (Server 2003) with the command:
Setup.exe SECURITYMODE=SQL SAPWD="xxxx" DISABLENETWORKPROTOCOLS=0
I tried to get access to this MSDE from ComputerB in the LAN with the
command without success:
osql -s ComputerA -U sa -P xxxx
I have tried connecting to this ...more >>
MSDE 2000 running on Win2kServer vs WinXP system? Posted by CharlesC at 8/2/2006 10:38:22 AM Hello,
Are there significant performance differences running MSDE 2000 on a Win2k
Server vs a WinXP Pro system (not server) for a small network?
Thanks,
CharlesC.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
INSERT Subquery Posted by Mica Cooper at 8/1/2006 3:44:33 PM Hi,
I need to do a subselect where clause on an INSERT and cant find an example
of syntax. Here it is:
INSERT into tblUserLocation
(intUserID,intLocationID,intAuthorityID,ysnPrimary)
VALUES (2,5,3,0)
WHERE 5 NOT IN (SELECT intLocationID FROM tblUserLocation where intUserID=2)
It gives me...more >>
Error to run MSDE on XP Posted by jmeykos at 8/1/2006 11:18:02 AM HI
I use MSDE on Windows 2000 Server without problems but to install in a XP
give de follow error:
25000:[Microsoft][ODBC SQL Server][SQL Server]Transaction
count after EXECUTE indicates that a COMMIT or ROLLBACK
TRANSACTION statment is missing. Previus count = 0, current count
=1.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |