Duplicate instances

On one box Enterprise Manager is indicating a second instance â' . (Windows
NT)â' , in addition to the default instance, â' (local) (Windows NT)â'. This
second instance was not installed, It just appeared. The MSSQL directory
indicates the presence of only one instance. Databases, and security
configurations are identical in structure and information between the two
instances. Has any one seen this happen? Would you recommend deleting the
â'Ghostâ' instance. Any ideas welcome. Thanks to everyone for being there to
help. SQL 2000 SP4.coenzyme wrote:
> On one box Enterprise Manager is indicating a second instance â' . (Windows
> NT)â' , in addition to the default instance, â' (local) (Windows NT)â'. This
> second instance was not installed, It just appeared. The MSSQL directory
> indicates the presence of only one instance. Databases, and security
> configurations are identical in structure and information between the two
> instances. Has any one seen this happen? Would you recommend deleting the
> â'Ghostâ' instance. Any ideas welcome. Thanks to everyone for being there to
> help. SQL 2000 SP4.
>
You can safely delete either one - registrations in EM have no effect on
the actual instances that are running.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks Tracy. It's a real comfort to know there's experienced people like you
who are willing to help.
"Tracy McKibben" wrote:
> coenzyme wrote:
> > On one box Enterprise Manager is indicating a second instance â' . (Windows
> > NT)â' , in addition to the default instance, â' (local) (Windows NT)â'. This
> > second instance was not installed, It just appeared. The MSSQL directory
> > indicates the presence of only one instance. Databases, and security
> > configurations are identical in structure and information between the two
> > instances. Has any one seen this happen? Would you recommend deleting the
> > â'Ghostâ' instance. Any ideas welcome. Thanks to everyone for being there to
> > help. SQL 2000 SP4.
> >
> >
> You can safely delete either one - registrations in EM have no effect on
> the actual instances that are running.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Duplicate instances

On one box Enterprise Manager is indicating a second instance “ . (Window
s
NT)” , in addition to the default instance, “ (local) (Windows NT)”.
This
second instance was not installed, It just appeared. The MSSQL directory
indicates the presence of only one instance. Databases, and security
configurations are identical in structure and information between the two
instances. Has any one seen this happen? Would you recommend deleting the
“Ghost” instance. Any ideas welcome. Thanks to everyone for being there
to
help. SQL 2000 SP4.coenzyme wrote:
> On one box Enterprise Manager is indicating a second instance “ . (Wind
ows
> NT)” , in addition to the default instance, “ (local) (Windows NT)”
. This
> second instance was not installed, It just appeared. The MSSQL directory
> indicates the presence of only one instance. Databases, and security
> configurations are identical in structure and information between the two
> instances. Has any one seen this happen? Would you recommend deleting the
> “Ghost” instance. Any ideas welcome. Thanks to everyone for being ther
e to
> help. SQL 2000 SP4.
>
You can safely delete either one - registrations in EM have no effect on
the actual instances that are running.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks Tracy. It's a real comfort to know there's experienced people like yo
u
who are willing to help.
"Tracy McKibben" wrote:

> coenzyme wrote:
> You can safely delete either one - registrations in EM have no effect on
> the actual instances that are running.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Dundas Question

Are there more opportunities to use expression-based chart configuration with the Dundas charts? With the default charts, you are most limited to hard-coding your chart.

With Dundas, can you choose 3D or 2D based on an expression?

Can you choose chart styles based on expressions (e.g. cones verse bars)?

Can you choose chart types based on expressions?

Thanks,

Michael

Still hoping for an answer on this.|||

Shouldn't you just check this out at the source? Their docs are online

http://support.dundas.com/OnlineDocumentation/RSChart/webframe.html

You'd see some cool stuff, for example

http://support.dundas.com/OnlineDocumentation/RSChart/CodeEditor.html

Something tells me you can't switch chart type programmatically, and therefore not by expression, though.

>L<

Dumping sql server

BACKUP DATABASE?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"John" <John@.nospam.infovis.co.uk> wrote in message news:eoAZqSDhHHA.4552@.TK2MSFTNGP04.phx.gbl...
> Hi
> Is there a way to dump all the sql server data into some sort of file that
> can be imported into a local sql server later? I have used sql server dumper
> but it is not very stable and crashes during sump.
> Thanks
> Regards
>
Hi John
"John" wrote:

> Remote, does not work for some reason possibly insufficient rights.
>
If you want to post the command you are using it may help? Also the full
error message would be useful. If you want the backup to be placed on a
different server you can use a UNC path. Make sure that you also have
directory permissions as well as server/database permissions sysadmin,
db_owner or db_backupoperator. See BACKUP in Books Online for more.
Databases can also be detached and attached, it is usually best to attach
the database to an instance at the same service pack/hotfix number, but SQL
2000 databases can be attached to SQL 2005 instances, although you may have
to change incompatibilities if you want to use the latest compatibility mode.
If you are changing instance you will need to script logins and possibly
resolved orphaned users see
http://support.microsoft.com/default.aspx/kb/314546 for more.
John

> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:eQl9syDhHHA.392@.TK2MSFTNGP06.phx.gbl...
>
>
|||Can't you backup the database to a file local on the SQL Server machine and then FTP the file to
your machine?
Other methods include script out all the objects and data and then re-create the objects locally and
then import that data. I doubt you will find something as such as rock solid as backup. I've listed
some tools to generate scripts and some with data at
http://www.karaszi.com/SQLServer/info_generate_script.asp.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"John" <John@.nospam.infovis.co.uk> wrote in message
news:%234nMS%23DhHHA.4692@.TK2MSFTNGP04.phx.gbl...
> Remote, does not work for some reason possibly insufficient rights.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:eQl9syDhHHA.392@.TK2MSFTNGP06.phx.gbl...
>

dumb question

Hi all, yes this is a dumb question, but I cant find a formatting answer...
A zero value eg 0, or 0.0 is supressed on RS reports by default.
How can I stop this, the report must show all zeros regardless in a total
field.
If I use default as the format type then I will see 0, but as the field is a
percentage, I have to use the % attribute for the format type..
So, how can I force the showing of a zero in a total fiel ie. 0%
Thanx in advanceHow about =iif(Fields!Total.value>0,Fields!Total.value,0) in the expression
of that text box. Then right click the text box and pick properties format
and put in P (for percent or P0 or P1 according to how many places you want
after the decimal. Hope that works for you.
"Scotchy" wrote:
> Hi all, yes this is a dumb question, but I cant find a formatting answer...
> A zero value eg 0, or 0.0 is supressed on RS reports by default.
> How can I stop this, the report must show all zeros regardless in a total
> field.
> If I use default as the format type then I will see 0, but as the field is a
> percentage, I have to use the % attribute for the format type..
> So, how can I force the showing of a zero in a total fiel ie. 0%
> Thanx in advance|||Hi KimB, thanks for your suggestion, actuall tried that approach to no avail.
cheers
Paul
"KimB" wrote:
> How about =iif(Fields!Total.value>0,Fields!Total.value,0) in the expression
> of that text box. Then right click the text box and pick properties format
> and put in P (for percent or P0 or P1 according to how many places you want
> after the decimal. Hope that works for you.
>
> "Scotchy" wrote:
> > Hi all, yes this is a dumb question, but I cant find a formatting answer...
> >
> > A zero value eg 0, or 0.0 is supressed on RS reports by default.
> >
> > How can I stop this, the report must show all zeros regardless in a total
> > field.
> >
> > If I use default as the format type then I will see 0, but as the field is a
> > percentage, I have to use the % attribute for the format type..
> >
> > So, how can I force the showing of a zero in a total fiel ie. 0%
> >
> > Thanx in advance|||Have you tried =iif(Fields!Total.value>0,Fields!Total.value,"0.0%")? I
think that should work for you.