Forum Replies Created

Viewing 15 posts - 406 through 420 (of 1,138 total)

  • RE: sqlserver 2005 installation

    dba-vb (10/5/2009)


    Hi,

    we are using the evaluation edition in our production environement.Now the time elapsed(6 months) how can i re-install? what i need to consider(backup)?How can...

  • RE: Memory settings question

    I cannot find an article atm to validate my reply, but from my understanding task manager can only see some of the memory allocated to sql server, and the more...

  • RE: How to Backup data base in every day

    polo.csit (10/6/2009)


    Hi all,

    i am using sql servwr 2005

    how to backup the database every day 1Am.

    it will take the autamatically i mean job schedue

    please help me

    In Management Studio, connect to...

  • RE: Kill process in system dbs

    np, glad to know it is fixed

  • RE: Best Autogrowth/AutoShrink Practise for TempDB

    Sergey Vavinskiy (10/5/2009)


    Marcin Gol [SQL Server MVP] (10/4/2009)


    after Kimberly Trip:

    1) SQL 2000 - #tempdb files = #logical cpus

    2) SQL2005+ - #tempdb files = 1/4 ~ 1/2 #logical cpus (typically not...

  • RE: SQL Installation Problem

    firemagon (10/5/2009)


    Hi,

    Whenever I try to install SQL 2005 on my system, I get an error

    "Failure setting security rights on DTS user account computer name". I have windows XP sp2 running...

  • RE: Maint Plans Problems After Moving System Databases

    JC-3113 (10/5/2009)


    Hi george sibbald-364359

    Everything i found said to upgrade tp SP2 but I was already on SP3

    So as a last resort i re-applied SP3 and it fixed the Maint...

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (10/5/2009)


    Lost thur to errands and my wife's truck tires, but I need to cut 6 small trim pieces for the edges along the wall and then...

  • RE: copy stored procedure object

    rot-717018 (10/5/2009)


    No, not yet, but I propose to close this thread as it's not accute anymore ... for the moment

    how can I close it?

    You are not allowed to close the...

  • RE: Are the posted questions getting worse?

    Roy Ernest (10/5/2009)


    Can someone clarify why you should do this?

    Nope I have the same viewpoint as yourself. seems too heavy handed to set that at server level, especially considering the...

  • RE: %100 CPU and sys.dm_os_waiting_tasks

    Seems to be diverting from the op's question. the op hasnt said that the server has NUMA architecture and secondly it is easier in some circumstances to find out what...

  • RE: Set SQL Server 2008 to ask for strong password

    radica_pet (10/5/2009)


    It is possible to set on server level on login creation to always ask for strong password.

    depends on your windows server setting, from the sql server point of view....

  • RE: Kill process in system dbs

    javier varas (10/5/2009)


    Hi.

    How can I to kill a process in Master db? The problem is that when i am running an update the server restart and when star again a...

  • RE: Recover The data After Deleting

    su_kumar11 (10/5/2009)


    Hi,

    I have a query.

    Suppose If I dont have backup of database.

    And I have deleted some data from the table or droped a table.Is

    there any...

  • RE: Issue with Database Email

    Mohammed Mohsin-392707 (10/5/2009)


    Job logs report as follows,

    "Mail queued. [SQLSTATE 01000]

    Job 'DBAdmin--- Space alert' : Step 2, 'email' : Began Executing 2009-10-05 02:42:28"

    No errors in event viewer. If I am using...

Viewing 15 posts - 406 through 420 (of 1,138 total)