Forum Replies Created

Viewing 15 posts - 7,771 through 7,785 (of 9,244 total)

  • RE: Restore System DBs to Another SQL Instance

    dso808 (8/11/2010)


    Now we've been working on restoring the system databases first (of course) to the new instance and came up across this problem. Our production server has 2 drives...

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

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

  • RE: Quorum Conundrum

    Perry Whittle (8/18/2010)


    which version\edition of the Windows operating system are you using?

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

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

  • RE: SQL on VMWare

    Hello, me again.

    God this guy Russel likes Dell doesn't he? Not on the payroll by any chance is he? 😀

    Just one piece of advice, don't do it!!

    If a machine starts...

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

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

  • RE: Hi, I have migrated a database from sql server 2000 instance to another sql server 2000 instance.So i have taken the backup of the Tenu001 database and i have restored it onto the target instance.Then later on i tried to transfer the logins and passwords from the source instance to the target i

    Firstly, it would help if you post in the correct forum location for help with your issue, that aside the link at

    http://support.microsoft.com/kb/918992/en-us

    does not apply to your scenario in any...

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

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

  • RE: New Drive added to SQL Server 2005 not showing up

    you're welcome 😎

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

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

  • RE: SQL 2005 passwords

    The following gets any SQL Server login that has had their account changed in the last 3 days

    select [name] as SQL_User, modify_date as ModifiedDate

    from sys.server_principals

    where type = 'S' and...

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

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

  • RE: New Drive added to SQL Server 2005 not showing up

    you need to add that drive as a dependency to the SQL Server instance you wish to use it on. You will need to offline the service resource first, then...

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

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

  • RE: Quorum Conundrum

    which version\edition of the Windows operating systsem are you using?

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

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

  • RE: unable to install Cumulative Package 4

    you're welcome 😉

    To be fair that does catch a few people out!

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

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

  • RE: SQL Server Agent failed to start

    All username and password changes for the service accounts bound to SQL server services must be updated via SQL server configuration manager!

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

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

  • RE: unable to install Cumulative Package 4

    You are dowoading the wrong CU. You have selected x86 and not x64. Revisit the download page and select the correct CU. To see other downloads available click

    Show hotfixes for...

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

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

  • RE: Run SQL script with SQLCMD

    The backslash is not an issue, open a sqlcmd window and try it.

    My screenshot shows, you can enter a statement on line 1 and you push return expecting the...

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

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

  • RE: SQL 2005 Data Encryption and Clustering

    the clustered sql server instance uses a virtual network name which is shared between nodes.

    There should be no issue

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

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

  • RE: Creating an install package

    you could use SMO calls or build from T-SQL scripts!

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

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

  • RE: Run SQL script with SQLCMD

    no, if enetering T-SQL statements into the SQLCMD console you need to signal the end of the batch using the GO statement.

    The attached screenshot shows this!

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

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

Viewing 15 posts - 7,771 through 7,785 (of 9,244 total)