Thanks a lot. I will check into it.

yes, I figured out that...

Thanks, I think you are right.

I changed it, and now I would like to test ola.hallengren.com script for just one database.

Now when I run the index optimizing job,...

xia.wu.1983 (8/12/2012)

---

I think you can define the shout condition for "NOTOK" in case of the job failure and "LONGRUNNING" if it runs longer than expected. ControlM does keep a log...

CELKO (8/11/2012)

---

A reflex on my part. I assume that people want...

It is wierd it didn't return any error at all, and the table is created successfully.

CELKO talked aobut DDL of my post, but here I only ask the question about...

I think if you create a unique constraint using sql, it creates both in gui constraint , also in index list.

But in GUI, you can only create a unique index.

Thanks, so this is to create a unique index, but not a unique constraint.

It seems not GUI way to create unique constraint.

I know how to add the constraint using SQL, but would like to know how to do it in SSMS GUI too.

I don't see any word about unique constraint from there

Thanks, how about the question no 1?

Thanks!

Thanks so much.

I thought this is done from SQL server windows firewall.

For I see some articles online like this one http://support.microsoft.com/kb/968872

Isn't it to run on SQL server?

I would rather let...

I checked with a network admin, he emailed me :

The web server is in a DMZ that is outside firewall.

Then he setup in firewall to expose the SQL server to...

Thanks, I see it has a tcp/ip port of 1433.

But how can I know this port is opened through firewall?