I don't think Simple recovery is advisable in a production environment. Then you'll only be able to  recover to a specific backup, not to any point in between backups, because...

Double check that they are in "Users" list of the database. Sometimes this gets corrupted, and you have to drop the login & recreate it.

" ..... The user used to use sa ..... "

I assume this isn't allowed anymore ?   The sa password should be secure & available to the DBA only

When you say WA seems slower, are you referring to the intial connection time, or response time during the day while running apps ?   

If a user could have a NULL default database, then why bother having the user in SQL at all ?  If they have a login account, then that assumes they...

This won't help you now ... but ....

Every time a deleoper has a stored proc to go to production, I script out the current production one,  so I have a...

According to BOL, Monday is 1, so the results you're getting are correct.

In Enterprise Manager, you always have to click "REFRESH" in order to see the current list of Stored Procedures, Tables etc ...    Perhaps that's why you don't see the new...

You're getting "SET USER" in your generated script ??     I never get that.  I just tried logging on as a "user", and I still don't get "SET USER"

This version posted earlier doesn't work properly:

DECLARE @a NCHAR

SET @a = '-'

SELECT datalength('a1sdsad12---325143gffdfd4dgsf1 -')

      -

      datalength(convert(varchar,REPLACE('a1sdsad12---325143gffdfd4dgsf1 -',@a,'')))

It returns the right result in this case, but if you search for...

Here's 1 idea:

This selects every 6500 th record, using an identity field

SELECT fielda, fieldb, fieldc

        FROM TabRele_Name

                     WHERE Identityfield % 6500 = 0

This selects JUST the 6500 th record, using the...

I think I renamed the .pst file, and then it created a new one which fixed the problem.

How do you subscribe to QOD ?

I'm undecided ......  I was going to go, but our company's in "cost saving" mode .... so I thought I'd do my part & skip it

Remi,  you're a first year programmer, with 4400 posts !!      You've had some pretty good ones, so you must be picking this stuff up pretty quickly !   Time to ask...