Based on this

--------------------------SQL BOL-----------------------

 user who can execute this procedure and is a member of the sysadmin fixed role can start any job. A user who is not a member...

1) What are the PROs and CONs of having index intermediate pages almost all filled while leaf pages will be set to the % of fill factor?

Intermediate pages support high...

Just a few things I look at.

I have 2 questions regarding index rebuild (DROP INDEX... & CREATE INDEX... OR DBCC DBREINDEX) in SQL Server 2000 SP3.

1) Is there a...

Check the Event Viewer logs as well to see what is tripping the engine. Never had a database cause this issue. If nothing else stop SQL Server rename the MDF...

Sorry I meant OR not AND. Try this

WHERE

Patient_Current_Pregnancy_details.Gestational_Age_weeks >= '36'

and IsNull(Patient_Current_Pregnancy_details.C13_Test_Result,'Pos') = 'Pos'

and IsNull(Patient_Previous_C13_Test.Test_Result,'Neg') != 'Neg'

and (

 Patient_Current_Pregnancy_details.C13_Test_Result is not null OR

 Patient_Previous_C13_Test.Test_Result is not null

)

In the above either can...

Add to you where condition

AND ([Pre-Status] IS NOT NULL AND [Current-Status] IS NOT NULL)

OK then take a look here.

You may say you have a Log File but treat it as thou you don't have the long from from the original DB and foloow...

I don't know. Might want to post to the MS SQL Boards to find out, I couldn't find anything on the reasoning it was implemented this way. It may be...

And all you did was overwrite the new database (not master) with the old on your local machine? You cannot connect to the server in any way or just to...

You are right however there is a context issue with trying to use within another SQL Structure. DEFAULT is only understood at the base level and not within functions or...

Look at "Connecting Early Version Clients to SQL Server 2000" in BOL.

As for storage the system enforces 8K on even 6.5 compatibility mode databases and you cannot restore them to...

Sorry I didn't backtrack far enough in the message.

Ok try this, create a database with the same name and the same MDF and LDF file names on your server. Just...

One thing I would add is that even thou you may not run into it user names can be up to 128 characters, I would either use 128 as the definition...

Another thing you will want to consider with file growth is what you have the file growth set to. Had a frieng who shrunk his daily but by the end...

You can get the names thru activeX but it is a bit of a task. You could also use a Data Driven Query Task item to create a single table...