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


all groups > sql server (microsoft) > december 2006 > threads for december 1 - 7, 2006

Filter by week: 1 2 3 4 5

integer - beyond 2,147,483,647
Posted by User at 12/7/2006 12:41:58 AM
what happends if an auto number (identity column) of datatype "int" goes beyond 2,147,483,647 ? Does user have to go for 64 bit in this instance? Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTI...more >>

Database change management process
Posted by Mehdi at 12/6/2006 10:02:31 PM
Dear In our company, we use sql server 2000 as the database server for softwares we produce. The problem is the way that we track the changes in database and control the changes which every developer makes in db (something like source safe that controls the code changes for our source codes) . ...more >>

Q: missing parent
Posted by G .Net at 12/6/2006 11:47:37 AM
Hi Can anybody tell me the sql query I need to find the following: I have two tables A and B. A is a parent to B. I need to find the rows in B which do not have a corresponding foreign key value to a row in A. Thanks in advance G ...more >>

inserting "0" to all fields.
Posted by User at 12/5/2006 9:42:47 AM
Hi, I have a table with 30 columns. I want to insert a value of "0" into the columns I do not wish to do a insert into table (col1,col2,col3.....col3) values(0,0,0,0,0,0,......0) as it is a very painful process. One comma missing and it's going to hurt my eyes. Are there any shor...more >>

Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000
Posted by Alex at 12/5/2006 7:56:06 AM
Hi Everyone, Most of our MS SQL Servers are still running on SQL 2000, but being I will soon be upgrading my workstation to Vista Business I'd like to install MS SQL 2005 Enterprise Manager to manage them all. When I tried to install MS SQL 2000 Enterprise Manager on Vista, it gave me a mess...more >>

Newbie how-to websites?
Posted by Walksalong at 12/5/2006 6:07:19 AM
Hello, I am a newbie to SQL Server and I wanted to ask the group if they could recommend some resources on how to do basic functions such as create a data dump. Thanks! ...more >>

Consecutive days attending
Posted by Mike Hoff at 12/4/2006 10:51:02 AM
Hello, I am looking for a way to determine the maximum number of consecutive days that each client has attended an event over a certain date range. (consecutive being key, and my problem). For example: Over the date range 1/1/06 - 12/31/06, Bob attended 42 consecutive, Jim 17 consecutive, Mar...more >>



DevelopmentNow Blog