anam (1/18/2009)

---

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...

Jeff Moden (1/18/2009)

---

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...

CREATE TABLE ContactPhone

(

--Numbers for NANPA--

CountryCode_NPAnvarchar(10),--Country code for NANPA DEFAULT '1'

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

Exchange_NXX nvarchar(10),--Exchange code...

Yes, I know what you mean now Jeff. It would rather be cumbersome and will also make the application slower.

So, I have to create separate table for NANPA phone numbers...

Thanks for that,

But as per my scenario, the contact numbers sometimes could be interntational and sometimes they are not, purely depending upon the customer(Politician). We would have to store whatever...

Hello People,

I have creatd something like this:

PhoneType Table:

CREATE TABLE PhoneType

(

PhoneTypeIDintNOT NULLPRIMARY KEYIDENTITY(1,1),

PhoneDescriptionnvarchar(20)

)

ContactPhone Table:

CREATE TABLE ContactPhone

(

CountryCodenvarchar(10),

AreaCodenvarchar(10),

Exchangenvarchar(10),

PhoneNumbernvarchar(10)

)

ALTER TABLE ContactPhone ADD ContactID int References Contacts(ContactID)

ALTER TABLE ContactPhone ADD PhoneTypeID...

Hi guys,

First let me thank you for your kind replies. I really appreciate that.

Let me get you the right scenario. I am involved in designing database storage for Politicians Contact...

Oh thanks, That's true I shall delete the ON Update Cascade.

But i want to work it out this way:

If a customer changes the card details, I would like that...

Thanks a lot for your reply Steve.

But I really would like to try and install it remotely, I want to experiment you see.

After struggling a lot for couple of...

Hi,

Since you are focussing more on minimising data loss and huge transactions/sec you definetely need Transaction log backups for ever 15-20 minutes depending on how much loss of data your...

Hi,

Your question has already been discussed, refer this link:

http://www.sqlservercentral.com/Forums/Topic533052-146-1.aspx

Did you view the statistics to see whether SQL server is using the required indexes? Did you update the statistics? Did you check whether Autostats option is ON?There is a...

Check this link and it explains to step wise how to setup linked server

http://www.databasejournal.com/features/mssql/article.php/3691721/Setting-up-a-Linked-Server-for-a-Remote-SQL-Server-Instance.htm

Oh!..Lazy sunday I kept on editing my posts today....:hehe:

mahamed_elsirty (12/18/2008)

---

I PASSED EXAM 70-431 SINCE 2 WEEK

if you want to get high score study from pass4sure i upload the exame for u this version is still valid ...