how to remove trace flag in startup option

Hi,
I am having a problem and please help. I tried to add a trace flag -g512 to
our sql 2005 sp2 clustered instance. I added to the startup parameters line
of the SQL configuration manager, something like this:
-dT:\Microsoft SQL Server\msql\MSSQL.1\MSSQL\DATA\master.mdf;-eT:\Microsoft
SQL Server\msql\MSSQL.1\MSSQL\LOG\ERRORLOG;-lT:\Microsoft SQL
Server\msql\MSSQL.1\MSSQL\DATA\mastlog.ldf -g512
after this I cannot get SQL started up. And I tried to manually remove this
flag from registry and sql does not start. When I looked at the registry, it
is back again. Please help.
Thanks very much.
BrianThe options need to be separated by semi-colon. Look at that last option. SQ
L Server will try to use
for the master database log file a file named: "mastlog.ldf -g512". Set a se
mi-colon after the file
name.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
news:B5B10076-C531-43FC-A627-1355455320F2@.microsoft.com...
> Hi,
> I am having a problem and please help. I tried to add a trace flag -g512 t
o
> our sql 2005 sp2 clustered instance. I added to the startup parameters lin
e
> of the SQL configuration manager, something like this:
> -dT:\Microsoft SQL Server\msql\MSSQL.1\MSSQL\DATA\master.mdf;-eT:\Microsof
t
> SQL Server\msql\MSSQL.1\MSSQL\LOG\ERRORLOG;-lT:\Microsoft SQL
> Server\msql\MSSQL.1\MSSQL\DATA\mastlog.ldf -g512
> after this I cannot get SQL started up. And I tried to manually remove thi
s
> flag from registry and sql does not start. When I looked at the registry,
it
> is back again. Please help.
> Thanks very much.
> --
> Brian|||Thanks Tibor,
I added a semi colon, and saved OK. when I tried to bring SQL online, it
failed. And I checked again in configuration manager, it is back to where it
was (without semi colon). Can you please help again? Maybe help me to get
this flag removed first?
Thanks.
Brian
--
Brian
"Tibor Karaszi" wrote:

> The options need to be separated by semi-colon. Look at that last option.
SQL Server will try to use
> for the master database log file a file named: "mastlog.ldf -g512". Set a
semi-colon after the file
> name.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
> news:B5B10076-C531-43FC-A627-1355455320F2@.microsoft.com...
>
>|||Here is the error:
2007-11-30 09:54:43.45 spid5s Unable to open the physical file
"T:\Microsoft SQL Server\msql\MSSQL.1\MSSQL\DATA\mastlog.ldf -g512".
Operating system error 2: "2(The system cannot find the file specified.)".
Thanks very much.
Brian
"Tibor Karaszi" wrote:

> The options need to be separated by semi-colon. Look at that last option.
SQL Server will try to use
> for the master database log file a file named: "mastlog.ldf -g512". Set a
semi-colon after the file
> name.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
> news:B5B10076-C531-43FC-A627-1355455320F2@.microsoft.com...
>
>|||The semi-colon is probably removed by the cluster handling. Does it work if
you use the SQL Server
Configuration Manager application (which I assume is cluster-aware)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
news:4167E684-0A13-4358-BAE1-58B30E6288AD@.microsoft.com...[vbcol=seagreen]
> Thanks Tibor,
> I added a semi colon, and saved OK. when I tried to bring SQL online, it
> failed. And I checked again in configuration manager, it is back to where
it
> was (without semi colon). Can you please help again? Maybe help me to get
> this flag removed first?
> Thanks.
> Brian
> --
> Brian
>
> "Tibor Karaszi" wrote:
>

How to reduce white space when object is hidden?

The report is made of one list containing 2 tables, one below each other.
Depending on the report parameters, the bottom table is made visible or
hidden.
When that table is hidden at run time, RS still reserves the same amount of
white space that the table takes in the report design layout.
This causes RS to render an extra white page at the end of the report where
it would display the table. Since the table is hidden, nothing is displayed
in this extra white page.
Does anyone know a workaround that would prevent the white page at the end
of the report?Hi Pat,
Thanks for your post.
From your descriptions, I understood the report will reserve some the
space for that hidden table when there is two tables in the Report. If I
have misunderstood your concern, please feel free to point it out.
I have tested on my side but it seems RS won't reserve the place for hidden
objects. Would you please show me a sample with AdventureWorks, with which
I could reproduce it on my side?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Did you try the scenario where both table are contained in one list?
"Michael Cheng [MSFT]" wrote:
> Hi Pat,
> Thanks for your post.
> From your descriptions, I understood the report will reserve some the
> space for that hidden table when there is two tables in the Report. If I
> have misunderstood your concern, please feel free to point it out.
> I have tested on my side but it seems RS won't reserve the place for hidden
> objects. Would you please show me a sample with AdventureWorks, with which
> I could reproduce it on my side?
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Pat,
Thanks for your patience.
If you set the visibility like this:
<Visibility>
<Hidden>true</Hidden>
</Visibility>
This means that the table is always hidden. The space is preserved for
always hidden items. If you changed visibility according to Expression, it
will not reduce the white space.
However, I have tested the scenario that both table are contained in one
list as you described. It will do leave the blank and I am afraid currently
we cannot eliminate this behavior.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

How to read database compatibility level from c#

I'm trying to access the db compatibility level of a database from c# code.
If you execute sp_dbcmptlevel with no parameters, the current level is
returned to the output stream. My problem is how to get at this from c#
since it is not a scalar or tabular result. Any help gratefully received
JamesLook like it's returned via raiserror(). You need to catch it via
InfoMessage.
http://msdn.microsoft.com/library/d...ctionEvents.asp
-oj
"James E. Clarke" <james@.r> wrote in message
news:OacPMeLOGHA.2268@.TK2MSFTNGP09.phx.gbl...
> I'm trying to access the db compatibility level of a database from c#
> code. If you execute sp_dbcmptlevel with no parameters, the current level
> is returned to the output stream. My problem is how to get at this from c#
> since it is not a scalar or tabular result. Any help gratefully received
> James
>