Automating Reporting Services in my Windows App.

Is there a way of automating SQL Server Reporting Services reports in my win
app?
I want to be able to pick up events when the user right-clicks on the report
etc.
I really want to provide a context menu with options relevant to what
they've selected in the report.
As I understood it, the generated report is basically html and theres no
easy way of doing it...
I basically want the report to be more dynamic than just being generated and
then printed.
If not is in coming in a future version of SQL Server?Are you using the ReportViewer control?
http://gotreportviewer.com/
If on the server you may be able to add via .css?
http://weblogs.asp.net/jgalloway/archive/2006/09/01/SQL-Reporting-Services-_2D00_-CSS-fix-for-Firefox.aspx
Steve MunLeeuw
"James" <James@.discussions.microsoft.com> wrote in message
news:E1244EC6-5372-4AB2-8BC1-9D41827F2D8E@.microsoft.com...
> Is there a way of automating SQL Server Reporting Services reports in my
> win
> app?
> I want to be able to pick up events when the user right-clicks on the
> report
> etc.
> I really want to provide a context menu with options relevant to what
> they've selected in the report.
> As I understood it, the generated report is basically html and theres no
> easy way of doing it...
> I basically want the report to be more dynamic than just being generated
> and
> then printed.
> If not is in coming in a future version of SQL Server?|||yes, I'm currently looking into doing it via hyperlinks as in the following
article:
http://www.devx.com/dotnet/Article/30424/0/page/6
"Steve MunLeeuw" wrote:
> Are you using the ReportViewer control?
> http://gotreportviewer.com/
> If on the server you may be able to add via .css?
> http://weblogs.asp.net/jgalloway/archive/2006/09/01/SQL-Reporting-Services-_2D00_-CSS-fix-for-Firefox.aspx
> Steve MunLeeuw
> "James" <James@.discussions.microsoft.com> wrote in message
> news:E1244EC6-5372-4AB2-8BC1-9D41827F2D8E@.microsoft.com...
> > Is there a way of automating SQL Server Reporting Services reports in my
> > win
> > app?
> > I want to be able to pick up events when the user right-clicks on the
> > report
> > etc.
> > I really want to provide a context menu with options relevant to what
> > they've selected in the report.
> > As I understood it, the generated report is basically html and theres no
> > easy way of doing it...
> > I basically want the report to be more dynamic than just being generated
> > and
> > then printed.
> >
> > If not is in coming in a future version of SQL Server?
>
>sql

Automating Daily Database Inserts...Contd

I used thetutorial on creating a windows service. i was able to succesfully create a service. however, after going through the whole tutorial i realized this is something that is always running. i need to run the service only once a day ( usually past midnight).

does anyone know how i can configure it so it runs only at a specified time and not always.

thanks.The service will always be running since that's how services work. The service periodically checks every Timer.Internval milliseconds whether something should be run. When it actually runs something, like a report at midnight, is up to your code.

If you are concerned about the resources used by the service you can open up the Windows Task Manager and look under the Processes tab. My own similar scheduler uses a negligible amount of CPU. It barely ticks over a few seconds per 24 hours.|||so how do i set it to run at a certain time..all my calculations r dependent on the date functions...so i need the service to run after 12 midnight. so how do i compare the timer to the time of the day...
do you know of any tutorial or some sample...

thanks McMurdoStation|||The service is always running (that is the beauty of it). You need to code it such that it looks at the time of day and runs your process when required. In your case, you can have it check the date periodically, and then whenever the date changes, run the process.|||

// C# but this should give you the general idea
// Declare class level variable to hold date process last run
private DateTime lastRunDate = System.DateTime.Today;
// then handle the event the timer generates when each Timer.Interval has elapsed
private void timer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e) {
DateTime today= System.DateTime.Today;
if( today > lastRunDate){
lastRunDate= today ;
RunYourStuff();
}
}

|||thanks both of you. i understand it better now.
however, i dont know what i messed up. i have been fiddling with it for some time now. i had already created 2-3 windows applications- one for creating a bunch of html pages , another for opening each of these files in a word app and printing it. now i was trying to merge all these processes into one windoes service. so i cut/pasted some code..etc. now it throws an error :
"
cannot start service from command line or a debugger. A Windows Service must first be installed (using instalutil.exe) and then started with the Server Explorer, Windows Services Administrative tool or the NET START command."

i am pretty sure its not the code. also when i went to administrative tols -> services -> and browsed for my "Service1"... it shows up in the list but its not started. i was trying to start it. it says "

"The service1 on local computer started ans then stopped. some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts Service."

can you help me figure this out...

thanks in advance|||anyone..|||Did you create the installer for the service? I think that article talks about that too. After you create and run the installer then you can start the service from the Services Manager (if it didn't start automatically).

If the service is crashing still then add some code to write out the event log so that you can figure out where it is when it crashes.|||actually i was able to start the service...i can see it from the admin tools -> services

i tried to schedule it using windows scheduler and when the program ran at the specified time
.. it kept throwing the error :

"cannot start service from command line or a debugger. A Windows Service must first be installed (using instalutil.exe) and then started with the Server Explorer, Windows Services Administrative tool or the NET START command."

i dont understand why we have to create a set up project..
when i schedule the task.. i should select the windowsservice1.exe right ?
i googled around for some time, but most of the articles are too brief..

thanks|||You do not have to schedule the service to run. It is designed to CONSTANTLY run, with or without a user logged in. You need to check to make sure the service continues running (if it stops running, there is a problem in your code) and if it is running, internally in the code, you need to make it do what you want to do periodically (whatever period you need).|||when i tried to build the solution i get this error:

WARNING: This setup does not contain the .NET Framework which must be installed on the target machine by running dotnetfx.exe before this setup will install. You can find dotnetfx.exe on the Visual Studio .NET 'Windows Components Update' media. Dotnetfx.exe can be redistributed with your setup.

i really need some help in getting this running.

doug, like you said i removed it from the scheduled events. i coded it as :

Dim lastrun = System.DateTime.Now.Hour
Private Sub Timer1_Elapsed(ByVal sender As System.Object, ByVal e As System.Timers.ElapsedEventArgs) Handles Timer1.Elapsed
 Dim today As DateTime = System.DateTime.Today
 If today.Hour > lastrun Then
 lastrun = today
 'add monthly charges
 Call addmonthlycharges()
 'create the html statements
 Call createstmts()
 'print the stmts
 Call printstmts()
 End If
 End Sub

so it will run every hour ( for now ) though it needs to run once a day.
i was trying to debug the program but it keeps throwing back the error :
"cannot start service from command line or a debugger. A Windows Service must first be installed (using instalutil.exe) and then started with the Server Explorer, Windows Services Administrative tool or the NET START command."

thanks|||someone...?|||anyone......|||The warning message about dotnetfx isn't a big deal. Presumably you have the DotNet framework already on your computer so it won't matter. It would only become an issue if you want to deploy your service on a server that doesn't already have DotNet. You can worry about that later...

To install the service follow the directions on that articlehttp://authors.aspalliance.com/hrmalik/articles/2003/200302/20030203.aspx">starting on this page.

You've already done this given the dotnetfx warning message. After it has built the install file (something.msi) right click on the installer project in the solutions explorer and select "Install" from the pop-up list. Either that or navigate to the something.msi file it created an double-click.

Follow the usual instructions for the install wizard.

After the install is done go to the services manager, look up the service you just installed, and start it. In principal, it should then start working and running your update at midnight.|||i can see the status of the service as "started" under services, but its not doing anything.. the prog is actually supposed to create a new folder and a few html files inside the folder and also print them.

heres the entire code :

Public Sub New()
 MyBase.New()
 ' This call is required by the Component Designer.
 InitializeComponent()
 ' Add any initialization after the InitializeComponent() call
 If Not EventLog.SourceExists("MySource") Then
 EventLog.CreateEventSource("MySource", "MyNewLog")
 End If
 EventLog1.Source = "MySource"
 EventLog1.Log = "MyNewLog"
 End Sub
 Dim FileExists As Boolean
 Dim lblmessage As String = Now()
 Dim lastrun = System.DateTime.Now.Hour
 Protected Overrides Sub OnStart(ByVal args() As String)
 ' Add code here to start your service. This method should set things
 ' in motion so your service can do its work.
 EventLog1.WriteEntry("Starting")
 Timer1.Start()
 End Sub
 Protected Overrides Sub OnStop()
 ' Add code here to perform any tear-down necessary to stop your service.
 EventLog1.WriteEntry("Stopping")
 Timer1.Stop()
 End Sub
 Private Sub Timer1_Elapsed(ByVal sender As System.Object, ByVal e As System.Timers.ElapsedEventArgs) Handles Timer1.Elapsed
 Dim today As DateTime = System.DateTime.Today
 If today.Hour > lastrun Then
 lastrun = today
 'add monthly charges
 Call addmonthlycharges()
 'create the html statements
 Call createstmts()
 'print the stmts
 Call printstmts()
 End If
 End Sub

i am sure theres no prob with the code, since i had the same code in a windows application and it runs fine. i was just trying to automate it so it runs by itself everyday...

i'd really appreciate any help in this..
thanks

Automatically create ODBC connections

Hello everybody!

I'm using the 'Data Sources (ODBC)' program that comes with windows to
create the odbc connections I need. Although that is quite fast and easy I
would like to have it more automated, since I'm using the same parameters
all the time.
Can anybody tell me (or give pointers to) how that is done?

regards
--
Johnny LjunggrenJohnny Ljunggren <johnny@.navtek.no> wrote in message news:<pan.2004.08.18.07.59.24.480484@.navtek.no>...
> Hello everybody!
> I'm using the 'Data Sources (ODBC)' program that comes with windows to
> create the odbc connections I need. Although that is quite fast and easy I
> would like to have it more automated, since I'm using the same parameters
> all the time.
> Can anybody tell me (or give pointers to) how that is done?
> regards

This article (or one of the ones linked from it) might be useful:

http://support.microsoft.com/defaul...b;en-us;Q184608

If not, you should probably ask this in an ODBC group, since it's not
really an MSSQL question.

Simon|||Den Wed, 18 Aug 2004 07:13:16 -0700, skrev Simon Hayes:

>> I'm using the 'Data Sources (ODBC)' program that comes with windows to
>> create the odbc connections I need. Although that is quite fast and easy I
>> would like to have it more automated, since I'm using the same parameters
>> all the time.
>> Can anybody tell me (or give pointers to) how that is done?
> This article (or one of the ones linked from it) might be useful:
> http://support.microsoft.com/defaul...b;en-us;Q184608

Looks like this might solve my problem. Thanks a lot.

> If not, you should probably ask this in an ODBC group, since it's not
> really an MSSQL question.

I know, but my newsprovider doesn't have any odbc-groups, so I thought
this was close enough....

--
Johnny Ljunggren

Automatic Update Not Working

SQL Server 2000. Windows Small Business Server 2003. Windows automatic
update keeps trying to install the same "critical security" update to SQL
Server Desktop Engine. Apparently it is not installing, as I find two event
s
in the event view each time. The automatic update is attempted almost every
time I log onto the server. Any ideas? The following is the event
information:
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 12/5/2005
Time: 9:54:07 AM
User: GNJPM\administrator
Computer: HQSERVER
Description:
Product: Microsoft SQL Server Desktop Engine -- Internal Error 2727.
DatabaseRepl.185C1D8F_1545_4277_BB64_857D2622DB57
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 36 35 36 35 37 43 35 {65657C5
0008: 39 2d 32 33 41 38 2d 34 9-23A8-4
0010: 39 37 34 2d 42 38 45 30 974-B8E0
0018: 2d 42 41 30 34 45 42 44 -BA04EBD
0020: 30 34 45 34 46 7d 04E4F}
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 1023
Date: 12/5/2005
Time: 9:54:07 AM
User: GNJPM\administrator
Computer: HQSERVER
Description:
Product: Microsoft SQL Server Desktop Engine - Update
'{1F506503-186B-4D88-81B3-7113B9457C9D}' could not be installed. Error
code
1603. Additional information is available in the log file C:\WMSDEHotfix.log
.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 36 35 36 35 37 43 35 {65657C5
0008: 39 2d 32 33 41 38 2d 34 9-23A8-4
0010: 39 37 34 2d 42 38 45 30 974-B8E0
0018: 2d 42 41 30 34 45 42 44 -BA04EBD
0020: 30 34 45 34 46 7d 20 7b 04E4F} {
0028: 31 46 35 30 36 35 30 33 1F506503
0030: 2d 31 38 36 42 2d 34 44 -186B-4D
0038: 38 38 2d 38 31 42 33 2d 88-81B3-
0040: 37 31 31 33 42 39 34 35 7113B945
0048: 37 43 39 44 7d 20 31 36 7C9D} 16
0050: 30 33 03
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.orgIt could be a lot of different things. Make sure your disk
space is okay. Make sure your temp directory is cleared out.
You may also want to check the following logs for more clues
as to what the problem is:
C:\WINDOWS\sqlsp.log
C:\WINDOWS\sqlstp.log
-Sue
On Mon, 5 Dec 2005 07:10:03 -0800, "Chaplain Doug"
<ChaplainDoug@.discussions.microsoft.com> wrote:

>SQL Server 2000. Windows Small Business Server 2003. Windows automatic
>update keeps trying to install the same "critical security" update to SQL
>Server Desktop Engine. Apparently it is not installing, as I find two even
ts
>in the event view each time. The automatic update is attempted almost ever
y
>time I log onto the server. Any ideas? The following is the event
>information:
>Event Type: Error
>Event Source: MsiInstaller
>Event Category: None
>Event ID: 10005
>Date: 12/5/2005
>Time: 9:54:07 AM
>User: GNJPM\administrator
>Computer: HQSERVER
>Description:
>Product: Microsoft SQL Server Desktop Engine -- Internal Error 2727.
>DatabaseRepl.185C1D8F_1545_4277_BB64_857D2622DB57
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 7b 36 35 36 35 37 43 35 {65657C5
>0008: 39 2d 32 33 41 38 2d 34 9-23A8-4
>0010: 39 37 34 2d 42 38 45 30 974-B8E0
>0018: 2d 42 41 30 34 45 42 44 -BA04EBD
>0020: 30 34 45 34 46 7d 04E4F}
>Event Type: Error
>Event Source: MsiInstaller
>Event Category: None
>Event ID: 1023
>Date: 12/5/2005
>Time: 9:54:07 AM
>User: GNJPM\administrator
>Computer: HQSERVER
>Description:
>Product: Microsoft SQL Server Desktop Engine - Update
>'{1F506503-186B-4D88-81B3-7113B9457C9D}' could not be installed. Error
code
>1603. Additional information is available in the log file C:\WMSDEHotfix.lo
g.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>Data:
>0000: 7b 36 35 36 35 37 43 35 {65657C5
>0008: 39 2d 32 33 41 38 2d 34 9-23A8-4
>0010: 39 37 34 2d 42 38 45 30 974-B8E0
>0018: 2d 42 41 30 34 45 42 44 -BA04EBD
>0020: 30 34 45 34 46 7d 20 7b 04E4F} {
>0028: 31 46 35 30 36 35 30 33 1F506503
>0030: 2d 31 38 36 42 2d 34 44 -186B-4D
>0038: 38 38 2d 38 31 42 33 2d 88-81B3-
>0040: 37 31 31 33 42 39 34 35 7113B945
>0048: 37 43 39 44 7d 20 31 36 7C9D} 16
>0050: 30 33 03

Automated script generation

I often create scripts from SQL Server 2000 Enterprise Mgr the same way: I select all tables, check Indexes, check Constraints, check Windows text, then I go. Is it possible to automate this task further, for example running the scripting from a Stored Proc?RE: I often create scripts from SQL Server 2000 Enterprise Mgr the same way: I select all tables, check Indexes, check Constraints, check Windows text, then I go. Is it possible to automate this task further, for example running the scripting from a Stored Proc?

Q1 Is it possible to automate this task further, for example running the scripting from a Stored Proc?

A2 Yes, though for some tasks (particularly with previous versions) you may have to use cursors.|||I could, fairly quickly, write a SP that reads some system tables and do the scripting I need itself.

But, is there some way to make Enterprise Mgr to do it, without really having to write a program?|||Originally posted by Coolberg
I could, fairly quickly, write a SP that reads some system tables and do the scripting I need itself.

Well, not quickly I realize, because I need to put the ALTER TABLE ... DROP CONSTRAINT statements in the proper order.
Or could I do a ALTER TABLE ... NOCHECK ALL on all tables...?

Automated Printing of Report

I have a report that I want to print. This report is invoked from a windows
app. The only thing I have been able to figure out so far is displaying the
report in a browser. Is there a way to programmatically send my report to
the printer without viewing in browser first.
I would like it to print just as it does when I preview and print from the
designer.
--
Don
--
DonHmm, the only way to print from anywhere (designer or otherwise) is to
export to another format (like PDF) and print. Printing in any other way
just prints the currently showing page. Render as PDF and print that. You
could use web services to render as PDF, save the file and then print it.
Note that with SP2 there will be client supported printing (Yeah!). Don't
know when SP2 will be.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Don" <Don@.discussions.microsoft.com> wrote in message
news:8C7AC7D1-F4CF-4EF1-BCF4-170D7610A9DF@.microsoft.com...
> I have a report that I want to print. This report is invoked from a
windows
> app. The only thing I have been able to figure out so far is displaying
the
> report in a browser. Is there a way to programmatically send my report to
> the printer without viewing in browser first.
> I would like it to print just as it does when I preview and print from the
> designer.
> --
> Don
> --
> Don|||you can print from the designer by clicking on the Preview tab and just to
the right of the page number range buttons and the refresh button there is a
print preview icon, click it and the print icon will be enabled. you can
print it from there.
"Bruce L-C [MVP]" wrote:
> Hmm, the only way to print from anywhere (designer or otherwise) is to
> export to another format (like PDF) and print. Printing in any other way
> just prints the currently showing page. Render as PDF and print that. You
> could use web services to render as PDF, save the file and then print it.
> Note that with SP2 there will be client supported printing (Yeah!). Don't
> know when SP2 will be.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Don" <Don@.discussions.microsoft.com> wrote in message
> news:8C7AC7D1-F4CF-4EF1-BCF4-170D7610A9DF@.microsoft.com...
> > I have a report that I want to print. This report is invoked from a
> windows
> > app. The only thing I have been able to figure out so far is displaying
> the
> > report in a browser. Is there a way to programmatically send my report to
> > the printer without viewing in browser first.
> >
> > I would like it to print just as it does when I preview and print from the
> > designer.
> >
> > --
> > Don
> > --
> > Don
>
>|||How about that, I've never paid attention to that. I guess since there was
no printing from deployed reports I've never paid attention to it. That's a
little embarassing. I decided to see what it did and at least for me the
print preview is totally flaky. Nothing shows, I click the print button
after the preview and then the preview shows up. I click the print button
after the print preview and cancel it and I see part of the page.
Behind the scenes it must be doing the same thing that you could do. I am
guessing that it is rendering it in pdf and showing in the embedded browser
control and then telling it to print.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Don" <Don@.discussions.microsoft.com> wrote in message
news:78D74B64-F4C7-47C9-863E-6D905AE1A3F1@.microsoft.com...
> you can print from the designer by clicking on the Preview tab and just to
> the right of the page number range buttons and the refresh button there is
a
> print preview icon, click it and the print icon will be enabled. you can
> print it from there.
> "Bruce L-C [MVP]" wrote:
> > Hmm, the only way to print from anywhere (designer or otherwise) is to
> > export to another format (like PDF) and print. Printing in any other way
> > just prints the currently showing page. Render as PDF and print that.
You
> > could use web services to render as PDF, save the file and then print
it.
> >
> > Note that with SP2 there will be client supported printing (Yeah!).
Don't
> > know when SP2 will be.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Don" <Don@.discussions.microsoft.com> wrote in message
> > news:8C7AC7D1-F4CF-4EF1-BCF4-170D7610A9DF@.microsoft.com...
> > > I have a report that I want to print. This report is invoked from a
> > windows
> > > app. The only thing I have been able to figure out so far is
displaying
> > the
> > > report in a browser. Is there a way to programmatically send my
report to
> > > the printer without viewing in browser first.
> > >
> > > I would like it to print just as it does when I preview and print from
the
> > > designer.
> > >
> > > --
> > > Don
> > > --
> > > Don
> >
> >
> >|||Have you tried installing and using the sample print delivery extension? Look
in the samples section of the Reporting Services Books Online for how to
install it. I believe it is just a sample which therefore is not supported,
and I have never used it myself.
Charles Kangai, MCT, MCDBA
"Don" wrote:
> I have a report that I want to print. This report is invoked from a windows
> app. The only thing I have been able to figure out so far is displaying the
> report in a browser. Is there a way to programmatically send my report to
> the printer without viewing in browser first.
> I would like it to print just as it does when I preview and print from the
> designer.
> --
> Don
> --
> Don|||If you use DebugLocal configuration mode and 'Run' the report, it comes
up with a specialised viewer with a print button. I believe this uses
the RS.exe command line utility - but I don't know how!
Maybe you could utilise this somehow?
Also the following link in BOL shows you how to develop your own
renderer (if you're so inclined!);
ms-help://MS.RSBOL80.1033/RSAMPLES/htm/rss_sampleapps_v1_0q28.htm
Regards
Chris
Bruce L-C [MVP] wrote:
> How about that, I've never paid attention to that. I guess since
> there was no printing from deployed reports I've never paid attention
> to it. That's a little embarassing. I decided to see what it did and
> at least for me the print preview is totally flaky. Nothing shows, I
> click the print button after the preview and then the preview shows
> up. I click the print button after the print preview and cancel it
> and I see part of the page.
> Behind the scenes it must be doing the same thing that you could do.
> I am guessing that it is rendering it in pdf and showing in the
> embedded browser control and then telling it to print.

Autoimport from xls to SQL 2000?

I have a program setup the exports check request data into a xls file every
week on a shared directory on Windows 2003 server. I'd like a way to import
that data into SQL 2000 on a weekly basis. (Shared directory and SQL on same
server).
Ideas?
just create a dts job to do it.
"Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
news:42DDB5A3-0F75-4ABE-B7D5-CBA86251AC6C@.microsoft.com...
>I have a program setup the exports check request data into a xls file every
> week on a shared directory on Windows 2003 server. I'd like a way to
> import
> that data into SQL 2000 on a weekly basis. (Shared directory and SQL on
> same
> server).
> Ideas?
>

Auto-grow option isnt working

We're using SQL2000 on Windows 2000 Server, but this is a problem
we've had on one particular database since SQL7 on NT4.

The database in question is set to autogrow by 10% (currently sitting
at 31Gb total size). However, last week users complained of a
slowdown in performance. When we checked we found that only 14Mb was
free on the database (we thought it would've grown automatically
before then), and when we added an additional 1Gb manually performance
picked up.

Does SQLServer wait until all the space is used up (i.e. 0% free)
before autogrowing? Even at that, we've never actually had the
database grow automatically - we've always had to add space manually.
Settings on this database, and one that does grow automatically,
appear to be the same (have also checked via sp_helpdb). So where
does the problem lie?

Any help you can give would be greatly appreciated.Do you have large transactions occurring in that database? If so, this KB
article might apply to your case:

http://support.microsoft.com/defaul...kb;en-us;305635

Simon

"LizP" <liz.porteous@.scottishfriendly.co.uk> wrote in message
news:8170ed5a.0306240753.1dd021f8@.posting.google.c om...
> We're using SQL2000 on Windows 2000 Server, but this is a problem
> we've had on one particular database since SQL7 on NT4.
> The database in question is set to autogrow by 10% (currently sitting
> at 31Gb total size). However, last week users complained of a
> slowdown in performance. When we checked we found that only 14Mb was
> free on the database (we thought it would've grown automatically
> before then), and when we added an additional 1Gb manually performance
> picked up.
> Does SQLServer wait until all the space is used up (i.e. 0% free)
> before autogrowing? Even at that, we've never actually had the
> database grow automatically - we've always had to add space manually.
> Settings on this database, and one that does grow automatically,
> appear to be the same (have also checked via sp_helpdb). So where
> does the problem lie?
> Any help you can give would be greatly appreciated.