Archived Months
January 2003
March 2003
April 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
April 2008


all groups > sql server programming > september 2006 > threads for saturday september 30

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

SQL instance
Posted by Wasim at 9/30/2006 11:56:02 AM
I am trying to connect my laptopname,which has various SQL server 2005 databases on it by using Query Analyzer & Mgt. Studio but it gives me an error as follws: An error has occurred while establishing a connection to the server. When "connecting to SQL Server 2005, this failure may b...more >>

getting strange error
Posted by Rudy at 9/30/2006 11:33:01 AM
Hi All! I have a SP like this. CREATE PROCEDURE [dbo].[GetNumWinners AS BEGIN DECLARE @WinNum numeric(10) DECLARE @Total numeric(20) DECLARE @Win numeric(20) DECLARE @UserID nvarchar DECLARE @House numeric(20) DECLARE @Guest numeric(20) SET @WinNum = (SELECT COUNT(*) FROM TblUserID WHE...more >>

SSMS
Posted by Bob Johnson at 9/30/2006 11:04:24 AM
Is there any way in SSMS to have the query editor automatically convert all keywords to upper case? For example I type in this: create procedure MyProcedure .... and the query editor automatically converts it to this: CREATE PROCEDURE MyProcedure I'm thinking that - if it can turn keywo...more >>

Question about adding extended database file and transaction file
Posted by Antony at 9/30/2006 8:43:01 AM
I am using Small Business Server 2003. I think it come with SQL server 2000. The transaction log is large and getting larger, moreover, a new project will be add to the existing database in the near future. I am afraid the hard disk is not large enough to hold the database + log. So I think ad...more >>

sharing a databse
Posted by S.Dickson NO[at]SPAM shos.co.uk at 9/30/2006 5:48:41 AM
I am very new to programing and serves ect and just learning. have just set up a business with a freind but we both work fro home. I have built an access database that we enter in ourcustomer details and any orders they place with us. As we both work from home we would like a way of sharin...more >>

Need help getting this .sql file into my SQL Server
Posted by MattD at 9/30/2006 12:34:20 AM
I was working originally with what turned out to be a very unreliable Offshore IT firm in India. I had to finally sever our working relationship with them. They were about 70% complete even though they demanded 100% payment upfront. WON'T EVER DO THAT AGAIN! My problem is they site me all the ...more >>

From 2000 to 2005
Posted by Bassam at 9/30/2006 12:00:00 AM
Hello We will migrate from SQL Server 2000 to 2005 , side by side installation so will keep both instances running at first , Is there an easy way of transferring all logins from 2000 to 2005 AND associate them with database users in the database that will be manually attached to 2005 ? ...more >>



DevelopmentNow Blog