pln file

Posted on 2011-10-07
Last Modified: 2012-05-12
how do you use the PLN extension in sql serer?
Question by:25112
    LVL 5

    Author Comment

    it was sent as SQL server plan files.. but our management studio is not able to open it..
    LVL 59

    Accepted Solution

    Just to make sure we are on the same page, you are talking about the SQL Graphical Execution Plan, correct? You can open .sqlplan files using SQL Management Studio and view the execution plan details/visualization to determine how SQL will most likely perform the actual execution of a given query.
    LVL 59

    Expert Comment

    by:Kevin Cross
    Okay, I just saw your follow-up post. It sounds like it was just named the wrong extension. Change to .xml or .sqlplan and open again in SSMS and see what happens.

    If you open the file using Notepad, you should see something similar to:
    <?xml version="1.0" encoding="utf-16"?>
    <ShowPlanXML ...>

    Open in new window

    If you do not, then they may have sent you the wrong file or it is not meant to be execution plan.

    LVL 5

    Author Comment

    renaming the extention helped

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now