Is this kind of what you are looking for? http://support.microsoft.com/kb/246133/

This is mostly for server level permissions. I believe (but have not tested) that if you do this first,...

There are 2 ways:

1.

Add a "Notify Operator Task" to your maintenance plan. I like to drag the "failure" constraint from each of the individual tasks to go to the...

It's all good. I'm almost certain the error was a parsing mistake in the client code, I just didn't know why MSSQL didn't throw an invalid column error instead...

Thanks Antonio - that does explain why SQL Server thought it was something that might have been valid.

Chad

1. My guess is that your code is passing either an empty string ('') or a zero as the value, either of which get converted to 1/1/1900 when cast...

I have what I think is the exact same setup at home (Home Premium and Express), and I was able to create "a" 😉 database with this command:

CREATE DATABASE a

Could...

Excellent! Just what I needed. Thanks for helping with my emergancy Matt (love your sig line).

Chad

Here is one option:

select MIN(LowestNumber.PK)

FROM MyTable LowestNumber

LEFT JOIN MyTable NextNumber

ON NextNumber.pk = LowestNumber.pk + 1

WHERE NextNumber.PK IS NULL

I think there are probably several ways to do it, and I'm...

You can do this - the key is in the syntax:

UPDATE

SET

FROM

WHERE

So, I think this is what you are looking for:

update publishers

set state...

Just to clarify what I did, I think the really ugly code I wrote would handle repeating groups... John's code is much more elegant than mine if the categories do...

Whoops! I got caught! Sorry Chris.

:hehe: MUST.... REDEEM.... PRIDE.... AT ANY COST!... :hehe:

If you have (or can create) an incrementing PK on the table, you could do something...

'Er you go:

select CASE WHEN ROW_NUMBER() OVER(PARTITION BY Change ORDER BY CHANGE) = 1 then Change else NULL end

, Security_Identifier

, Portfolio_code

from @tblReturn

Hope this helps,

Chad

A simple (but usually accurate) way of thinking about an index is to compare it to the index in a book or a phone book. In this case, think...

Thank you very much for your comments and your critique. I knew the question was difficult, and perhaps meant it to be somewhat tricky (using the transaction is valid,...

Hi Maya,

Does that mean that if the IIS settings are done correctly that the integrated auth will pass through correctly? We are set up like you and since our...