Forum Replies Created

Viewing 15 posts - 8,326 through 8,340 (of 9,244 total)

  • RE: sqlserver installation issue

    karan457 (3/19/2009)


    if i want to install ss 2000 & 2005 on one windows box

    q) can i install both as default instance

    no you cant. If you install 1 as...

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

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

  • RE: How to Create and Start SQL Server Trace Automatically

    Lowell (3/19/2009)


    the level of granularity seemed a bit tedious to invoke.

    Thanks!

    its very rare though you would capture every column for an event 😉

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

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

  • RE: How to Create and Start SQL Server Trace Automatically

    Lowell (3/19/2009)


    That's what made me think there must be a reason to enable some columns and not all columns.

    Hi Lowell

    you only really want to capture the events\columns you require otherwise...

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

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

  • RE: Create database using Backup file

    Venki

    you didnt indicate in your first post that the backup was a sql2005 database going into sql2000. This cannot be done. Only option is to DTS the data across to...

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

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

  • RE: Can't Connect with SQL Login

    mixed mode does help

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

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

  • RE: SQL 2005 Active/Active Cluster

    if you are not sure what you are doing i would leave well alone (and i mean that in the nicest way possible). Bring the cluster down and you could...

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

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

  • RE: Small server - any point in 64bit?

    The problem is (and i have come across this before) if you do point out a dev's bad piece of code mostly they get uptight, jumpy and defensive instead...

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

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

  • RE: Small server - any point in 64bit?

    Paul

    what Jeff is saying (and you have to agree is quite correct),You shouldnt do it expecting a massive increase in performance otherwise you could well be dis appointed. There are...

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

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

  • RE: Small server - any point in 64bit?

    if its a VM and you have the OS licence, may as well install 64 bit. As a VM you can scale memory, cpu and disk when required

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

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

  • RE: MSDB - Table Relationships Diagram

    here you go, courtesy of uncle Bill

    http://www.microsoft.com/downloads/details.aspx?familyid=2ec9e842-40be-4321-9b56-92fd3860fb32&displaylang=en

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

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

  • RE: SQL 2005 on VM Ware

    what version vmware server you using?

    have you mapped your VM's virtual NIC to the physical network or to a private virtual network, double check your config

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

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

  • RE: Just had an interview for a DBA in CT

    you didnt get the job then?

    full filegroup backup is different to full database backup

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

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

  • RE: Operating System error 5(Access is Denied)

    Ryan Wellman (5/16/2007)


    Sweet!

    I changed the "log on as" to .\Administrator for SQL Server (MSSQLSERVER) and SQL Server Agent (MSSQLSERVER). In the SQL Server Configuration Manager and ran the Log...

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

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

  • RE: 32Bit or 64Bit?

    the application will generally just issue statements to the database. What can cause problems is 32 bit versions of sql server interracting with 64 bit versions, replication in particular is...

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

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

  • RE: 32Bit or 64Bit?

    Dave (3/10/2009)


    I am trying to locate some sort of information to present to my managers regarding whether there is any differences, between 32Bit and 64Bit, in the way SQL Server...

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

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

Viewing 15 posts - 8,326 through 8,340 (of 9,244 total)