Displaying the most recent of 72 posts written by

nirav

Script to Partition in Existing Table in SQL Server

Partition in Existing Table in SQL Server. Step1 : Create Multiple File Group Database. Step2 : Create Simple Table with out partition. Step3 : Insert sample data into table with out partition. Currently we have created simple table without partition and now the step starts to create partition in existing table. Step4 : Create partition function. [...]

Partition Table in SQL Server

Partition Table in SQL Server To create table partition your database must need Multple file group database to apply Table partition. Step1 : Create Multiple Filegroup Database. Step2 : Create Partition Function to define partition block . here, i have created two partition block See Values(10) means first partition contains 1-10 and second partition contains [...]

Script to get Table Partition information

Script to get Table Partition information. This script gives you Table Partition information with Partition Number, Scheme Name and Function Name. Regards, Nirav Gajjar

VB Script to Delete Old Backup Files

VB Script to Delete Old Backup Files. I have created VB Script which deletes 7 days old file in Folder and Sub Folder. Regards, Nirav Gajjar

VB Scirpt to get Folder Size

VB Scirpt to get Folder Size. VB Script to get Folder Property. Regards, Nirav Gajjar

VB Script to Reboot Server

VB Script to Reboot Server. Reboot server and send information mail to user. Regards, Nirav Gajjar

VB Script to get list of Network Computers

Vb Script to get list of Network Computers.   Regards, Nirav Gajjar

Replication Issue – Duplication of Primary Key

Replication Issue – Duplication of Primary Key. Replication synchronizes data and article on subscriber same as it is on publisher. Changing and inserting data directly at subscriber cause to break replication. Please look the following error. Error Message Command attempted:   if @@trancount > 0 rollback tran (Transaction sequence number: 0x00000031000001B1000500000000, Command ID: 1) Error messages: [...]

Add article in Replication without initializing

Add article in Replication without initializing By this way you are only creating a snapshot only for newly added article and no need to reinitialize  all subscription. Step1 : Create New Table on Publisher. Step2 : Add this table in Article. First check Article exist or not in a replication. Run this to add “ReplicationTest” [...]

Script to Monitor Mirroring

Script to Monitor Mirroring This script will provide all database which is mirrored with mirroring mode, mirroring status and partner information. Regards, Nirav Gajjar