looks pretty good; if first and last name are required, i think they need to be NOT NULL, right?

Create Table Customers

(FirstName VarChar(20) NOT NULL ,

LastName VarChar(20)NOT NULL,

CustomerSSN SSN Primary...

you cannot ALTER a table and then also use the column in the same group of commands ; the column has to be added, and then a GO statmenet...

there is no equivilent; each SQL statements kind of assumed to stand alone, and would need everything it needs inline with the command itself, sorry.

run this query, and review the err.description:

they probably all have the same error message..it might say 5.7.1 relaying prohibited, or 551 mailserver not found, etc.

post one of those error messages...

I thought sysindexes is deprecated.

and that made sys.sysindexes the replacement?

rebuilding an index only builds the statistics on the columns included in the index; it doesn't do the whole table. so if the statsitics are out of whack for...

there is a drop down menu in the screen shot...right now it says "Index"

if you chose the other option in the list "Unique Key" it creates it as a constriant,...

i think it's more of just a naming...

it's there.

it's an option when you go to create or edit an index

Excellent! Thank you for the feedback!

I like trying to provide examples, it's much easier to help folks visualize and...

As Far As I Know, if you lost the passPhrase for creating the certificate, you would also lose the ability to decrypt anything that was encrypted with it.

if someone...

it's LinkedServerName.DatabaseName.User/SchemaName.ObjectName.

you want two periods together to hide databasename for Oracle; your example has 3 periods.

'EDWGEARS..ORAUSER.VW_FRED_AADT_HIST'

username/owner of the table? probably is' like

EDWGEARS..MYORAUSER.VW_FRED_AADT_HIST.

I think it's a best practice to create your own role that encapsulates just the required permissions.

Then i can assign any number of users to that role, as it's appropriate.

this...

glad i could help!