Forum Replies Created

Viewing 15 posts - 1,801 through 1,815 (of 2,436 total)

  • RE: DBCC Showcontig

    Why a linked server ? You can just execute it from QA ... am I missing someting here ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 18, 2005 at 11:30 am

    #598008

  • RE: @@servername ????????? empty output

    After executing sp_adderver ...,local you need toi stop/restart SQL Server.

     

    Just a little 'undocumented feature' that's been around since v4.21 ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 17, 2005 at 11:47 am

    #597709

  • RE: Server randomly slows performance.

    Just curious ... what did MS say that each of the trace flags did ???

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 17, 2005 at 11:45 am

    #597707

  • RE: MSDTC fail on Active\pasive cluster

    Is the server presently in production (I'm guessing no at this time). If the server is not in production I'd opt for the simple solution on this one:

    • Break the cluster
    • Re-enable...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 17, 2005 at 11:31 am

    #597695

  • RE: Automating SQL Server Service Pack / Patch / Hot fix apply

    First off automation is a no-no to many things can go wrong - the worst being that you have to recover (reinstall) a SQL Server. Second, having users assist in...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 13, 2005 at 11:59 am

    #597186

  • RE: Change of Domain on SQL Server machine

    I'm not so sure the AD migration tool will 'fix' Windows logins/groups within SQL Server ... but who knows ... any word on getting 'technical person'  ???

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 12, 2005 at 1:04 pm

    #596924

  • RE: Davy Crockett with advice on our "new" New Deal

    WOW ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 12, 2005 at 1:00 pm

    #596922

  • RE: Which SQL Server edition to buy?

    Developer edition has no 'throttles' - it's basically Entetrprise Edition under the covers.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 12, 2005 at 12:49 pm

    #596917

  • RE: How to make the db files smaller than orig. created?

    Run DBCC SHRINKFILE , then the ALTER/MODIFY.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 12, 2005 at 12:47 pm

    #596915

  • RE: Linked server security: ogin failed for user ''''sqllinked''''. Reason: Not associated with a trusted SQL Server connection

    Are you using domain user accounts for the SQL Server Service and SQL Agent Service ? Are the accounts the sameon each server ? Are the service accounts set up...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 12, 2005 at 12:43 pm

    #596912

  • RE: Change of Domain on SQL Server machine

    Yelana is on track with all of the changes (here's probably a few more lurking, dependent on which features you use). After the prep-wprk when removing the computer from the...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 12, 2005 at 12:18 pm

    #596904

  • RE: SQL2000 from Windows 2000 sp4 to Windows 2004 sp1

    I too have Win2K and Win2K3 servers in production and have performed this upgrade  a number of times without issue. By default when you install SQL Server 'BUILTIN\Administrators' has sysadmin...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 12, 2005 at 12:04 pm

    #596902

  • RE: Custom Job Manager Role

    Thanks a ton Terry ! I'll let you know if I can change anything for the better !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 11, 2005 at 12:59 pm

    #596635

  • RE: Active/Passive cluster

    I'm guessing the "Virtual SQL Server Instance IP" ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 11, 2005 at 12:57 pm

    #596634

  • RE: How to add column in specific position

    Chris, an ANSI 'flaw', I think not. Column order does not matter at all in the DDL. The 'flaw' is in the interpretation. Below I've excerpted a post of mine...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

    October 11, 2005 at 12:13 pm

    #596618

Viewing 15 posts - 1,801 through 1,815 (of 2,436 total)