Try sp_resetstatus first to remove the suspect marker and see what happens. Once set that is the only right way to remove. Then let us know if still an issue.

...

Walk us thru what your are trying to do so we can offer a solution for your needs.

You most likely have the Auto Close option set on your databases. Open EM and right click each DB and select properties. It will be found in the bottom section...

It will reinstall new copies of the system databases. For safety I usually copy or move all existing databases to another location. Then reinstall, stop sql. Move the files back,...

Fortunately this happened only once to me and that went away. But the solution Brian states is a wonderfull thing. The only concern you need to be aware or if...

I get no errors when I create a table like so

create table Application_Function (

function_id int not null,

function_name varchar(200) not null,

graphic_name varchar(200) not null,

application_code varchar(50) not null,

parent_function_id int not null

)

Can you...

I noticed this today. One question, is it based on votes? If so then figures would be better if more people voted. Or, is it based on viewers (that would...

Depedning on the FK constraint I rarely use FKs to enforce itegrity. Usuall they are for silly things like a support table of options with a range or values 1-n....

Hope those of you who wrote here noticed this thread as well.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8454&FORUM_ID=83&CAT_ID=5&Topic_Title=Review+Needed+of+New+Product&Forum_Title=SQLServerCentral%2Ecom+Annoucements

I would first like to know what the VB app may be doinhg. My concern is what if you fire multiple times. Will this cause error, data integrity problems or...

Yeah you really have to predict what could happen and test if that condition would be met then handle your way. Otherwise it will end the process that cause the...

What version of SQL and what Service Pack level?

Also, what are the jobs doing that so many start at one time?

And check here and see if possibly related to your...

quote:

---

Here is an inelegant but straight forward way we use of creating a quick backup of a table in the same database:

select...

Have you change the account or the package in anyway recently?

IGNORE_DUP_ROW on index creation (not in SQL Server)

It was but removed. From BOL

quote:

---

No longer supported. Using either ALLOW_DUP_ROW or IGNORE_DUP_ROW in the...