Groups | Blog | Home


Archived Months
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
August 2008
all groups > sql server connect > august 2007 > threads for august 22 - 28, 2007

Filter by week: 1 2 3 4 5

Server connection to SQL/Server Express won't work
Posted by dperson at 8/28/2007 10:28:18 PM
I have SQL/Server Express set up on two machines. I turned on all the protocols for each. I started the server browser task on each. I opened ports 1433 and 1434 on both firewalls. I can sometimes find the servers when I browse. I just can't logon from either. I've tried logging on as 'sa'...more >>


Cant connect through Management Studio, Can connect Visual Studio
Posted by Burdock at 8/28/2007 2:16:01 AM
Hi, I am having a very frustrating problem trying to connect to a remote SQL Server 2005 at my ISP. When I try to connect through Management Studio the ISP SQL Server returns an error of 'Login failed for user xxx (18456)'. According to the ISP they can see my connection attempt in their lo...more >>

event 17187: SQL Server is not ready to accept new client connections
Posted by Seth at 8/28/2007 12:00:00 AM
(CrossPost: microsoft.public.opsmgr.sql, = microsoft.public.sqlserver.connect, microsoft.public.sqlserver.server) I installed SQL Server 2005, then i reboot the server (w2k3 r2 std ed), = then i saw the following event: Actually i reformated my sql server because of this event, and now it's = ...more >>

My available memory is down to very little, yet my PF Usage is 8 gigabytes (about how much memory is on the box), sql server keeps having memory issue
Posted by Daniel at 8/27/2007 4:38:12 PM
My available memory is down to very little, yet my PF Usage is 8 gigabytes (about how much memory is on the box), sql server keeps having memory issues yet the sqlservr.exe is using hardly any memory.. how to fix this? is there some way to limit how much memory can be used by this PF Usage? wh...more >>

in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usage statistics per stored procedure?
Posted by Daniel at 8/27/2007 4:26:13 PM
in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usage statistics per stored procedure? ...more >>

Export the Data of a field of 5000 characters length
Posted by Muhammad Kashif Azeem at 8/24/2007 12:00:00 AM
Create table myTable ( Name varchar, Description Text ) The description column contains more than 300 characters. The sql limit is to show only 30,35 words. Is there any tool available which can export around 5000 characters or more data of a single column. Regards ...more >>

help in a query plzzz
Posted by Adi at 8/23/2007 3:50:33 PM
hi, i have a simple question, mit look silly question for some one.. but please look into it n let me know how to write a query for it.. i have 3 cols col1 col2 col3 ----- ----- ------ 123 null 1159 434 null 1159 555 233 1490 999 null 1440 234 667 1159 the result set should...more >>

Linked Server can't find server/instance, but SSMS does
Posted by Dan at 8/22/2007 9:52:00 PM
I am trying to create a linked server between 2 SQL Servers. The server that I'm trying to connect to has 2 instances of SQL Server on it. One is SQL 2000 STD and is the default instance. The other is SQL 2005 Wrkgrp and has the instance name 'sql05'. I need to be able to connect to the linked...more >>



HELP: SQL Server 2005 Express OLEDB Connection from VB6
Posted by thompsom NO[at]SPAM aecl.ca at 8/22/2007 7:57:12 AM
Hi. I cannot connect to SQL Server 2005 Express on a Windows XP SP2 machine from a Windows 2000 PC using the SQLNCLI OLEDB provider in VB6. I can create an ODBC System DSN and connect just fine, but I cannot use a connection string with "Provider=SQLNCLI" or "Provider=SQLNCLI.1". I always g...more >>


DevelopmentNow Blog