Forum Replies Created

Viewing 15 posts - 5,041 through 5,055 (of 7,164 total)

  • RE: Implementing TDE with Centralized Manangement of Keys

    Which software is on your list at the moment?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Memory settings

    sqlserver12345 (11/2/2011)


    Do the appdomain errors mean issues with the server/database?

    Does this error mean trouble?

    Error:appdomain is marked for unload due to memory pressure.

    It can mean trouble.

    What are the results of the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: 2008 R2 upgrade advisor error

    ehhh...same dead ends. I ended up installing the advisor on one of my 2003 servers instead of trying to run it from my desktop and the reports are happier.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: 2008 R2 upgrade advisor error

    I found this post through Bing. I am having the same issue. Did you ever find a resolution?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Memory settings

    What does this say?

    SELECT *

    FROM sys.configurations

    WHERE name = 'max server memory (MB)' ;

    You can set the max amount the buffer pool can use by...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Creating an user as a record in users table vs. creating an actual user?

    Ninja's_RGR'us (10/31/2011)


    What I have done in the end was to edit the create connection function & put the web login name in the application name.

    You saved yourself the headache of...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Error On Upgrade From SQL 2005 Database

    I know this thread is super-old but I am in the same boat...did you ever figure how to bring back the wrapper proc?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Script step in a job

    This is how I update a job step command via scripting:

    EXEC msdb.dbo.sp_update_jobstep

    @job_name = N'Job Name',

    @step_id = 2,

    @command...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Creating an user as a record in users table vs. creating an actual user?

    My preference is to have each physical user log in with a different server login. From a troubleshooting perspective I like to be able to trace runaway processes to specific...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Filtered Foreign Key

    okbangas (10/21/2011)


    ...and in fact it is kind of the intention too allow a single column represent several types of entities. It would be a nice feature for generalization.

    I thought...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Creating an user as a record in users table vs. creating an actual user?

    How many physical users are you expecting to have to manage?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Can I use Invoke-Sqlcmd to invoke the SQL and then quit?

    Have a look at the Start-Job CmdLet. Also, check the results of your favorite search engine when entering "asynchronous powershell".

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Fill Factor

    To answer one of your other questions, fill factor is set independently on all indexes, clustered and non-clustered alike. i.e. you can have 100 on your clustered index and 90...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Can I use Invoke-Sqlcmd to invoke the SQL and then quit?

    praveen_vejandla (10/25/2011)


    Is there any option that I can pass to Invoke-Sqlcmd such that it invokes the SQL code but do NOT wait till SQL gets executed completely?

    I am trying to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    patrickmcginnis59 (10/25/2011)


    ...

    Ok I guess I would be one of the "whats wrong with it" folks so I shouldn't have replied. Sorry about that!

    No need to apologize. It's just a discussion,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 15 posts - 5,041 through 5,055 (of 7,164 total)