Forum Replies Created

Viewing 15 posts - 2,581 through 2,595 (of 7,164 total)

  • RE: SQL Server 2008 - profiler settings

    GilaMonster (1/1/2013)

    opc.three (12/31/2012)

    Trace Events will not contain plan_handle. I was talking about Extended Events (XE). XE is a new tracing sub-system introduced in SQL Server 2008 that will eventually replace...

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

    January 1, 2013 at 5:02 am

    #1572667

  • RE: Upgrading to 2012?

    SQL Server 2012 offers a lot of great new functionality but with upgrading comes cost and companies are typically slow to shell out the money if the current system supports...

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

    January 1, 2013 at 4:50 am

    #1572666

  • RE: is it possible to change an instance server properties with T-SQL ?

    pooya1072 (1/1/2013)

    can i use this to restart SQL service ...like that i Right click on Server name and Choose Restart.i want do this in T-SQL.

    No, unfortunately not. You could certainly...

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

    January 1, 2013 at 4:45 am

    #1572664

  • RE: sp_send_dbmail is not giving proper formate in txt attachement of SQL query output

    Megha P (12/31/2012)

    Hi ,

    I have following code to execute. i want to have functionality to send email for the following query output in text attachment, please note that query...

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

    December 31, 2012 at 5:21 pm

    #1572630

  • RE: How can I delete records base on the value of a fieled in the 1st recor?

    Sounds like homework, which is fine, I am happy to help, but please post the some table definitions (CREATE TABLE statements) and some sample data (INSERT statements) as well as...

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

    December 31, 2012 at 5:12 pm

    #1572629

  • RE: SQL Server 2008 - profiler settings

    RTSQL (12/31/2012)

    thanks for the reply. I am capturing events rpccompleted, spstatementcompleted and sqlbatchcompleted. none of these have plan handle as their column. but it works fine to filter by duration....

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

    December 31, 2012 at 5:09 pm

    #1572628

  • RE: Sentiment Analysis

    Phil Parkin (12/31/2012)

    How about this... Go find a random person, show him or her your copy of SQL Server, then ask how he or she feels about it.

    I thought I'd...

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

    December 31, 2012 at 3:06 pm

    #1572616

  • RE: is it possible to change an instance server properties with T-SQL ?

    pooya1072 (12/31/2012)

    hi

    can i change the properties of a server instance with T-SQL ...like Enabling mixed mode or change the name of server ?

    Have you learned about the Script button in...

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

    December 31, 2012 at 3:05 pm

    #1572615

  • RE: (SQL2005) SQLAgentReaderRole-->SQL2008?

    RVO (12/31/2012)

    Vendor documentation (for SQL 2005) says:

    "assign the system administrator permission to each of the following roles:

    SQLAgentUserRole,

    SQLAgentReaderRole, and SQLAgentOperatorRole".

    What are the equivalents of these Roles in SQL 2008?

    These are...

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

    December 31, 2012 at 2:57 pm

    #1572613

  • RE: Upgrading to 2012?

    It depends on what you need to support. You can have an instance of both versions of the database engine and SQL Agent installed side-by-side. Just be careful when in...

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

    December 31, 2012 at 12:24 pm

    #1572582

  • RE: Database restore issue

    Remember that D:\ is from the perspective of the server. If you have downloaded the AdventureWorks mdf file to your own D:\ drive and are trying to attach it to...

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

    December 31, 2012 at 12:23 pm

    #1572579

  • RE: Run A query on Multiple servers using CMS

    Those requirements are a bit vague. Are you running a select statement? An update? What will your CSV look like?

    Here is some boilerplate PowerShell code to help you get...

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

    December 31, 2012 at 12:10 pm

    #1572577

  • RE: Database Monitoring tool

    Scott D. Jacobson (12/31/2012)

    opc.three (12/31/2012)

    I am not saying the SQL Sentry tool is not great because I haven't used it, and their free Execution Plan Explorer is excellent, but I...

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

    December 31, 2012 at 12:02 pm

    #1572576

  • RE: SSIS loading only 5 of 42 fields to SQL

    Post the package you are trying with, the one having the issue on column 6, and I'll try running it on my side.

    We can at least see if it is...

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

    December 31, 2012 at 12:00 pm

    #1572574

  • RE: SQL Server 2008 - profiler settings

    Duration is not a column on the Trace Event, so no. Without the Duration column on the Trace Event your filter will not apply.

    You may be able to get what...

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

    December 31, 2012 at 11:56 am

    #1572573

Viewing 15 posts - 2,581 through 2,595 (of 7,164 total)