There is no deffinitive answer to that. It can be corrupted multiple ways. Any idea how it occurred this time? If not I suggest using chckdisk utility to check the...

Exactly what extract were you doing?

For instance I tried Month(ExpiryDate) = 3 but with so few rows (roughly 5 pages) and the fact it has to check them all so...

You might could try with 1 join and do and OR to get each columns match (but this will create multiple rows). From there on each column you use a...

It depends on how you set the path as to whether or not reboot is needed. I always do for safety but check with command promt by typing PATH and...

Your will have to use multiple joins. For you example it will be

SELECT

Det.[Name],

CM1.Desc AS Country,

CM2.Desc AS Department

FROM

dbo.Details Det

Inner Join

dbo.Codemaster CM1

ON

Det.Country = CM1.Code

Inner Join

dbo.Codemaster CM2

ON

Det.Department = CM2.Code

Only thru dynamic SQL.

Numeric types work this way or you can use String type example for both.

DECLARE @sql VARCHAR(1000)

SET @sql = 'UPDATE  MyTable SET (' + @ColumnName + ') =...

Try wrapping the creat view statement in dynamic SQL this should work. It won't allow a create view statement in SPs see the BOL article "Programming Stored Procedures" for more...

Ok verified by testing. Trying to revole DROP returns

Privilege DROP <object> may not be granted or revoked.

and trying to revoke CREATE INDEX returns

Privilege CREATE INDEX may not be granted or...

Look at "GRANT" in SQL Books Online. I gotta run right now but if you don't see any help there I will try to give you a better answer.

This might help

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

1. Users, even 'power users', should not be using Query Analyzer to access or ad-hoc query a production database.

2. Whatever tool users do use to ad-hoc query the database should...

ANd don't let me catch it again.

Dude, lighten up.

Enjoy the site and remember to tip your...

I jst tested and got the same issue. I think something is missing. I don;t know right off what but something.

Ok, then in Alerts view in EM what does it show Enabled?

You can disable them but only for UPDATES and INSERTS, not DELETES from what I find and BOL and have seen firsthand.