See below code:
SQL Server Fixed Server Role Permissions – run – sp_srvrolepermission ServerRole Permission bulkadmin Add member to bulkadmin bulkadmin BULK INSERT dbcreator Add member to dbcreator dbcreator ALTER DATABASE dbcreator CREATE DATABASE dbcreator DROP DATABASE dbcreator Extend database dbcreator RESTORE DATABASE dbcreator RESTORE LOG dbcreator sp_renamedb diskadmin Add member to diskadmin diskadmin DISK INIT diskadmin sp_addumpdevice […]
Transferring logins and passwords between separate SQL Server instances eg SVR1\DEV to SVR1\DEV2 can be done by scripting out the encrypted passwords using the stored procedures sp_hexadecimal and sp_help_revlogin which can be found by following this detailed link by clicking here.
Running the SQL Server 2014 upgrade advisor is a good idea when say planning an in-place upgrade from a previous version of SQL Server. To do this, run setup from the installation disc, go to planning, run install upgrade advisor. You might get a pop up such as below, this is resolved by downloading and […]
Below is the final error message l kept getting when setting up a SQL Server Agent Job which ran an SSIS package. The SSIS package is designed to create a folder in a network share as well as copy some files into that folder. Message Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 […]
You cant restore a database backwards from SQL Server 2008 to a SQL 2005 Instance. One trick you can use is to script the entire database, and ensure you select in the advanced options as shown below, SQL 2005. Then run the script at the destination SQL 2005 instance. Remember to change the database file […]