Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: how to delete the unwanted publisher and subscriber

    run following script and will remove all unwanted publishers from subscribers which were created when Publishing DB was restored on Subscriber. It works for me,

    DECLARE @subscriptionDB AS sysname

    SET @subscriptionDB =...

  • RE: How to split one mdf file into multiple file

    Fo Example

    CREATE TABLE dbo.Table1

    (

    <columns_in_primary_key, , c1> <column1_datatype, , int> <column1_nullability,, NOT NULL>,

    <column2_name, sysname, c2> <column2_datatype, , char(10)> <column2_nullability,, NULL>,

    <column3_name, sysname, c3> <column3_datatype, , datetime> <column3_nullability,, NULL>,

    ...

  • RE: How to split one mdf file into multiple file

    Simple steps

    1. Create new file group say "Secondary" obviously

    2. Create New file under this file group

    3. If you have big objects, then create new object with some suffix with "SECONDARY"...

  • RE: A Function Gotcha with the Use of an Asterisk

    just now I've replied with simple query isntead of this long code

    Select ',', [column_Name] from information_schema.columns where table_name like '' order by ordinal_position

    Sushil

  • RE: A Function Gotcha with the Use of an Asterisk

    Sorry the query should be like this

    Select ',', [column_Name] from information_schema.columns where table_name like '' order by ordinal_position

    Sushil

  • RE: A Function Gotcha with the Use of an Asterisk

    You can simply write a query instead of doing all the copy paste and use of excel

    Select ',', [Name] from information_schema.columns where table_name like '

    ' order by ordinal_position

    Copy the resultset...

Viewing 6 posts - 1 through 6 (of 6 total)