Gail, thank you for the suggestion.

Run DBCC CheckDB('My Database') WITH NO_INFOMSGS

Gary

OK, Stupid me!

The database has over 4,000 objects in it and when I scrolled through the results of the dbcc checkdb I did not see any errors.

However, after posting this...

I figured it out.

Well, the solution is to add the user as a sysadmin and then they can see the configuration files.

Now I don't like this solution because the user...

Thank you for the reply.

Update on this adventure.

I have created all the folders I need to based on a list I generated from a SQL table.

FOR /F %i in (E:\documents\folderlist.txt) do md "%i"

Now I...

I have now restarted the server and the problem is no longer appearing.

I don't know what caused the issue but for now it is no longer an issue.

Gary

I am now experiencing the same issue.

its a sql 2005 9.00.5296 SP4 running on a windows server 2003 r2 enterprise edition.

Can anyone validate the solution that was recommended?

Thank you for the reply.

xp_cmdshell is disabled and our policy is to keep it disabled.

For SSIS I have no experience with SSIS.

Well,

I sucked it up and restarted the server.

It rebooted and the SQL server service started and all the other SQL related services that I need have started as well.

So...

Do you have any links you would be willing to offer up on the how to do this?

Thanks

Gary

Sorry for the delay. I have just now been able to get back to this.

I have two screen shots, one from Internet Explorer and one from Chrome.

In I.E. the report...

Thanks for the reply but

I had increased the width of the column many times in a effort to resolve the problem, before I posted my question.

Gary

Unfortunately we are using mixed mode authentication.

I have put in a request to the boss to change the application so that it will use windows authentication but that was not...

This is what the event viewer shows

Event Type:Information

Event Source:MSSQLSERVER

Event Category:(4)

Event ID:17055

Date:7/18/2014

Time:11:55:22 AM

User:N/A

Computer:<Server Name>

Description:

18456 :

Login failed for user 'sa'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I have...

First let me say think you to both of you for your responses.

The TRIM(SUBSTRING([description],1,LEN([description])-1))

Worked as I hoped it would.

However, I would like to know why the Replace(right(description,1),'-','') did not work.

I...