Could you please clarify or reword you question?

-- Please not that I can't test because I do not have Oracle installed

-- but this is basically how you do it.

-- This is any anonymous block

DECLARE v_date DATE

--...

You also posted in the SQL Server 2005 Forum.

Mr Steve Jones has a very valid point but it seem that you are not clear on Filegroups and Files.

Perhaps the follow...

This is a double post.

Mr. Steve Jones replied to you at the following URL in the SQL Server 2008 Post:

http://www.sqlservercentral.com/Forums/Topic1097733-391-1.aspx

So you are suggesting that you should never consider a Natural or Candidate Key as the primary and always use a surrogate key regardless of the circumstances?

This post has gotten very long but a very informative exchange of information. 😎

It is usually preferable to use a natural key as opposed to a surrogate key in a relational Model. It depends on the situation

In a Dimensional Model you do not...

Quote Date: 7/10/2007

Standard Version

1 LITESPEED FOR SQL SERVER TIER A LICENSE/MAINT

2 $2,490.00

LSS-IMC-PB-TRA

$1,245.00

2 LITESPEED FOR SQL SERVER NON PROD TIER A

LICENSE/MAINT

2 $1,300.00

LSS-IMC-PB-NPNTRA

$650.00

Subtotal

Total $4,055.30

Quote Date: 7/10/2007

Enterprise Version

1 LITESPEED ENTERPRISE FOR SQL SERVER...

...

...

Elliot,

I did not believe that what I wanted to do could be accomplished.

Thank very much for you replies.

But did you have so say the period comment?

"This means that that what...

This is from BOL:

The SMTP connection manager supports only anonymous authentication and Windows authentication. It does not support basic authentication.

This means that that what you want to do cannot be...

seeteshh,

iiiii

I appreciate constructive critsism.

Thank you for those that have been respectful.

Regards.

I admit that it was a dumb question I was afraid of that.

Unfortunately there are some issues with the ISP that will prevent me from doing this in the script...