Here's one way, but I'm not sure that it's the best. Create a table called ForbiddenPatterns with columns Size, Colour, Pattern. Insert one row for each forbidden combination....

You can check the authentication mode in the registry. If it's set to Windows only, change it to Mixed and try sa again. If that doesn't work, you...

So the answer to your original question is no, it's not overkill. You can't rely on the clustered index for sorting query results. Parallelism, advanced scans and other...

Fairly simple in T-SQL, as well:

SELECT

a.RowNumber

,a.name

,a.dQty

,a.Price

,b.RowNumber

,b.name

,b.dQty

,b.Price

FROM

MyTable a

LEFT JOIN

MyTable b ON a.RowNUmber + 1 = b.RowNumber and a.RowNumber%2 = 1

John

Yash

It's not easy to condense into a few sentences if you've never designed or edited a package before. Is your code all under source control? Is the person...

Yash

No, it's in the package. You need to open the .dtsx file in BIDS and redesign it.

John

Yash

Put all the tasks in question into a Sequence container and set the TransctionOption property to Required.

John

I think you'd need a trigger to implement that sort of logic.

John

Interesting. Looks as if the maintenance plans are running...

OK, so you've opened the job, looked at the Owner field, and check that the login specified there is sysadmin? You'll need to find a different way of checking...

If the login that owns the job is sysadmin, then the job should run in the context of the SQL Server Agent account. Does SQL Server run under the...

I would strongly advise against running any service under a domain admin account. If the service gets compromised (whether accidentally or maliciously), an unlimited amount of damage could be...

There's a utility (it might even be free) that displays all your scheduled jobs in a calendar format. I'm afraid I don't know what it's called, but if you...

Srikant

My advice to your management would be to test thoroughly in advance, so that you can be as confident as possible that when you upgrade in live, there won't be...

You haven't said what exactly isn't working. I suspect that your problem is how to fire triggers from events in AD. If that's the case, you'd be better...