Hi Brian,

as a follow-up regarding our tweets and to share this information to other users as well (maybe they´re having an idea):

If we have a user who has only the...

Thx a lot.

I already found it by searching in all your posts as well. 🙂

I´m looking forward to read the full article.

Your solution has a great potential and it´s...

It seems that this forum entry does not...

Hi all,

just a quick hint concerning the change of the proc using xp_dirtree instead of xp_cmdshell.

You have to modify the string

INSERT #dirpaths values('')

to

INSERT #dirpaths values('','','')

Otherwise you get an...

Hi Rich,

thanks for the reply.

The "problem" is that there is only the primary filegroup. With a small mdf and a big ndf.

so, there is no separation between system tables and...

Hi,

thanks for the replies so far.

Well, the local groups created by SQL Server are still there and no one´s orphaned.

If I try a new local user account with no special...

Hi,

maybe the developers can disclaim encryption and use a separate column for the records where they place a checksum jsut to make sure that no data were changed.

We will see.

Thx...

Hello again,

finally I´ve found the time to get more information.

In the end nothing changed...

The dba team and I have to ensure that no data can be manipulated, e.g. not changing...

Thx @ all for the advise so far.

I will try to get some more information from the developers next week, not only via a third person all the time.

Regards

Dirk

Thanks for the replies so far.

Well, it is quite difficult to explain the situation. The external developers made their SLAs and they do not trust the dbas.

So even the dba...

Hi again,

although my issue is nearly one year old a colleague and I still experience the problem.

What I did last week was to install two new instances beside the existing...

Hi again,

thank you all for your advise.

Now I have the script up and running.

Since the script isn´t that good to be placed in the SSC script section, I will post...

Jeffrey Williams (2/21/2009)

---

To get this to work from msdb - you would have to use dynamic SQL in your procedure. You would pass the database name to the procedure,...

I am still confused, but on a much higher level right now....

It is not possible for me to just set a use @dbname inside the proc. The use database statement...

Hello Jeffrey,

now I begin to understand.

I will give it a try to put the dbname into the proc dynamically. I suppose here in this forum I'll find some good...