Thank you for your reply! The file extension is .trc

Thank you for your reply!

I created a log file so I can have further information regarding the error messages and I found the following error when running the following data...

Taking the database "offline then "online" again seems to fix the issue.

Thank you for your reply, I'm running the following sql permission query which works fine on all other servers, the only difference is that a few of the databases have...

It works fine when it is just 1 query but when I add more queries then that is when I get the error messages, I tried the following query and...

Sorry, here is the error message:

Msg 105, Level 15, State 1, Line 41

Unclosed quotation mark after the character string 'Win'.

Msg 102, Level 15, State 1, Line 41

Incorrect syntax near 'Win'.

Msg...

I tried to run it on the following script but I get an error message:

create table #temp(

DatabaseName varchar(100),

[UserType] varchar(100),

[DatabaseUserName] varchar(100),

[LoginName] varchar(100),

[PermissionType] varchar(100), ...

Thank you for your help!

Thank you very much that seems to have worked!

I have tried "foreachdb but I'm unable to get any results at all, all I get is "Command completed successfully"

running the following script:

EXECUTE master.sys.sp_MSforeachdb 'USE [?];

'DECLARE @sql VARCHAR(8000)

SET...

Sorry to be a pain but I have the following script but I'm unable to get the result, would you please let me know where I'm doing wrong:

EXECUTE master.sys.sp_MSforeachdb 'USE...

Thank you for your reply!

I'm trying to get some information on permissions on each databases on the server but I'm trying to get a way of retrieving the information in...

Thank you for your help! I’ve tried to run the scrip but unfortatly I get the following error message, I have changed the location name where the transactional log file...

The database will be in "Stand by/Read only" but my problem is that if something goes wrong then I would not want the job to try and restore from the...

Thank you for all your replies!

I get a transactional log file from another server which is not d not done by log shipping, it is just a job which runs...