|
|
|
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 how to display 10 rows at a time when 1000's returned form sql query Posted by Daniel at 6/7/2006 10:15:23 PM how to display 10 rows at a time when 1000's returned form sql query
how to select the 20th-30th row in a where clause? e.g. select the 20th to
30th employee who name is 'bob' in tsql. i need this because my select often
returns 1000s of rows and i want to display them in pages of 10 at a tim...more >>
Exclusive Connection Posted by Tom Gaughan at 6/7/2006 1:02:08 PM Is there a way to establish an exclusive SQL 2000 connection, i.e. only
allow 1 user to connect?
In Access I am able using a file DSN with Exclusive=1. Is there a similar
property to use in the connect string or ADO connection object (I do not see
anything glaring there)?
Thanks - Tom
...more >>
failed to connect to SQL server from asp.net Posted by ajfish NO[at]SPAM blueyonder.co.uk at 6/7/2006 9:45:37 AM Hello,
I have an asp.net application which connects to SQL server using the
normal ado.net mechanism. One customer cannot get it to connect to the
database. his connection string is
user id=aaaa;password=bbbb;initial catalog=cccc;server=dddd
and he gets the message:
Cannot open databas...more >>
Sharing databases netween SQL 2000 and 2005 Posted by Dick at 6/7/2006 5:18:02 AM Is there a way to avoid the following problem:
I have a database created in SQL 2000. I detatch it from the SQL 2000
instance. I attach it to a SQL 2005 instance (I can see the compatibility
mode is SQL 2000). I detatch it from the SQL 2005 instance. I try to reattach
it to a SQL 2000 insta...more >>
txn isolation level and connection pooling Posted by Vikram Vamshi at 6/6/2006 11:55:02 AM Hi All,
Should the transaction isolation level persist across the reuse of a
connection from the connection pool?
From my experiment it does persist and I was not expecting it.
I was under the impression that "sp_reset_connection" will tear down all the
connection level settings and go back t...more >>
HELP - Connecting SQL Express Edition Posted by Soko at 6/6/2006 12:00:00 AM I have two machines and same problem.
I installed SQL EE on XP HOME EDITION it is OK !
Localy work OK !
I try to connect from another machine with SQL Server Management Studio and
I can't.
I some how successed to connect with named pipes but TCP/IP is not working.
I turn on all protocol...more >>
Schema Change of a Progress DB causes Linked Server to Fail Posted by Brian Drab at 6/5/2006 10:50:20 PM We use SQL Server 2000 and have a Linked Server to a Progress 9.1E
Database. Everything works fine until a schema change is made in the
Progress database. We then get an error message similar to the following:
OLE DB provider 'MSDASQL' supplied inconsistent metadata.
An extra column was su...more >>
Is it possible to make linked server from SQL Server 2000 to MySQL Posted by Chen at 6/5/2006 12:29:02 PM Hi All,
I need transfer data from MySQL to SQL Server 2000. Does anyone know how to
make a linked server from SQL Server 2000 (SP3 or SP4) to MySQL? If it's
possible, I need install MySQL client software in my SQL Server box. Am I
right? What kind procedures I need follow?
Regards!
-Chen
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problem with sql server connection sting Posted by Jack at 6/5/2006 9:24:01 AM Hi,
I am testing a asp page using sql server as the backend database. However, I
cannot connect to the database from asp. I have the following error coming
and I have also added the connection string that goes with the asp page.
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E...more >>
Can't make a new Login Posted by Pedro at 6/5/2006 6:33:01 AM Hi,
I have this problem:
When I create a new Login with a "SQL server authentication".
And if I change some User Mapping and Server Roles it gives me the follow
message "Create failed for User 'win2kadmin "
Server Name: SERVER\SERVER
Error Number: 15023
Severity: 16
State: 1
Line Numbe...more >>
Run SQL against SQL Server 2000 on Windows 2003 Web Edition Posted by AJ at 6/5/2006 4:35:02 AM I have a dedicated Windows 2003 Web Edition server running SQL Server 2000.
SQL Server 2000 was pre-installed. What tools can I use to interrogate and
update the SQL Server 2000 database from the Windows 2003 Web Edition Server?
Client and Adminstration tools are not supported and will not ...more >>
Developing with SQL Server 2000 and SQL Server 2005 on same machine. Posted by Dan Sikorsky at 6/3/2006 12:00:00 AM
I have SQL Server 2000 installed which has a server name of NOTEBOOKDELL.
I installed SQL Server 2005 Community Technology Review last October, 2005,
and somehow gave it a server name of NOTEBOOKDELL\SQL2005 so that I can keep
my SQL Server 2005 databases separate.
All was well until I...more >>
Using SQL Against SQL Server, Rename A Column?? Posted by ods at 6/2/2006 2:32:18 PM I need to rename a column in a table in a sql server database from my .NET
program. I can't seem to find the syntax to do this. Can it be done just
using sql?
Thanks
db...more >>
Rename A Field Using SQL Statement? Posted by ods at 6/2/2006 1:08:18 PM Is there a way that i can rename some fields in a table using SQL from my
..NET program? The customer send sthem in as BMT Number and I need
BMT_Number, etc.
Thanks
db...more >>
Emergency: lost connection to SQL Server Posted by Randall Arnold at 6/1/2006 3:02:27 PM For some unknown reason we just lost the connection to our local SQL server.
The error message is "Connection failed, check sql server registration
properties". I can't find any usable info on this cryptic error message.
Nothing was being done to the server around the time that this happened...more >>
need assistance on connecting to sql server Posted by MrRAO at 6/1/2006 11:41:01 AM Connect to Sql Server
>> SQL Server: [____________]
Connect using:
[ ] Window authentication
[ ] Sql Server authentication
Login Name : [____________]
Password : [____________]
-----------------------------------------------------------------------------------------...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |