Eirikur,

I changed a bit of your script but the results are not as expected.

-- THE PATTERN TO SEARCH FOR

DECLARE @SEARCH_STRING NVARCHAR(100) = N'<<search string>>';

DECLARE @SQL_STR ...

Luis,

the recomended tool is searching for objects etc but I'm looking for pieces of data somewhere in 1 or more tables within a database.

Guus

Steven,

thanks for your reply.

It is not a part of code I'm looking for (or DDL) but data stored somewhere in one on the tables/columns.

FI - looking for the name "CLARK"...

mmmmmmm

The first scan ran for several hours ending up crashing my PC......(with no results).

Retrying the same settings || Collect inventory data - IP-range - add credentials - with the same...

BL0B_EATER,

I was not aware of this MAP toolkit....

I just installed version 9 and my first scan is running.... hope this will do the trick.

Guus

Gents,

sp_configure 'remote query timeout', 0

was solving the timeout !!!

I set it on both target as source server and no timeouts anymore....

Regards, Guus

Jo,

thanks for the reply.....

Yes - ik can query through the LS and everything seems to be OK but nevertheless I experiance the TIMEOUT (after exactly 30 minutes!!).

I just found something...

LS,

After some digging (using some different terms) on google I found this artical;

http://blogs.msdn.com/b/john_daskalakis/archive/2014/09/05/how-to-install-a-service-pack-at-a-sql-server-2012-failover-instance-best-practices.aspx

PART 4 is explaning what to do in case of a failure.

The hint on waiting to...

Perry,

The manual is just explaining a direct restore (restore/overwrite on the same server) and no other options!

(restore using a different name for the database or restore to another server...

I cannot restore it with the same name on the same databaseserver and I'n not able to restore it to another server (not even with the initial name)!!

Guus

To ALL,

I think more people must be aware about the possibility using a SQL audit.

I made a first setup some months ago which I like to share......

Regards,

Guus Kramer

The Netherlands

---------------------------------------------------------------------------------------------------------------------------------------------

CREATE procedure...

Hithere,

to find out when a server is reboot I will login to this server (RDP), open a DOSprompt and type ''systeminfo |more" ..... done!

besides this I run a script...

Ten Centuries,

It is not the structure of the table what is changing but the values the PIVOT needs to create based upon values in the #source table.

I Use this structure...

@happycat59

Thanks for your reply !!

@Free_Macot

Whe you use the "ALTER DATABASE" the database will be altered but the content will not !! only the newly created objects will...

SSCrazy,

There is one main database but I'm not sure (yet) of some support databases will come along.

As you are suggesting in your reply - is there a way to change...