Forum Replies Created

Viewing 15 posts - 121 through 135 (of 286 total)

  • RE: SQL server BACKUP errors

    ssk0507 (8/19/2010)

    how will we come to know that backup is failed ? recently i had attend one interview they were asked like this

    i searched in google but i didnt find...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    August 19, 2010 at 7:46 pm

    #1209438

  • RE: snapmanager for sqlserver

    danny yun (8/19/2010)

    Hi Guys,

    We have an application (confirmit) that dynamically create, activate and deactivate databases. There are over 7000 databases in a single...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    August 19, 2010 at 7:41 pm

    #1209437

  • RE: how to delete the unwanted publisher and subscriber

    MAK-1128556 (8/17/2010)

    we are running SQL 2005,

    I create a transactional replication.

    when I restore the publisher db “A” into the subscriber server with different name “B” all the publisher that I have...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    August 17, 2010 at 8:33 pm

    #1208244

  • RE: The server name or address could not be resolved [SQLSTATE 01000] (Message 0)

    gmamata7 (8/17/2010)

    Hi,

    We have a SQL job running every 5 mins and sometimes it's displaying the below message when we view job history and at the same time the application is...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    August 17, 2010 at 8:19 pm

    #1208239

  • RE: How to Disable/Enable Foreign Keys on all Tables in a database

    krish.sett (8/17/2010)

    Hi Folks,

    In my current project i need to clean the tables before i run Packages on it.

    However because of Foreign key relation its not allowing to use TRUNCATE...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    August 17, 2010 at 8:14 pm

    #1208235

  • RE: Changing an error message in the sys.messages system table

    Any ideas? should I even attempt to make this change or am I playing with fire?

    Yes u r !

    Update to system tables should not be done in any way.

    Gail...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    August 16, 2010 at 8:36 pm

    #1207637

  • RE: Replication performance - getting down to details

    yonision (7/23/2010)

    Hello,

    I have a bunch of servers, one of which performs replications really slow. After few days of trying to do whatever I can to enhance its speed, I tried...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    July 27, 2010 at 8:09 pm

    #1199054

  • RE: Invalid column name 'is_not_for_replication'.

    Bill Gates-870674 (6/24/2010)

    ello,

    "SQL Server 2005 64Bit with latest SP"

    Already Synchronizing some subscriber with this publication. Created a cooy of Exisiting DB and added as a new subscriber. Subscription created successfully....

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    July 27, 2010 at 8:01 pm

    #1199053

  • RE: Linked server for sybase.

    striker-baba (7/15/2010)

    Hi all,

    We recently migrated our sql 2005 windows 32 bit to sql2005 windoes 64 bit.

    I have one linked server related to sybase.

    Inorder to configure I need either odbc driver...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    July 15, 2010 at 8:14 pm

    #1193861

  • RE: How do i return dynamic t-SQL Steatement into a varibale

    thinknight (7/12/2010)

    Hi All,

    How do i get a result like this

    set @qString = 'xp cmdshell ''rename '+@file1+' '+@file2+''' '

    declare @result int

    exec @result = @qString

    It fails how i correct this? and...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    July 13, 2010 at 8:22 am

    #1192056

  • RE: Manually Grow w/Multi files.

    digdave7 (6/24/2010)

    I was using

    ALTER DATABASE [XXXX] MODIFY FILE ( NAME = N'VSD2', SIZE = NumberBiggerThatbeforeKB )

    Technically they are in filegroups, right now we can't even open the database properties...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 24, 2010 at 8:21 pm

    #1184775

  • RE: Server Running Slow

    pujain (6/23/2010)

    Hi All,

    I am having a testing server(16 GB memory) 14 GB for SQL SERVER on which USER complaining about the slowness.

    can anybody suggest me a path how to go...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 23, 2010 at 7:56 pm

    #1184283

  • RE: Error on BCP export into .CSV file via xp_cmdShell

    keyun (6/23/2010)

    Hi All,

    I am using SQL Server 2005 where I have created SP to export out data into CSV file. I am using BCP utility to export out my...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 23, 2010 at 7:47 pm

    #1184278

  • RE: Replication Issue

    kiransuram19 (6/23/2010)

    Hi All,

    Today one of our deveploers updated 600000 records on the publisher database and the update took around 10 minutes to finish but the issue with subscriber its taking...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 23, 2010 at 7:38 pm

    #1184274

  • RE: Manually Grow w/Multi files.

    Hello,

    Can you let us know what are you trying to achieve by growing db ? What TSQL are you executing?

    There is an option for growing your db in chuncks of...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    June 23, 2010 at 7:29 pm

    #1184271

Viewing 15 posts - 121 through 135 (of 286 total)