Hi

You could try the simple approach of creating a table that the stored procedure can use to store the data temporarily. Then get the stored procedure to insert into that...

Hi Gail

Thanks, in that case there's definitely no replication.

A further search, leading from the checkpoint issue I described above has dug up this hotfix.

I've downloaded the hotfix, and will...

Hi Jeffrey

Thanks for the information about vlfs - very useful. I've shrunk the file down and reallocated space for it to remove the disk fragmentation that must have occurred during...

Hi

I've run it just now, earlier today before I posted here, and a month ago when I first noticed the problem and the result is always the same: "No active...

Hi Gail

Thanks for replying so soon!

According to both Enterprise Manager and sp_helpdb, the recovery model is simple, so I'm a bit mystified as well as to why running the ALTER...

I'd second the idea of using ISO date formats - it's what I usually do as I work on en-gb servers all the time. However, another possible solution is to...

We use all 3, depending on when the initial application was set up.

We have started moving some databases from 2000 to 2008 Express, but if a full version of...

Regarding the second point, despite some claims to the contrary, it is possible to install SQL 2000 on Vista. See Michael Imhoff's blog for details.

The other option is to install...

Hi

Thanks for responding. I've done some more digging and the CPU shows positive values for a few SP:StmtCompleted events (reads show zero for those, even though they contain select statements)

The...

Hi

I should probably have said I'm using the 2000 version of SQL Profiler, and running it on the same server that I'm looking at.

On closer inspection I do in fact...

It certainly is weird. Rebooting has no effect on the situation, and part of the problem is I don't know when it started happening either. I'm guessing whatever it is...

Hi

How did you get on? I finally found the instance name for my machine in that setup files folder I mentioned. It's in the one ending in SQL.log (quite a...

Hi

You can find the instance name from the registry if you have access to that, at HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL. It may also be possible to find it in one...

Hi

I take it then you've tried registering the MSDE server in EM, or using Connect > Database Engine from MS. So when you say you can't see it, do you...

Hi

The services that start with MSSQL$ and SQLAgent$ relate to MSDE databases as you suspected. The SQL Express server is, by the looks of it, a named instance with instance...