Software Applications Programming Errors and solutions.

1. To check which user is taking maximum memory usage in SQL 2014 You can try below command select * from sys.sysprocesses sp_who2active 2. How to rename a column in subscription table in replication You have to remove from replication: Rename. and then re-add to replication 3. Clear cache in SQL for TempDb. RUN THIS COMMAND ON TEMPDB  DATABASE ONLY DBCC FREEPROCACHE  4. How to install the Service pack 3 on server,This is my recommendations . Server: SQL server 2012 standard edition having sp1 and you want to install the SP3 and CU 7 at a time ? Then you can install SP3 and check if that covers CU 7 as well, if not then you can install CU 7 after the SP3 Successfully installed. But make sure to take the DB Backups prior to proceed 5. Resolve Authentication Error for Mailbox in SQL Error is Mailbox unavailable. The server response was: Authentication is required for relay in SMTP server If You are providing the server address like Server ip witho...

Master The master database contains system tables that define the behavior of your SQL Server 2005 system. For example, each database that you add is recorded in a system table, and you can access information about those databases by executing a SELECT statement on the sys.databases catalog view. Similarly, information about all system stored procedures is stored in the master database. model Each time you create a new database, the model database is used as the template for the database you’re creating. It’s possible, if you’re planning to create multiple databases with the same customizations, to make those customizations once in the model database. msdb SQL Agent uses the msdb database to store information about tasks. tempdb The tempdb database is the scratch pad for the SQL Server system. A new tempdb database is created each time you start SQL Server 2005. Similarly, the tempdb database is discarded when you shut SQL Server down, so if you use the tempdb database to sto...