Forum Replies Created

Viewing 15 posts - 646 through 660 (of 2,436 total)

  • RE: Find out all SQL Server 2005 installations on our network

    You will need Domain Admin authority or someone who has it iun order to get that information.

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

  • RE: Find out all SQL Server 2005 installations on our network

    Mark SQLRecon does the WMI thing ... and AD and port 1433/1434 and tells you the complete version and if I remember even checks for blank sa passwords ! 

    It needs...

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

  • RE: SQL migration to Active Directory

    Do not forget service accounts for SQL Server and the SQL Agent. If you are using clustered servers then you have to add the 'clustering' service account and the MSDTC...

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

  • RE: Find out all SQL Server 2005 installations on our network

    SQLRecon is the way to go. To get the best bang out of it you will need a Domain Admin to run it.

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

  • RE: SQL SERVER RECOVERY TOOLS

     

    Bad Disk and no backups ?!?!?!?

    There are only two SPs I know of that can help in that specific situation:

    exec sp_update_resume

    exec sp_distribute_resume

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

  • RE: The Indian Yes

    No PC stuff here ... it is back to the basics:

    Communication - The conveyance of the speakers thoughts into words that impart the same thoughts to the listener when listening...

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

  • RE: char or nchar ?

    I take my hat off you Andras - I thought nobody else knew that ...

    This advice should also be coupled with NOT NULL as well because anytime you allow a...

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

  • RE: SQL 2000 Developer Edition

    Full version like developer ?

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

  • RE: SQL 2000 Developer Edition

    Either I am dense or blind ... do yuou have a link at MS for the developer version ?

    As for the evaluation version will it install on XP ???

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

  • RE: The Certification Debate

    This is a great 'can of worms. ... I personaly do not put faith in certs for many of the reasons stated so I will not belabor the point. I...

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

  • RE: Hardware & RAID Configuration - What''''s the best

    I always love to read extended posts on the virtues or lack thereof concerning RAID 0,1, 5, 1+0 & 0+1. Things always boil down to site standards, performance, money. I've used...

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

  • RE: SQL Server 2000 Enterprise Manager Snap-in missing

    huh ???? 1-2 hours to reinstall the EM ??? that has to be one really sloooooow server ...

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

  • RE: CREATE DATABASE

    A simple create on an HP DL-380 G5 attached to an EMC SAN should be less than 20 minutes.

    A single threaded restore on the same type of server can achieve...

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

  • RE: cmdexec step running and not doing anything

    You could try adding the following to the execution command line:

        >> some_error_file_path_and_name.txt 2>>&1

    This will capture any standard output from the command in addition to any error text thrown.

    I would...

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

  • RE: Question of the Day for 02 Aug 2007

    errorlog, then errorlog.1 ... because I just restarted the instance and want to make sure that it is OK and available for use then errorlog.1 to see if there is...

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

Viewing 15 posts - 646 through 660 (of 2,436 total)