Forum Replies Created

Viewing 15 posts - 7,516 through 7,530 (of 9,244 total)

  • RE: Delete record without using Delete keyword

    Don't worry, if there's an angle to exploit MS will be there on top of the game 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Script to delete old bak files in sql server 2008

    What's wrong with the extended stored procedure that MS supply??

    --for first parameter (0) = FileBackup and (1) = FileReport

    -- 1 at the end means include first level subfolders in...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2008 Cluster work with Replication

    going to need a lot more information hear my friend!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Geographically dispersed multi-site "multi-instance" with SQL 2008 R2

    david.armstrong 13072 (10/18/2010)


    It seems like transactional replication would get the job done.

    providing all the replication objects have a primary key defined!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: cluster Failover

    mushtaq777 (10/19/2010)


    Cluster node 'XYZ' was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to the node having...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Another MSDTC question

    the only dependencies required for the MSDTC should already be in place. MSTDC depends upon its disk and network name resource! Yes, you will need admin privileges to create the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2008 MS DTC

    The document is 4MB in size so you need to be patient. Right click the link and select "Save target as...", then open the PDF once downloaded!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to create new instance in sql server 2005

    what info is there in the Windows event logs?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2008 MS DTC

    To add to what Halcyon has already stated

    Duran (10/19/2010)


    I did try to slipstream the install, but I got an SQL Native Bootrapper stopped working error, so I tried another slipstream...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to create new instance in sql server 2005

    Are all the services started without error?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: DB Engine service won't start with service account

    Incidentally, rathing than poking around manually setting SPN's just allow the service account to do it automatically.

    In ADSIEDIT find you service and account and select properties then go to the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Error while moving model and msdb system databases.

    You may want to bookmark the following link for future reference

    http://msdn.microsoft.com/en-us/library/ms345408.aspx

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: DB Engine service won't start with service account

    turfnsurf4me (10/19/2010)


    What I neglected to articulate is that I use the ADSI Edit snap-in and edit the service principal name property ( of the service account) directly while on the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL server instance ip's

    gaganks (10/19/2010)


    Thanks Perry, But is there a T-SQL statement to know this incase a user doesn't have RDT access.

    Thank you.

    Not as I remember, the entry point into the clustered instance...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL server instance ip's

    Clustering has changed a lot between the 2 platforms. On the Cluster node go into cluster administrator and select the resource group for the instance you wish to view details....

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 7,516 through 7,530 (of 9,244 total)