|
|
|
March 2003 May 2003 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 |
sql connection close problem (with vb.net lang) Posted by Agnes at 2/23/2007 12:00:00 AM During form Load, I want to fill in the dataset and the close the connection
at once. However, In SQL Server, I still find that the connection exists and
the status is "AWAITING COMMAND". My client 's IT admin complaint that this
connection should be disappear.
I really got no idea about SQL ...more >>
SQL Server on workgroup ! Posted by Rogers at 2/22/2007 3:32:55 PM I have two servers ServerA and ServerB, both are on the workgroup, I don't
wanna install domain controller, I have installed SQL Server 2000 on ServerA
and now I want to add windows account of ServerB into SQL Server (ServerA)
like ServerB\UserName? but it gave me an error.
I am wondering i...more >>
SQL Browser in Workgroups Posted by Queue at 2/22/2007 2:09:17 PM I am running into a problem where we have an SQL Server in a workgroup that
I'll call WG1, and a client running Windows XP SP2 in a workgroup that I'll
call WG2. The client is running Windows Firewall. When we use the SQL
Browser to find servers, we don't see our server unless we disable the
...more >>
Connections Timing Out Posted by Fini2549 at 2/16/2007 8:24:05 AM I am running an application on MS SQL2000 SP4. I have 5 clients connecting to
the SQL server. Almost every night between 5:oopm and 6:30pm, I lose the
connection to the server from the clients and I get a message about my
database possibly being compromised. Everything locks up and I must rebo...more >>
Search Text through Text Column Posted by Rogers at 2/15/2007 12:01:22 PM I have a Text(datatype) column in one of my table and it contains word
document in binary format and I wanna search text in that column, Can I do
that through any techniques or its not possible through SQL Server 2000
database?
Thanks
...more >>
updating an sql table using another sql table Posted by el at 2/14/2007 1:28:29 PM I started with a CSV file which I imported into SQL to create a table.
My initial table is employees (ID, LastName, FirstName, Department,
Division, Title, OfficePhone, MobilePhone, Login). The new table is
called employees_update ( LastName, FirstName, Login, OfficePhone).
I need to update the...more >>
SQL Server Clients Posted by Saravanan at 2/11/2007 4:42:00 AM Hello All,
I am not sure whether this is the right group, but still would like to get
some ideas. I am a DBA and I have a PocketPC with Windows Mobile 5.0. I would
like to remotely adminster databases. Is there any tools like Enterprise
Manager or SSMS that I could to connect to the SQL serve...more >>
MSDE AND RELATED PROBLEMS Posted by Gigit at 2/8/2007 6:35:14 PM Hi NG,
I have two problems with MSDE 2000 installed without any parameter
(default).
1 - The default installation is a SP2 and I cannot upgrade to SP4 because it
tells me 'Invalid instance'. I tried to use this entry in the setup.ini
INSTANCENAME=MSSQLServer because I thought to be the defaul...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Limit access in SQL Enterprise Manager? Posted by Rich L at 2/7/2007 2:27:06 PM We have SQL 2000 server. And our DBA clients connect to the various
databases on their using SQL Enterprise Manager installed on each of their
computers. For authentication to the databases they can connect by either
Windows Authentication or SQL authentication inside of SQL Enterprise
Man...more >>
Client Database Access/Opened Status Posted by Scott at 2/7/2007 1:32:26 PM Is there a way to tell if a SQL database is currently being accessed by any
clients? Is it possible to see which clients/users are currently accessing a
SQL database?
Thanks,
Scott...more >>
Some clients connect some don't Posted by Chris at 2/7/2007 6:17:00 AM What should I be looking for when 1/2 the Windows 2000 clients connect via
ODBC yet the other half do not? The error being returned is:
SQL State '01000'
SQL Server Error: 53
connection failed
And,
SQL State '08001'
SQL Server Error: 6
SQL Server not found
Thanks in Advance!...more >>
Shrink Tempdb Posted by Rogers at 2/5/2007 2:07:56 PM Dear Professional,
One quick question, is there any way we can shrink tempdb database and don't
need to restart SQL Server services?
Thanks in advance
...more >>
Client connect with static Port (over Dynamic) Posted by PK at 2/2/2007 4:50:00 AM Hi all
We have a server in our DMZ which need to talk (SECURLEY) with SQL 2000 i
have done this....by configuring a really tight rule on our firewall. This
trafic only needs to be inbound to SQL.
However it would appear that though the SQL Server listenes on port the
client 1433 The cli...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |