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


all groups > sql server connect > february 2007 > threads for february 1 - 7, 2007

Filter by week: 1 2 3 4

How to make different instances of SQL Server visible to each other?
Posted by keith at 2/7/2007 9:28:54 PM
Two instances of SQL Server 2005 cannot "see" each other. One is Developer edition and one is Standard edition. Standard editon is running under Virtual PC. I would appreciate any suggestions on how make these two instances visible to each other. Thanks, Keith ...more >>

Changing DB with a script using a variable.
Posted by Ray Laubert at 2/7/2007 6:49:01 AM
I am trying to write a TSQL Script for maintenance that willl read the databases from sysdatabases and change to each database inturn to perform some maintenance tasks. Problem is I can't get SQL to change to the next database. Tried Exec('Use' +@dbname) and it doesnt error out, but it also do...more >>

cannot generate sspi context when server in mixed authentication m
Posted by DBA72 at 2/6/2007 9:11:00 PM
We have a situation for which I have been trying to find an explanation for over a week. A windows 2005 SP1 server which previously ran in Windows authentication only suddenly caused "cannot generate sspi context" errors after we switched it to mixed authentication mode. -SQL service is run...more >>

Connection Problem VB.Net 2003 to SQL 2000
Posted by Fred at 2/6/2007 5:20:03 AM
Hi, I have a webservice created in VB.NET 2003 hosted on a Windows 2003 server. This service inserts data into a SQL Server 2000 database also hosted on a Windows 2003 server. The webserver is in a closed DMZ and the Database Sever is on the internal network. The firewall is configured to a...more >>

Access to SQL Server 2000 remotely
Posted by José at 2/5/2007 10:43:00 PM
I have installed SQL Server at my home computer. I can access from another computer over internet. But from my company, I can't. I talk to IT administrator, but he doesn't understand a lot abou this issue. Any help? What th IT should do to I have access? Thanks, Jose ...more >>

minimum speed to coonectSQL Server over inernet
Posted by José at 2/5/2007 10:39:01 PM
What the minimal speed is required to connect to SQL Server over internet to give a good connection? I mean where i can open forms, select item from the list boxes, generate reports, inputing data... Thanks José ...more >>

NTWDBLIB.DLL
Posted by kapil at 2/4/2007 9:34:01 PM
We are using the NTWDBLIB.DLL to connect to SQL2005 via the BDE(Delphi). As I understand it this DLL has been deprecated by Microsoft and therefore may not work with future releases of SQL Server. What is the likely future of the DLL, so we can understand the risks associated with continui...more >>

Query remote server
Posted by yuval at 2/2/2007 12:19:25 AM
hi, i have 2 sql2005 servers. i am traying to drop , insert from one server to another, and when i am trying to run simple query , i getting an error: "Msg 18452, Level 14, State 1, Line 1 Login failed for user ''. The user is not associated with a trusted SQL Server connection." the...more >>



cannot create job steps in 2005
Posted by Spicy Mikey at 2/1/2007 7:40:01 AM
I have a feeling this might be a security problem so I posting the question in the security group as well. Sorry for the double post, I'll paste any answers over there as well. Here's the problem; I'm trying to do some prototyping with SQL 2005 Standard - Full Text Search in preparation f...more >>


DevelopmentNow Blog