Forum Replies Created

Viewing 15 posts - 16 through 30 (of 147 total)

  • RE: Error while viewing reports

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

  • RE: Create a job to execute proc in all databases.

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

    You can try using sp_msforeachdb.

    sp_msforeachdb " exec procname"

  • RE: List of columns in a database

    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

  • RE: permissions

    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...

  • RE: Strange error on Server Log

    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...

  • RE: RAM Usage increasing when I use the Select Statement - Why!?

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

  • RE: Execute permission was denied

    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...

  • RE: Permission to read a file over the network

    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...

  • RE: Latest DB Access

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

  • RE: Too Many 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...

  • RE: index error

    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...

  • RE: Database logs full? But with lots of free hard disk space?

    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...

  • RE: Backup linked server

    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

    ...

  • RE: Large Table Delete 105+ Million Rows...

    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...

  • RE: New user creation

    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.

Viewing 15 posts - 16 through 30 (of 147 total)