Forum Replies Created

Viewing 7 posts - 46 through 52 (of 52 total)

  • RE: Archiving

    Hi,

    u can use BCP or more simple but little time taking create a linked server and run simple insert state with date time criteria.

    ex:

    insert into tablename select * from servername.databasename.usename.tablename

    where...

  • RE: Backup in another machine

    Hi osama,

    I am sorry for my incomplete answer.

    u should have the logon service rights on both the pc means ur domain account should have log on services right.

    secondly u start...

  • RE: PHANTOM jobs run by SQL server agent

    Hi Gorden,

    As u had checked all the tables i suggest the sysjobschudles and see the stat time and job status .

    If the enetry fo the respective time is not entered...

  • RE: Backup in another machine

    Hi Osama,

    U want to take the backup on the network derive .

    U can do by the below script but before the script u create a folder (backup folder) on network...

  • RE: Big One !

    Hi Mark,

    can explain what exactly want. i mean u want the supplier u had given order for all the product or non of the product or few of the product...

  • RE: disabling owner

    Hi,

    I got ur questation. U wanted that if ur user had created any achema then that ur should not delete that schema . yes u can do that u have...

  • RE: disabling owner

    Hi,

    As i read this very late.sorry for that but u can ristict ur database administrator for not droping a use .u create a extended stored procedure from that user.

    then ur...

Viewing 7 posts - 46 through 52 (of 52 total)