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 > october 2006 > threads for october 1 - 7, 2006

Filter by week: 1 2 3 4 5

Specifying which SQL Server to use
Posted by Todd Cary at 10/6/2006 6:24:57 AM
Under SQL Server Group, I have three registered servers: (local) (Windows NT) 192.168.100.5 (Windows NT) 2K-SERVER (Windows NT) Each server contains a database named "Admin" and each "Admin" database has a table, "Cases". In the following query, how would I specify the Server: SELECT...more >>

Accessing a remote SQL Server
Posted by Todd Cary at 10/5/2006 2:38:26 PM
Currently, I access a database and table that is not the current database using Admin..CASES INSERT INTO Admin..CASES (CASE_CODE,CASE_NAME,CASE_CLASS_PERIOD_BEG_DATE,CASE_CLASS_PERIOD_END_DATE, CASE_DISTRIBUTION_DATE,CASE_URL) SELECT M.MailCode AS CaseCode,C.CaseName, C.ClassPeriodBegDate...more >>

SQL 2005 Windows Groups Authentication - Cannot open user default database. Login failed
Posted by craig.overton NO[at]SPAM gmail.com at 10/5/2006 10:56:45 AM
All, To start off I have SQL 2005 SE Clustered in an Active/Active environment. Everything is working correctly as all websites and standalone applications are connecting and getting/sending data correctly using SQL authentication. My problem is that I have 1000's of developers that would l...more >>

DNS problems in ASP
Posted by FilMar at 10/4/2006 1:02:52 AM
I hope that I'm right here. We have an intranet-site in ASP where, till now the data was in an Access database and we connected to the data via DNS. Now we would like to change the data to a SQL-server. For me, it seems logic that logic that everything should work after creating a new DNS t...more >>

mssql backup/dumpfile
Posted by Suter at 10/4/2006 12:00:00 AM
Hi I'm using the free MSSQL Database from Microsoft and the SQL Server Management Studio express to administrate the datas. However, I'm looking for a possibility to backup my datas. Of course it should be a no coast backup way;) If I'm not totaly wrong then I can't make a backup or a dump...more >>

Connectio to Remote SQL Server from another SQL Server Stored Proc
Posted by Esteban at 10/3/2006 2:19:02 PM
Hi, I have a problem with a conection to Remote SQL Server Database wich have a blank space in databese name. Ex. "Production ED" I Can`t change the name of this data base. I Need to connect this database with a Stored Procedure in another Server. Both Databases are SQL Server 2000...more >>



DevelopmentNow Blog