I do not have any search index going on... so I should be good to go if I go to the link and check out the script...

thank you guys.

I will...

I like using sp_msforeachtable for certain quick and dirty works.

sp_msforeachtable as you know is a base function / sp that overloads some requests, meaning you can run other functions...

One more thing.

The XML code shows (in BI) that the encryption was set to 1 but I cannot find that anywhere in the GUI so I can change that, and,...

Hi Daniel,

You totally make sense, but, the agent is running under a service account that some half a dozen other tasks are running under.

Additionally, when the "type" is a "sql...

I will try that few hours later this afternoon..

thx

John Esraelo

the reason for asking the question number 2 was that I was playing around with the iBuySpy, I am not sure if you are familiar with that or not, and...

awesome, thx.

John Esraelo

I don't think the dbcc rebuild_log is a sql server 2005 command. I think that is one of the dbcc commands in 7.0 or 2000 version.

I could be wrong though.

John...

Thank you for the reply.

We are taking a different approach on this issue at work.

However, unfortunately I don't have the error message right now but it had something to do...

tried sp_attach_single_file_db and still did not work and honestly I wasn't expecting that work anyway, since the the DB was not DETACHED to begin with..

thank you for your help though..

I...

That's a good idea. I took over this job not too long ago and working with the CIO in placing strict policies and procedures in place.

Not having the adequate backup...

I found this undocumented statement that works real well.

sp_MSForEachTable 'sp_spaceused "?"'

This statement will return a count for each table in your database / catalog.

Make sure that your query view option...

server A = production

server B = test/development environment

server A was a VM and it was destroyed, therefore the SQL engine was gone.

The databases were on:

>>> drive XXX for data

>>>...

thank you for the reply.

I will give it a shot on Monday, thx.

JohnE

Hi,

thank you for the quick reply.

I don't think this would work since:

> new sql server and master or msdb have not clue about the mdf

> the mdf was ungracefully shutdown...