SQL management studio returns long query results truncated

Friends who play SharePoint may know that the SharePoint content database and configuration database store a long amount of information, when the SQL query result is returned in SQL management studio, the returned information is truncated.

 

You can modify the following options to allow management studio to return longer query results.

 

1. Open Management studio.

2. Tools-> options

3. Select the node results to Grid

4. Select the node results to text

 

References:

Options (query results/SQL Server/results to grid page)

Http://msdn.microsoft.com/en-us/library/ms190078%28v= SQL .100%29.aspx

Options (query results/SQL Server/results to text page)

Http://msdn.microsoft.com/en-us/library/ms178782%28v= SQL .100%29.aspx