Antonio Arienzo: the blog

le mie esperienze IT

How to grant insert in a table that is in another database on SQL Server 2008 R2?

fonte: https://dba.stackexchange.com/questions/96629/how-to-grant-insert-in-a-table-that-is-in-another-database-on-sql-server-2008-r2 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4c12914c-8364-48f4-ad35-db64fbeb0ff1/how-to-give-read-write-permissions-to-a-specific-table-in-a-database-of-sql-2008r2?forum=sqlgetstarted Use [DatabaseA] GO ALTER DATABASE [DatabaseA] SET DB_CHAINING ON GO Use [DatabaseB] GO ALTER DATABASE [DatabaseB] SET DB_CHAINING ON GO EXEC sp_grantdbaccess ‘UserB’; GO GRANT SELECT, UPDATE on [DatabaseB].[dbo].[TableA] TO [UserB] GO

Esportazione dati da SQL a file posizione fissa

Fonte: http://gaurangpatel.net/exporting-data-from-sql-server-to-fixed-position-flat-file Exporting data from SQL Server to Fixed Position Flat file Just as usual, this post is kind of “Bi-product” of my attempt to create a demo for another post in which I need to use fixed position file. At first I tried to create a fixed position file using BCP. BCP has query out.. Read More

How to Setup SQL Server 2008/2008R2 Maintenance Plan and Email Notifications

fonte: http://nideesh.wordpress.com/2012/10/24/how-to-setup-sql-server-20082008r2-maintenance-plan-and-email-notifications/ How to Setup SQL Server 2008/2008R2 Maintenance Plan and Email Notifications Most of the time we will have good installation and configuration for several systems but when we talk about maintenance and regular health check there should be a delay in talk and response. Database backup and maintenance should consider very important DBA should.. Read More