Relative Content

Tag Archive for sqlserver

Sqlplan xml file convert to sql table

How to convert the sql server execution plan of xml file to sql table .
I can able to see the execution xml plan I don’t have provision in other ways using like Showplan text etc.,
Just want to convert the xml to output to the table .
Pls share if anyone has similar query and want to automate

SQL Server permissions for Application Integration

I have created a small application and want to post data to only one table in the database through that app. For that i have created a user with sql server authentication.what permissions should I assign to that user?