Tuesday, March 27, 2012
can not expand table group in internet explorer
I hope one of you encountered this problem..
I have grouped fields on one table object in some report.
In visual studio all is well i can expand the grouping fields to see thier
children and thier data.
The problem appears in internet explorer - under no sircumstances will this
group expand there!
I am left with the upper most grouping field and can not drill down to its
members!
I have tried both to define these aggregating fields by my self
and by the vs wizard . Also i tried the matrix component instead of the
table one.
One interesting fact is that once exported to excell, things return to
normal again..
I can expand groups and drill down correctly.
I have installed sp1 for reporting services and use ie6 on winxp
professional (both client and server).
If you did not encounter this before where will you start looking'
Thanks for your attention
ReaThe driil down capability requires Session cookies be enabled. Change the
Internet Explorer setting to "Allow Session Cookies" and it should work
"Rea Peleg" <rea_p@.afek.co.il> wrote in message
news:uQfy2B8bEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Hey all
> I hope one of you encountered this problem..
> I have grouped fields on one table object in some report.
> In visual studio all is well i can expand the grouping fields to see thier
> children and thier data.
> The problem appears in internet explorer - under no sircumstances will
this
> group expand there!
> I am left with the upper most grouping field and can not drill down to its
> members!
> I have tried both to define these aggregating fields by my self
> and by the vs wizard . Also i tried the matrix component instead of the
> table one.
> One interesting fact is that once exported to excell, things return to
> normal again..
> I can expand groups and drill down correctly.
> I have installed sp1 for reporting services and use ie6 on winxp
> professional (both client and server).
> If you did not encounter this before where will you start looking'
> Thanks for your attention
> Rea
>
>
Sunday, March 11, 2012
Can LOG PI or Log Explorer recover deleted records BEFORE
the Database (.mdf), Recovery Model Set to Full, and there has never
been a backup of the Log (.ldf) files?
Using the trial software for both, this was unclear.
Thank you for your time,
bd"bd420" <bd420@.hotmail.com> wrote in message
news:1136940831.527840.99440@.o13g2000cwo.googlegro ups.com...
> installation of their softwares? If there has NEVER been a backup of
> the Database (.mdf), Recovery Model Set to Full, and there has never
> been a backup of the Log (.ldf) files?
My understanding is that as long as you have NOT truncated your log file the
answer should be yes.
> Using the trial software for both, this was unclear.
> Thank you for your time,
> bd|||bd420 (bd420@.hotmail.com) writes:
> installation of their softwares? If there has NEVER been a backup of
> the Database (.mdf), Recovery Model Set to Full, and there has never
> been a backup of the Log (.ldf) files?
> Using the trial software for both, this was unclear.
I believe the answer is no. The key here is that you have never taken a
backup of the database. As long as you have done that, the log works as
if you were in simple recovery. After, a log is supposed to be applied
to a database back, so if there isn't any...
But hadn't it been for this fine detail, the answer would be yes. That
is, there is a full backup taken some time, and you are running in
full recovery.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Friday, February 24, 2012
Can I turn off or speed up the animation in SSMS?
Is there any way to speed it up or turn it off? It's really impacting my producitivity.
Thanks!
--Wayne
P.S. And never ,never introduce me to the bonehead who put all the animation into Windows and defaulted it to "on" !!!
amen.
I would also LOVE to know if turning the animation off is possible.
|||[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools
\Shell\General]
"Animations"=dword:00000000
|||[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools
\Shell\General]
"Animations"=dword:00000000
|||will this help load time?
it takes a full 2 minutes to launch for me, Pentium M 1.8 with 1gb ram
it really pisses me off that I can't use SQL Server Management Studio
Express
I mean-- come on Microsoft (it complains about not being able to install it
since it's already got the full version)
"Sean" <seangorman@.yahoo.com> wrote in message
news:1178134650.847409.151260@.q75g2000hsh.googlegr oups.com...
> [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools
> \Shell\General]
> "Animations"=dword:00000000
>
|||to speed up load time try this:
change the launch shortcut to this:
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell
\Common7\IDE\SqlWb.exe" /nosplash
Also go to tools, options environment, general Change dropdown to
"Open Empty Environment"