Anyone has faced this error? Any input will help me greatly troubleshoot the error.

Does the stored procedure exists in each of the 40 databases.

You can try using sp_msforeachdb.

sp_msforeachdb " exec procname"

Try this

select table_name,column_name,data_type from information_schema.columns where table_name not in (

select name from sysobjects where type='v') order by table_name

Well if all the procedures belong to one schema lets say dbo then you can give the execute permission on the schema. This way you will not have...

Whic version of lite speed you are using. Earlier versions of lite speed had these issues but it has been resolved in the latest version. Also what is the value...

Whats the structure of the table? How much data is in the table?

Well if all the procs belong to the same schema then you can grant execute to the user on the particular scehma and then the user will have execute permission...

The sql login created by you or for that matter sa would not have access to the network resource. So whenever you run the job you get the access denied...

Well there is no specific way you can get this. Probably you can run a profiler check for the activites against the databases.

Well I have servers which have more than 100 databases on it. It all depends on the kind os server you have in terms of CPU,memory,disk I/O.

So you need to...

Well the insert/update will fail if the total length is greater than 900. So in your case this will fail again since you created it on a column with length...

Well I would suggesst turnig off the autoshrink option as the first step.

Secondly how is the log growth set up.

If this is in percentage then it could be a...

Here is the script which I got from here only.

--Script to script out all linked/remote servers

--Works on 7.0 and 2000 servers

--remote password decrypt only works on 7.0

declare

...

Well I would go by the approach of putting the database into simple recovery and then performing the deletes. This way the log won't grow to huge proportions. once the...

For creating the login

Exec sp_addlogin 'SRETLD','password'

To add the user

EXEC sp_adduser 'SRETLD'

Note:--Only members of the sysadmin and securityadmin fixed server roles can execute sp_addlogin.