What is the id that the job is set up to RUN AS and what are the roles/permissions for that id?

If you have database and SSRS running off your machine so that others can access it, you cannot do your day to day activity. You need your computer ON all...

Its good design to keep every year on its own partition, so that you slide/merge and purge data year by year. With three years in one Partition, what will be...

REVSQL is not a server. It is SQL Server Network Name. Consider it has a virtual name or pointer that directs to REVSQL1 or REVSQL2 based on what is active.

The...

http://kx.cloudingenium.com/microsoft/servers/sharepoint/sharepoint-2013/how-to-resolve-error-the-execute-permission-was-denied-on-the-object-proc_putobjecttvp-database-sharepoint_config-when-using-sharepoint-2013/

Hope it helps

Please refer to response posted earlier

2. To change the SQL instance name - http://sqldbpool.com/2008/09/03/how-to-change-sql-server-instance-name/

If your database is very volatile and transactions drive, on the Veeam Snaphot job exclude your database and transaction log volumes. For your VM restore strategy, The snaphot will be...

When a snapshot is taken on a server, the drives needs to be quiesced for a very neglible time. Even this little time affects databases. So, an application aware image...

1. Is the server set up to 'Mixed mode' & do you know the 'sa' password?. Then , When you login thru SSMS , on the Authentication drop down...

In the Veeam backup or snapshot , 'is the application aware image processing' should be selected. This would require the id/pwd for the account SQL Server runs on set...

Possibly this might have happened http://stackoverflow.com/questions/1473315/the-select-permission-was-denied-on-the-object-sysobjects-database-mssqlsyst

Give a shot with the SQL Server 2014 upgrade wizard.

Triggers can be used for this.

Login failure might have happened because of invalid password entry. The default database for users is 'Master' db. If the default is changed for users to define the particular DB,...

The stored procedure got executed under your permissions but xp_cmdshell is run by {mydomain}\SqlAdmin account on Server A (When xp_cmdshell is invoked by a user who is a member of...