Displaying the most recent of 72 posts written by

nirav

Auto Fix Orphaned Users

Auto Fix Orphaned Users. When you move your database to any higher version, Logins and Users are not sync. This type of problem comes while the migraion, SQL calls that all users as Orphaned Users and we have to link it manually. we have the script bellow to link it manually. Thanks & Regards, Nirav [...]

Grant permission on Mail Profile in SQL Server

Grant permission on Mail Profile in SQL Server. In SQL Server you can grant send mail permission by granting “DatabaseMailUserRole” roles to particular user under MSDB database. But how to give permission to specific profile, follow the steps below. Step1 : Right click on “Database Mail” and select “Configure Database Mail”. Step2 : On a [...]

Increase Size of File Attachment in SQL Server

Increase Size of File Attachment in SQL Server. Microsoft SQL Server provides attachment when you sent an email from your application. By default maximum size for attachment is 1000000 bytes. Its less then 1 MB, we can increase this size by following the below steps. Step1 : Right click on “DatabaseMail” and select “Configure Database [...]

Configure IIS 8.0 Log to SQL Server

Configure IIS 8.0 Log to SQL Server. Before a months I had written a blog to insert IIS logs from log file to SQL Server using log parser tool. I have configured IIS logs direct to SQL Serve instance by setting config files and using ODBC logging. Step1 : Need to create one database and IISLog Table. [...]

Transfer IIS log setting from SQL Server Logs to Custom Logs

Transfer IIS log setting from SQL Server Logs to Custom Logs. In my last blog i have configured IIS Logs to SQL Server but what should happen when SQL Server Service is down or Database is not available? SQL Server DownTime It can be happen that your SQL Server goes down or somebody stopped SQL [...]

Configure IIS 8.0 on Windows Server 2012

Configure IIS 8.0 on Windows Server 2012. Basically I am writing a blog on SQL Server Administration and SQL Server Integration service but this time my boss assigned me a different task “To configure IIS on windows server 2012″. Latter on we have decided that we will capture IISLog directly to the SQL Server Database [...]

Script to Remove Sysmail_mailitems History

Script to Remove Sysmail_mailitems History. I am getting a space issue with my system data file drive, meanwhile I have checked the size of database and I found MSDB database contains 32 GB of data. I am shocked by this information and I have eagerly checked the size of particular table and I found  ”dbo.sysmail_mailitems” table contains [...]

Partition Existing Replicated Table

Partition Existing Replicated Table. To create partition in existing replicated table you must have to remove article from replication. The reason is, to create partiiton in existing table you must have to recreate primary key and you can’t recreate primary key replicated table. so, remove table from replication is first step. Note : Before you [...]

Remove Article From Replication

Remove Article From Replication In transnational, replication you have to remove article from Subscription list and drop an Article. Step1 : Remove article from subscription. Step2 : Drop article. Step3 : Refresh Subscription. Step4 : Start snapshot sgent in replication to apply changes in snapshot. –> Replication Monitor. –> Expand Publisher and select Subscription. –> Goto [...]

Add Partitioned Table in Replication

Add Partitioned Table in Replication. Step1 : Create Partition Table. Step2 : Script to add Partition Table in existing Replication. Step3 : Refresh Subscription. Step4 : Start snapshot sgent in replication to apply changes in snapshot. –> Replication Monitor. –> Expand Publisher and select Subscription. –> Goto Agent Tab. –> Right click on Snaphot and [...]