Archived Months
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 new users > august 2007 > threads for august 8 - 14, 2007

Filter by week: 1 2 3 4 5

SQL 2005 express
Posted by april at 8/14/2007 2:05:03 PM
When I tried to apply service pack 2 for SQL 2005, it wont let me update Database services (status NA). Why is that? After the update, MSSQLServer still stays version 1399 for the original. Can someone advise?...more >>


Snapshot or backup restoration
Posted by Jim in Arizona at 8/14/2007 9:49:41 AM
We have two SQL2000 standard machines (two seperate boxes). One is our primary, production database and the other is a testing database which has a copy of the database from the production server. Being tasked with making the testing server up-to-date, I was wondering which would be a bette...more >>

Rename
Posted by Dr.Acrobat at 8/14/2007 12:00:00 AM
Is possible create a script for rename some file with date/time for name??? Thanks. ...more >>

mysql+php
Posted by Shakeel Ahmad at 8/13/2007 9:41:07 PM
is there any server other than apache that is easy to use which can be used with mysql and php? i am trying to use apache but it is not working on my computer.... IIS works on my computer........... ...more >>

propery assigning data to a variable in a select statement
Posted by Jim in Arizona at 8/13/2007 2:34:03 PM
I got this error: A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations. This is the select statment I used. select amount=(total-paid) ,datedue=dateadd(day, cast(@value as int), [date]) ,total ,paid ,stmtdate ,guarantor ,@invoic...more >>

Question about sql server express edition?
Posted by Paul at 8/11/2007 5:04:40 PM
Can I create an vb.net client/server Windows application using SQL Express as the backend database? If so what is the pros and cons as to compare it with the Access database? ...more >>

Looping through results, placing into 1 result set
Posted by Jim in Arizona at 8/10/2007 10:22:31 AM
I'm experimenting with some SQL trying to add the rows from a single column into a variable then looping through it to produce a single result set of all the returned rows. I can get the loop but produce one result set per row of data. I'm using a cursor (first time in eveer trying to attem...more >>

How to kill users who has blkby <> . (SQL Server 2005)
Posted by Winanjaya at 8/10/2007 5:02:02 AM
Dear All, I am running SQL Server 2005, how to kill users who has blkby <> . at once ? currenly, I am running it manually by running the following: sp_who2 kill <n> one by one Please help Thanks & Regards Winanjaya...more >>



Can't Create database diagram in sql2005
Posted by dotComPaJi at 8/8/2007 12:00:00 AM
I am new to SQL 2005 and want create a new database diagram but in my SQL server in Database Diagram I cannot find 'New Database Diagram Node" any Idea Why?? Following are my steps 1.. On the View menu, click Object Explorer. 2.. Open the Databases node and then open the <My Datanas...more >>


DevelopmentNow Blog