Hi LN,

You need to tick the 'Automatically grow file' checkbox on the Transaction Log tab of the tempdb properties.

Be aware that if you do this & you have massive queries filling...

Hi,

Ok, tracked it down to a combination of varbinary & image columns in the table.  It appears that once these are excluded from the query the response is < 1...

Take a look at http://www.netiq.com for their NetIQ SQL Management Suite ( AppManager, ConfigurationManager, DiagnosticManager & RecoveryManager )

We use this toolset & it works very well.

j

p.s remember to mention i...

Hi Stef,

We have exactly the same issue on Win2k SP4 + Sql 2k SP3a.  Two instances running on this server, neither is a 'default' instance.  When you look in the...

Hi SSW,

As a footnote to this, I had a recent scare when I tried to relocate our master db datafiles onto a non existent drive using the Startup Parameters ( was...

Hi jenniferhu46,

We are experiencing exactly the same issue !, anyone know what 'dbghelp.dll' does & why something might trigger trying to use it ?. 

Thanks in advance.

j

Help,

Anyone got any ideas ?, anyone experienced issues after patching the MDAC ?

j

Hi, perhaps you can use 'xp_logevent' to generate an entry in the Sql Log file or the Windows Event Viewer ?. Regards, j.

Take a look at BOL: Microsoft® SQL Server™ encrypts or can encrypt: Any data sent between the client and the server as network packets etc etc, but has...

Care to elaborate on your process jeffwe ????

Take a look at NetIQ [ http://www.netiq.com ] & their Sql Server Management suite. Regards j.

Hi Paul, Allen's reply got me thinking, did you mean you wanted to relocate a Db log file or the Sql Error Log file ????. j

Hi Paul, The way i do this ( may not be the best way, but it works ! ), is to backup the database & then use a script to...

Oh yeah, forgot to say ( my disclaimer ! ) that the steps I posted don't always work 100% as it all depends on why the Db was marked suspect...

Hi mj, here's what i normally do; (1) In QA point to 'master' db (2) Run: sp_configure 'allow updates', 1 (3) Run: reconfigure...