If the stored procedure and the table it references have the same owner then you dont need explicit permissions for the table. This is called ownership chaining. You can get...

Checkout this post..

http://www.sqlservercentral.com/Forums/Topic1248558-1550-1.aspx#bm1248596

Found this..

http://www.sanssql.com/2008/10/when-was-my-database-last-used.html

Can you post the ddl of the two tables. Check out the following link

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you grant execute at the database level you will not see it being set under securables for each object (sp or function), you will only see it set under...

Another way to do this would be to create a database role and give it execute access. That way you can assign users to this database role

/* CREATE A NEW...

Yes. Navigate to Securables (right click user properties under security node) for the user (not login) and select database.

You will see all the database level securables you can set...

use [DBName]

GO

GRANT EXECUTE TO [Domain\user]

GO

This would grant execute access to functions as well as stored prcoedures

Is your developer's machine 32 bit or 64 bit machine ?

I am not sure if it makes a difference but remember reading some thing about 32 bit and 64...

It could be a security issue. When you are executing xp_cmdshell it uses service account's credentials if you are sysadmin or any other windows credentials if proxy is configured.

Whatever account...

You could probably use Ranking Functions but that does involve CTE, temp table or a table variable.

You can use Pivot function to do this..

SELECT [in review] as 'inreview',[with applicant] as 'withapplicant',[cancelled] as 'cancelled'

FROM

(SELECT [status],[name]

FROM temp) AS SourceTable

PIVOT

(

Count([status])

FOR [name] IN ([with...

The only option I can think if is modifying the id column to not have identity and add a new identity column and then delete the row.

Try this.. restore database DBName with recovery

You can try to convert your timestamp field to MM/DD/YYYY field and then compare

Example is Convert(date,CURRENT_TIMESTAMP,101) or Convert(varchar,CURRENT_TIMESTAMP,101)