Tuesday, September 10, 2013

Deny access permission to table

 DENY SELECT, INSERT, UPDATE, DELETE ON [dbo].[Table] TO [user]

Tuesday, July 9, 2013

ReBuild Master Database From setup.exe

F:\>Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINA
CCOUNTS=Domain\Administrator  /SAPWD=sa password

Frequent Starting up Database

Go to SQL Options and mark Auto close to false.

Thursday, March 21, 2013

The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.

use [master]
GO
GRANT EXECUTE ON [sys].[sp_OASetProperty] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OAMethod] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OAGetErrorInfo] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OADestroy] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OAStop] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OACreate] TO [public]
GO
use [master]
GO
GRANT EXECUTE ON [sys].[sp_OAGetProperty] TO [public]
GO
sp_configure 'show advanced options', 1
GO
reconfigure
go

exec sp_configure
go
exec sp_configure 'Ole Automation Procedures', 1
-- Configuration option 'Ole Automation Procedures' changed from 0 to 1. Run the RECONFIGURE statement to install.
go
reconfigure
go

Wednesday, February 13, 2013

The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.

sp_configure 'show advanced options', 1
GO
reconfigure
go
exec sp_configure
go
exec sp_configure 'Ole Automation Procedures', 1
-- Configuration option 'Ole Automation Procedures' changed from 0 to 1. Run the RECONFIGURE statement to install.
go
reconfigure
go

Monday, February 11, 2013

SSRS repeat header on each page

http://remicaron.wordpress.com/2010/01/05/how-to-get-ssrs-to-repeat-the-row-headers-tablix-2008/

Wednesday, January 2, 2013

Auto Login windows server

1. In the Start menu click Run and enter control userpasswords2. After clicking OK  to the User Accounts window will show up.
2. Now click the account you want to login automatically and uncheck Users must enter a user name and password to use this computer checkbox. If you now click Apply it will ask for the password of the user you selected. Enter the password of the selected user twice and click OK. From now on every time you start Windows it will automatically login!