Currently the user has explicit permission to alter,control and execute on the stored procedure. But still the user is not able to create the procedure from the software. I...

Thanks. I actually granted explicit alter permission on the stored procedure via SSMS. Is this different from running a grant command?

From the software, when the user runs a...

I’ve granted the user alter, control and execute permission to the stored procedure. But still the user is not able to modify the proc. And the user properties, under...

Thanks Greg

Yes, we are using Windows authentication. Thanks a lot. I'll try this out.

Thanks Bobby. Is there a way to find out the port??

Also, when I connect from my local pc, it will have my windows login. When I connect to...

Thanks Paul and Krishna.

Our client has been facing this problem on a day to day basis(this is not the slow running program I wrote earlier). We found...

Thank you for your reply.

The table structure is as I said above, has 2 fields with 2 non-clustered indexes. The table has 1.5 million records and it has...

Paul,

This table is not accessed by the program that ran last night. While collecting statistics for all the indexes, I happen to find this problem that there is no...

Thanks Jamie. The tables were designed long time back and I'm not sure why there is no clustered index. There is 2 non-clustered indexes for this table:

Tablename: EST_WRK

Columns: city_code,...

I just read the documentation, I see I should be able to uninstall the service pack if required.

Just one doubt, Since our server has Service Pack 2 on...

Thanks much, Bruce and Gail.

You are right. It did show the SP2 right at the end.

Microsoft SQL Server 2005 - 9.00.1406.00 (X64) Mar 3 2007...

Thanks. I'm sorry I posted in the wrong forum. I work with Oracle mostly and recently started working with SQL Server.

To apply the SP3, is there any specifc steps...

We just faced another performance issue with 2 other programs using the same table risg. Could it be something to do with the indexes in the table?? Does it...

Below are the sql queries ran from the program:

SELECT oitm,co from risg where cls <>'Y' and co >= :v1 and co <= :v2 order by co ASC;

OUTPUT:n records

update risg...