Very Computer

> So, there's no way (to your knowledge) or working around this problem?  Is
> there a way to make the view a stored procedure or something that would
run
> faster?

> > Are you using Enterprise Manager?  It has a query timeout
> > of 30 seconds and I don't think you can change this
> > property.  If all you're doing is exporting the data, you
> > should look into using DTS - data transformation
> > services.  Right click to All tasks > export.  You'll get
> > a DTS wizard that will step you through exporting.  You
> > can save the package and execute it whenever you want, or
> > you can schedule it to run automatically.

> > >-----Original Message-----
> > >I have a view that is run, and works without fail for
> > small amounts of data.
> > >I have to run this view in order to gather data for an
> > export I do weekly.
> > >Lately, we've been pumping up production, so the view
> > takes longer and
> > >longer to run.  I've reached the point now, though, that
> > it times out while
> > >gathering all the data.

> > >The view gathers data from two places...tables and other
> > views.

> > >Is there a way I can fix this?  If so, can someone help
> > me out and give me
> > >the 'dumbed down' version, as I'm still relatively new
> > working with SQL
> > >Server.

> > >Thanks for the help.

> > >.

> - Anith

> > No, it's not technically exporting...the DTS won't work I don't believe.
> > I'm actually running the view to populate a recordset in my code,
because
> I
> > need to manipulate the data (through the code) before outputting it to a
> > text file.

> > So, there's no way (to your knowledge) or working around this problem?
Is
> > there a way to make the view a stored procedure or something that would
> run
> > faster?

> > > Are you using Enterprise Manager?  It has a query timeout
> > > of 30 seconds and I don't think you can change this
> > > property.  If all you're doing is exporting the data, you
> > > should look into using DTS - data transformation
> > > services.  Right click to All tasks > export.  You'll get
> > > a DTS wizard that will step you through exporting.  You
> > > can save the package and execute it whenever you want, or
> > > you can schedule it to run automatically.

> > > >-----Original Message-----
> > > >I have a view that is run, and works without fail for
> > > small amounts of data.
> > > >I have to run this view in order to gather data for an
> > > export I do weekly.
> > > >Lately, we've been pumping up production, so the view
> > > takes longer and
> > > >longer to run.  I've reached the point now, though, that
> > > it times out while
> > > >gathering all the data.

> > > >The view gathers data from two places...tables and other
> > > views.

> > > >Is there a way I can fix this?  If so, can someone help
> > > me out and give me
> > > >the 'dumbed down' version, as I'm still relatively new
> > > working with SQL
> > > >Server.

> > > >Thanks for the help.

> > > >.