use userdb -- User-db

go

print 'print @@servername + '' / '' + db_name()'

print 'go'

go

declare @username varchar(128)

declare @Musername varchar(128)

declare @IsNtName bit

declare @sql_stmt varchar(500)

--cursor returns with names of each username to be...

http://support.microsoft.com/?id=264123 might have been the problem.

Due to production pressure, I've had to solve it with uninstall reinstall of SQL7 up to SP4 and then reattatch the db and recreate the...

grab "the best of sqlservercentral.com 2002", you'll find more info regarding this.

maybe a search on this site gets you in the right direction.

Check BOL (books online)

or

http://www.sqlservercentral.com/columnists/achigrik/lockinginsqlserver70.asp

Check your cluster log and the sqlserver-log regarding what is going on and where it fails.

with EM you'll have to script all and extra check-select script user-permissions and roles. It's not on by default and is to be found on the same tabpage where you...

<But I thought that the real reason for this thread was that the job got stuck?>

No, that reason is known (user32.dll cannot be initialized ... related to MS KB-article).

After upgrade...

Sets see : 1 instance with 1 db returns in 1 second.

1 instance wit 190db's takes way longer.

Your 1-190-instance has to manage 190 db's (with at least 2 files) and...

the delay is 0 because that's what the users want ! I know that can cause problems, but I'm not alowed to alter this to a more reasonable figure.

The reason...

Now there a litle bell ringing somewhere...

I didn't realize you were using linked tables from access to sqlserver. In that case, access usualy will try to solve the query by...

Sqlserver is an advanced database engine !

Access is one of the ancestors. If you want to optimize it you can try to apply the same guidelines you would use...

If your data is numeric, store it in a numeric typed column. This will requier more work if your data-requierment changes, but it's a good practise to type your data...

Viewing the responses, you 'll notice that you'll have to test your solution !

My default is to put a clustered index on a table and to remove it if it...

When the package's job goes wrong, what's it saying in the jobs jobhistory ?

check the job-owner. Don't use a windows account as job-owner, it might fail with authentication-check.