Frank,

We use simular server as you describe but I never heard the highest CPU number is used for the OS....

SQL uses the assigned memory very flexable.

On dedicated servers we use...

Hi,

The first thing what comes in mind is your serverload (what is running on the same time (jobs, backups, SUS, Virus scanning, etc.). Try to find out what is happening.

Second...

To share some knowledge;

(taken from nij own notes)

Hopes this helps you guys...

Guus Kramer,

The Netherlands

8888888888888888888888888888888888888888888888888888888888888888888888888888888888

Move orphaned users from server A to B

1. Run...

dave,

If you want to know what and how inside SQLserver search BOL (2004) for "Monitoring Memory Usage".

if you want to know about system behaviour I can recommend SPOTLIGHT on SQLserver...

use the KISS principle;

Why not use; select TOP 1.... / order by Calldate ?

Guus

Noelson,

Brief answer on your question:

When restoring ( overwrite ) a database all excisting logins will be disconnected from the security-logins  to the database ( before the actual overwrite). The backup mechanism...

Markus;

... it makes absolutely no sense

I totally agree on this...Sometimes I do not understand the Microsoft way !!!

We installed it and default the Db was set to 4 GB and...

David,

Eventualy it seems to be a permission problem.

Its was not the Windows authentication neither the IIS operant authentication but the SQL user and password using the FORM settings (...

Noelson,

You probably dealing with orphaned users which popup after a restore of you database.

There are serveral way of how to solve this;

Manualy - delete them from the database user list and reconnect...

Svetlana,

I know the purpose and use of sp_execute SQL but....

....my question is why this mechanisme is that slow comparing to a 'normal' parse through SQL Analyzer.....

....What does it do???....

....I know for...

for all who are interested.... see page 248 and up.

Thanks Frank...

GKramer

Hi,

Something new is something to investigate....

selecting some IOlatches  (select * from sysprocesses) and using these waitresource numbers for executing

dbcc traceon(3604)

dbcc page(9,1,15805,1)

gave a lot of results but can anyone tell me...

hi,

It seems to be either an old MDAC or a security problem ( is the user granted to execute xp_cmdshell and does he have privs to access the files )....

Assume restarting 50 production SQL servers to update a Extended Stored procedure. That's the main reason i cannot restart the SQL server.

Once in a while you have to...

I agree with Phil and bljblj.

Use a VPN connection and (A)DSL / UMTS and take over you client on the office.

I work like this for some years now and this saves...