25112
asked on
pln file
how do you use the PLN extension in sql serer?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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:
If you do not, then they may have sent you the wrong file or it is not meant to be execution plan.
Kevin
If you open the file using Notepad, you should see something similar to:
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML ...>
<BatchSequence>
<Batch>
<Statements>
...
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>If you do not, then they may have sent you the wrong file or it is not meant to be execution plan.
Kevin
ASKER
renaming the extention helped
ASKER