Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Increase Size limit of Dataset query ? Expand / Collapse
Author
Message
Posted Thursday, October 31, 2013 1:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 6, 2013 6:04 AM
Points: 2, Visits: 12
Hi Experts ,

I have very big query (exceeds 300 line) and i want ot paste the same of dataset query designer.
Is their any way by which i can increase the size limit

Many Thanks

Post #1510045
Posted Thursday, October 31, 2013 2:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:33 AM
Points: 13,268, Visits: 10,145
nilamskhandare 86777 (10/31/2013)
Hi Experts ,

I have very big query (exceeds 300 line) and i want ot paste the same of dataset query designer.
Is their any way by which i can increase the size limit

Many Thanks



Sorry, I'm not quite sure what you mean with size limit?

If your query is too big (300 lines is fairly OK), you can maybe use a stored procedure.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1510063
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse