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?

We are using SQL server 2008 and R2.

But we have only one 2000 server has some applications developed using Java.

And we want to migrate database to 2008 server.

I would like...

[quote-0You can put both the webserver and the sql server on the internal network, with this configuration you would need to employ a reverse proxy. This can be quite secure...