Hi Jorge

Can you please clarify, the updates you are trying to do for comments is on which table? Is it the same comments table or you are updating the new...

Hi Jaya

If your requirement is only to create the database, then why don't you use the approach

check if database exists then restore the database with replace. If you want...

in a rush but will give a sample code and you can work around it based on your requirement.

DECLARE @colList varchar(8000)

SELECT @colList = COALESCE(@colList + ', ', '') + tblcol

FROM...

Hi Linda

no database backups are not on the same server.

i am in a virtual...

zubairm76 (2/3/2009)

---

Almost works.

When I convert using VarChar:

select CONVERT (varchar(11) ,WbsStartDate,126) from wbsdata

the result is May 25 2006 which is almost ok.

I need the format to be 2006 May 25....

as mentioned previously, you can add identity column and still use the exisiting primary key.

If you really want to add identity column to use as primary key, add it...

Brad M. McGehee (1/29/2009)

---

Can any of you math majors calculate what the number of members SSC could potentially have if the site continues to grow at the current rate for...

Your plan sounds fine but as Adonia said in previous post, disable the user rather than deleting. In future, if you'll face any problem in any sql server object referencing...

My questions are:

Since this is 2005 shouldn't the transaction log backups start to fail (which is not the case) on the primary side if the next transaction log...

Its entirely different here in Australia as to US. Contractors are the first to be axed. Group of big IT companies haven't renewed contracts of more than 1000 employees giving...

Krishna_DBA (1/17/2009)

---

CREATE TABLE ContactPhone

(

--Numbers for NANPA--

AreaCode_NPA nvarchar(10),--Area code for NANPA

Exchange_NXX nvarchar(10),--Exchange code for NANPA

Number_XXXXnvarchar(10),--Last 4 digits...

Krishna

I would say, try to generalise your table strucutre as much you can. i know its not possible to standardise the phone number formats from all the countries, but atleast...

interesting article with bonus of knowledgable discussion. keep it up mates.

what do you mean by table change - is it data in tables or table structure?

Thanks Lynn.

I think i need another coffee to get me working. i could have figured this out earlier before posting it here.

Cheers