Another helpful post: https://blogs.msdn.microsoft.com/sqlblog/2011/08/24/setting-up-database-mirroring-with-certificates/ [/url]

Check out the following link, it gives step by step description to decrypt encrypted data

http://sqljunkieshare.com/2012/03/07/decrypting-encrypted-stored-procedures-views-functions-in-sql-server-20052008-r2/ [/url]

Or use the following SQL Decryptor Tool to decrypt encrypted SQL Server stored procedure http://www.sqldecryptor.repair-sql.net/...

Go to SQL Server Configuration manager > SQL Server Network Configuration > Protocol for MSSQLSERVER

> Enable Shared Memory

> Enable Named Pipes

> Enable TCP/IP

> Disable VIA

...

check out the following link maybe this will help you out: http://serverfault.com/questions/111510/how-to-monitor-activity-on-a-single-table-using-sql-server-profiler

You can also take the help of this link: http://www.sqlserverlogexplorer.com/sql-server-point-in-time-restore/[/url]

You can set up two databases to be mirrored from the same server, but you can't mirror onto the same instance: http://www.sqlservercentral.com/Forums/Topic538887-1291-1.aspx

To know how to use sp_WhoIsActive you can take the help of this link: https://www.brentozar.com/archive/2010/09/sql-server-dba-scripts-how-to-find-slow-sql-server-queries/

If you have a backup of the database, then it is the best time to use it. Before restoring database from backup, you need to verify it. As SQL server...

I found the similar question here: http://www.sqlservercentral.com/Forums/Topic463688-146-1.aspx

Take a look at this article maybe this will help you out: https://www.mssqltips.com/sqlservertip/1803/auto-alert-for-sql-agent-jobs-when-they-are-enabled-or-disabled/

sysobjects uid gives you the uid of the owner of the object.

uid is the schema ID of the owner of the object that is equal to the user ID of...

Take a look at this link maybe this will help you out: https://support.microsoft.com/en-us/kb/2837964

Check out the following link maybe this will help out: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/21d03bc1-f351-4329-bec3-7488f64df630/informatica-to-ssis-conversion?forum=sqlserversamples

You need to set a password for the Credential that is associated with the proxy. To do this, right click on the credential and select properties. Enter and...

Just RESTART your computer and you will be able to connect to your SQL Server, If this solution doesn't work then you can also take the help of this link:...