Viewing 15 posts - 16 through 30 (of 147 total)
Anyone has faced this error? Any input will help me greatly troubleshoot the error.
March 23, 2008 at 10:35 pm
Does the stored procedure exists in each of the 40 databases.
You can try using sp_msforeachdb.
sp_msforeachdb " exec procname"
March 11, 2008 at 7:23 am
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
March 4, 2008 at 7:13 am
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...
February 27, 2008 at 9:04 pm
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...
February 26, 2008 at 5:49 am
Whats the structure of the table? How much data is in the table?
January 18, 2008 at 8:13 am
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...
January 17, 2008 at 10:13 am
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...
January 14, 2008 at 1:41 am
Well there is no specific way you can get this. Probably you can run a profiler check for the activites against the databases.
January 9, 2008 at 1:34 am
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...
November 6, 2007 at 8:44 pm
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...
November 1, 2007 at 9:50 pm
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...
November 1, 2007 at 9:43 am
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
...
October 31, 2007 at 8:22 pm
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...
October 30, 2007 at 11:50 pm
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.
October 30, 2007 at 11:35 pm
Viewing 15 posts - 16 through 30 (of 147 total)