Tried to connect with DAC, but encountered problems.

BOL states that "The connection is only allowed from a client running on the server. No network connections are permitted."

What that means? that...

Yes, I just also found it. So it does not look as a solution?

That's interesting idea, thank you.

But if I try to :

backup database [Resource]

to disk = 'i:\backup\resource.bak'

I get the following error:

Msg 911, Level 16, State 11, Line 2

Database 'Resource' does not...

Thanks for your patience, Mister Magoo.

There was a long holiday weekend, and now I am back to my problem.

If you look inside the file ssms.exe.config, there id a node called...

Thanks for quick reply. Here is what I tried to do:

I found that extensions folder is actually installed in SQL Server directory:

C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Extensions

and it has sub-folder named...

Contact Steve Jones - he is admin of this site. We always have various surveys here.

Thanks for 1st tip, Phil. Rollup works for me, however with some changes to order by clause.

But about the 2nd tip, this is not exactly BOL that I expected. I...

I guess that my workspace is remote on the server.

It created another database in Analysis Server with a long name like <dbname>_myUserName_letters_and_numbers.

The size of the source database in SQL...

But who is using sp_helptext in SQL scripts anyway? All DBA's are using

select definition from sys.sql_modules

where object_id = object_id('cProcWithLongStrings')

for any scripting.

For using any S.P. that returns values, you...

use master

go

select type_desc, name

from sys.objects

where is_ms_shipped =0

So did you actually restore it, or just attempted to restore?

Did you use MOVE clauses to place...

begin try

drop table #errorLog

end try

begin catch

end catch

CREATE TABLE #ErrorLog (

LogDate datetime,

...

Thanks again.

Here is the query that I came up with:

select f1.Operation,

f1.AllocUnitName,

f1.[Page Id],

...

Thanks, Gail. That's good advice. So I used fn_dblog(null,null) and DBCC log. They are pretty much identical, however the former is better because I can apply Where clause.

But my next...

Thanks. I liked your joke, Alvin.