Cant you set up the objects that this User needs to alter in a seperate schema and gove Alter Schema permission for that schema?

Do you have to update it the other table all the time when the first one gets updated? Then use a trigger. That is easier.

You should write the Where clause as

Where classnumber Not In ('544','444','100','142','143','326','370','378','457','467','594')

My suggetion would be to create a role, Let us say UserRole. Create a user with just connect permission. That means that user is just in the DB Role Public....

Thats because you have bad data in it.

ALZDBA, Yes I did get the picture. The only thing I was concerned about was the column name. But that shouldnt be a big issue. I think I can get...

Thats another logical option. Let me check the query plans for all these options.

You guys have given me 2 additional option than what I had.

Thx:)

ALZDBA

I do not want to use Dynamic SQL. I know it is powerful but I have never been comfortable using it. Unfortunately these tables has been there for years and...

Maybe this is a stupid question, but are you sure you chose all options and not just client side tools?

I think...

This gives the output differently from what he wants I think. This is what we...

This is a cheap trick

create table #Alpa

(Col1 char(1),

Col2 char(10))

insert into #alpa

Select 'a','red'

Union All

Select 'a','blue'

UNION ALL

Select 'b','white'

Union ALL

Select 'c','Yellow'

Select case col1 when 'a' then 1

when 'b' then 2

when 'c' then 3...

It will be an advantage for you since you have a pretty good grasp about Networking , Hardware. If you are being send for training then it should be good....

Hi Nivas,

You can run a profiler and see what all applications and what Stored Procs or Raw SQL (I hope you dont have any ) is hitting the DB. You...

If you are sure that the data in there are all valid dates, you can just modify it using SSMS to date feild.

Another option is to add another column with...