@ starsthescqw: You are welcome

@ Edwin-376531:

- Have you ran the scripts listed above on your server? (ignore this, I just reread your post)

- I cannot identify the object 'syssextendedarticlesview’...

1. Have you tried recreating the TempDB?

2. Have you looked at excessive Disk fragmentation

It is strange that it is happening on the TempDB as the TempDB is more just...

Hi,

Not really, we eventually upgraded to SQL 2005.

On the flip side, I did try this in a lab by manually changing DLL's and so forth and reverting to old system...

I only noted the issue when we were trying to reinstated replication. The server use to perfrom transactional replication some time back but it was removed. Now when we were...

Hi Guys,

I know that is is an old topic, but the net does not seem to come up with an easy solution. After playing around for a bit I managed...

Hiya,

On the SQL server under the System Properties|Advanced tab you need to configure the follwoing system variable (under environment variables)

Variable = USERNAME

VALUE = SYSTEM

Then run the query.

xp_cmdshell 'SET USERNAME'

But the environment variable USERNAME needs to be set, try running the "SET" command from the command prompt and you will see other environment variables you can query....

The customer decides that after 4 months of the server being in production, the application has an issue with SQL2k Sp4. It seem to me a badly designed app. Most...

Thanks guys, for now I have downloaded the eval and also ordered the disks from Microsoft. It is sad that you can't actually download it...

Man, There is a so much more easier way to do this, here is what I do...

1. In Query Analyser, ensure that your results target...

Mate,

I really feel for you, but at least every DBA has done this sometime or the other. I have learn't a lesson from this and I ensure that every...

Hi,

It is a business based database, but will only be utilised between 6am - 6pm, with really high usage levels. Current recovery mode is set to simple. We do clear...

Mate,

You can use Perfmon, Select:

Databases: Percentage Log used,

you can set this against individual or all.

Also try sp_spaceused it might hlp.

Thanks everyone, it works like a charm....