Hello,

Have you considered setting up the Oracle Servers as Linked Servers within your SQL Server and then scheduling a job to retrieve the data into SQL Server (on a regular...

Hello,

Try removing the Order By Clause. (I can't really see the purpose of having it in).

Regards,

John Marsh

Hello again,

State should also be available “online” via the “Show Technical Details” option. (In the block of text under the Microsoft Link that you provided previously).

Regards,

John Marsh

Hello,

Was there not a “State: NN” part to the Error Message? The value for State is important in determining the exact reason for Logon failure.

Regards,

John Marsh

Hello,

“is it ok just to have 5 field "pairs" (prodID; proddose; prodweight) & not use all of them depending on how many active ingredients are used?”

It would probably be better...

Hello Again,

You are right about needing to separate repeatable items into there own Table. It is also important to associate Attributes with the correct Entity.

Got to admit that I don’t...

Hello,

A key decision is, is the DB to be used for Transaction Processing or Business Intelligence? (For a BI DB you would probably want to consider Fact and Dimension tables)

Have...

Hello,

Can you post the error message that the user gets when trying to Logon using Windows Authentication?

Regards,

John Marsh

Hello,

To quote BOL (Topic “Creating User-defined Functions“): “Only FETCH statements that assign values to local variables using the INTO clause are allowed.”

Hope that helps.

Regards,

John Marsh

Hello,

Have you considered adjusting the Fill Factor for these Indexes? May be take a look at this article:

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1119108,00.html

BTW – Do these Indexes include columns that contain (Non-Sequential) GUIDs?

Regards,

John...

Hello,

IF no DB updates are being made between 5:00pm and 9:00am then a Full DB backup during this period would be appropriate. Probably start after EOD to ensure it is...

Hello again,

I have not (yet) seen it written in any MS documentation, but I was led to understand that the quote from BOL goes for SQL 2000 as well as...

Hello,

According to SQL 2005 BOL: “DBCC SHRINKFILE operations can be stopped at any point in the process, and any completed work is retained”.

I believe the same is true for...

Hello,

As others have stated, it is important to know which version the Original Poster is referring to. If different versions will be dealt with within the same forum, then the...

Hello again,

If you still want to use DTS and the data in the file is not sensitive, could you post a (small) sample file?

Regards,

John Marsh