Dumping all SQL queries.

Hi - is it possible to dump the query text of every query run
against a particular database, or all databases, in an SQL Server
2000 installation? We've an issue whereby a 3rd. party application
running queries over ODBC sometimes claims that gobbledegook is
returned, and it would be very useful to identify the query that's
being claimed is the problem. I suspect that it's an application
issue rather than a SQL Server one.

__________________________________________________ ___________
Are you Catholic ?
http://www.CatholicEmail.com

100s of FREE email addresses -->
http://www.UltimateEmail.com

Send an Online Greeting Card http://www.UltimateEcards.com"sqlserver yeahbaby" <Use-Author-Address-Header@.[127.1]> wrote in message
news:20031104161149.53F073965@.sitemail.everyone.ne t...
> Hi - is it possible to dump the query text of every query run
> against a particular database, or all databases, in an SQL Server
> 2000 installation? We've an issue whereby a 3rd. party application
> running queries over ODBC sometimes claims that gobbledegook is
> returned, and it would be very useful to identify the query that's
> being claimed is the problem. I suspect that it's an application
> issue rather than a SQL Server one.

Look at profiler.

> __________________________________________________ ___________
> Are you Catholic ?
> http://www.CatholicEmail.com
> 100s of FREE email addresses -->
> http://www.UltimateEmail.com
> Send an Online Greeting Card http://www.UltimateEcards.com

Dual installation SQL 2005 Std. and Express

Hi everybody,
I had SQL 2005 std. edition installed and I install SQL 2005 express
after that. I have no trace of the express installation. Neither in the
add/remove program nor under \Program files directory!
Is dual installation possible?
Are files copied to the same directories?
thank you very much
sergeHi,
I found that I had to install SQL Server Management Studio Express (SSMSE)
but it cannot be installed when SQL Server Management Studio standard
edition is already installed. How can'I remove SSMS? It does not appear in
the add/remove program. And the Microsoft warning messsage shown during the
installation of SSMSE is truncated!
thank you for your time
serge
Serge Myrand wrote:
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
> thank you very much
> serge|||> Is dual installation possible?
>
Yes, you can install both. The add/remove programs entry is shared. You
can selectively change/remove instances using the single entry.
> Are files copied to the same directories?
The default location is "C:\Program Files\Microsoft SQL Server". You will
have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44142941.EA94C30F@.softdelirium.qc.ca...
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
>
> thank you very much
> serge
>Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!|||No need for SSMSE in this case since you can use SSMS for the SQL Express
instance. For example, connect to instance 'MyServer\SQLExpress'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44143B91.DA5D61B0@.softdelirium.qc.ca...
> Hi,
> I found that I had to install SQL Server Management Studio Express (SSMSE)
> but it cannot be installed when SQL Server Management Studio standard
> edition is already installed. How can'I remove SSMS? It does not appear in
> the add/remove program. And the Microsoft warning messsage shown during
> the
> installation of SSMSE is truncated!
> thank you for your time
> serge
>
> Serge Myrand wrote:
>> Hi everybody,
>> I had SQL 2005 std. edition installed and I install SQL 2005 express
>> after that. I have no trace of the express installation. Neither in the
>> add/remove program nor under \Program files directory!
>> Is dual installation possible?
>> Are files copied to the same directories?
>> thank you very much
>> serge
>|||Thank you very much.
Dan Guzman wrote:
> > Is dual installation possible?
> >
> Yes, you can install both. The add/remove programs entry is shared. You
> can selectively change/remove instances using the single entry.
> > Are files copied to the same directories?
> The default location is "C:\Program Files\Microsoft SQL Server". You will
> have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
> news:44142941.EA94C30F@.softdelirium.qc.ca...
> > Hi everybody,
> >
> > I had SQL 2005 std. edition installed and I install SQL 2005 express
> > after that. I have no trace of the express installation. Neither in the
> > add/remove program nor under \Program files directory!
> >
> > Is dual installation possible?
> >
> > Are files copied to the same directories?
> >
> >
> > thank you very much
> > serge
> >Neither in the
> > add/remove program nor under \Program files directory!Neither in the
> > add/remove program nor under \Program files directory!Neither in the
> > add/remove program nor under \Program files directory!Neither in the
> > add/remove program nor under \Program files directory!

Dual installation SQL 2005 Std. and Express

Hi everybody,
I had SQL 2005 std. edition installed and I install SQL 2005 express
after that. I have no trace of the express installation. Neither in the
add/remove program nor under \Program files directory!
Is dual installation possible?
Are files copied to the same directories?
thank you very much
serge
Hi,
I found that I had to install SQL Server Management Studio Express (SSMSE)
but it cannot be installed when SQL Server Management Studio standard
edition is already installed. How can'I remove SSMS? It does not appear in
the add/remove program. And the Microsoft warning messsage shown during the
installation of SSMSE is truncated!
thank you for your time
serge
Serge Myrand wrote:

> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
> thank you very much
> serge
|||> Is dual installation possible?
>
Yes, you can install both. The add/remove programs entry is shared. You
can selectively change/remove instances using the single entry.

> Are files copied to the same directories?
The default location is "C:\Program Files\Microsoft SQL Server". You will
have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44142941.EA94C30F@.softdelirium.qc.ca...
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
>
> thank you very much
> serge
>Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!
|||No need for SSMSE in this case since you can use SSMS for the SQL Express
instance. For example, connect to instance 'MyServer\SQLExpress'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44143B91.DA5D61B0@.softdelirium.qc.ca...
> Hi,
> I found that I had to install SQL Server Management Studio Express (SSMSE)
> but it cannot be installed when SQL Server Management Studio standard
> edition is already installed. How can'I remove SSMS? It does not appear in
> the add/remove program. And the Microsoft warning messsage shown during
> the
> installation of SSMSE is truncated!
> thank you for your time
> serge
>
> Serge Myrand wrote:
>
|||Thank you very much.
Dan Guzman wrote:
[vbcol=seagreen]
> Yes, you can install both. The add/remove programs entry is shared. You
> can selectively change/remove instances using the single entry.
>
> The default location is "C:\Program Files\Microsoft SQL Server". You will
> have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
> news:44142941.EA94C30F@.softdelirium.qc.ca...

Dual installation SQL 2005 Std. and Express

Hi everybody,
I had SQL 2005 std. edition installed and I install SQL 2005 express
after that. I have no trace of the express installation. Neither in the
add/remove program nor under \Program files directory!
Is dual installation possible?
Are files copied to the same directories?
thank you very much
sergeHi,
I found that I had to install SQL Server Management Studio Express (SSMSE)
but it cannot be installed when SQL Server Management Studio standard
edition is already installed. How can'I remove SSMS? It does not appear in
the add/remove program. And the Microsoft warning messsage shown during the
installation of SSMSE is truncated!
thank you for your time
serge
Serge Myrand wrote:

> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
> thank you very much
> serge|||> Is dual installation possible?
>
Yes, you can install both. The add/remove programs entry is shared. You
can selectively change/remove instances using the single entry.

> Are files copied to the same directories?
The default location is "C:\Program Files\Microsoft SQL Server". You will
have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44142941.EA94C30F@.softdelirium.qc.ca...
> Hi everybody,
> I had SQL 2005 std. edition installed and I install SQL 2005 express
> after that. I have no trace of the express installation. Neither in the
> add/remove program nor under \Program files directory!
> Is dual installation possible?
> Are files copied to the same directories?
>
> thank you very much
> serge
>Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!Neither in the
> add/remove program nor under \Program files directory!|||No need for SSMSE in this case since you can use SSMS for the SQL Express
instance. For example, connect to instance 'MyServer\SQLExpress'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
news:44143B91.DA5D61B0@.softdelirium.qc.ca...
> Hi,
> I found that I had to install SQL Server Management Studio Express (SSMSE)
> but it cannot be installed when SQL Server Management Studio standard
> edition is already installed. How can'I remove SSMS? It does not appear in
> the add/remove program. And the Microsoft warning messsage shown during
> the
> installation of SSMSE is truncated!
> thank you for your time
> serge
>
> Serge Myrand wrote:
>
>|||Thank you very much.
Dan Guzman wrote:
[vbcol=seagreen]
> Yes, you can install both. The add/remove programs entry is shared. You
> can selectively change/remove instances using the single entry.
>
> The default location is "C:\Program Files\Microsoft SQL Server". You will
> have numbered subfolders(e.g. MSSQL.4) for instance-specific items.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Serge Myrand" <info@.softdelirium.qc.ca> wrote in message
> news:44142941.EA94C30F@.softdelirium.qc.ca...

Dual connection?

I do all my messing around with databases on my Windows
XPP partition and have a small installation of server 2K3
that I want to use as a test server. Can I set it up so
that I can connect to the same installation from both
systems; edit from XPP and use in 2K3 for my dynamic
webpages?
If this is a really simple question that I am just
missing somwhere in documantation just point the way home.
-- Matt WallaceCan you explain your question more clear?|||Hello,
Yes you can you just need to have two separate connection objects.
I hope this helped
Greg O
Save HOURS documenting your SQL Server! -- FREE Trial!
http://www.ag-software.com/ags_scribe_index.aspx
Crosstab Queries without OLAP -- 30 day free Trial!
http://www.ag-software.com/xp_ags_crosstab.aspx
"matt" <harmonicace@.hotmail.com> wrote in message
news:acbe01c40737$cb9c4b70$a401280a@.phx.gbl...
> I do all my messing around with databases on my Windows
> XPP partition and have a small installation of server 2K3
> that I want to use as a test server. Can I set it up so
> that I can connect to the same installation from both
> systems; edit from XPP and use in 2K3 for my dynamic
> webpages?
> If this is a really simple question that I am just
> missing somwhere in documantation just point the way home.
> -- Matt Wallace|||I guess I was a little ambiguous there
I have XPP installed on C: then I have 2K3 installed on H.
What I want to do is intall SQL Server on both OSes and
have them share a database on another partition. Or is it
possible for me to install it on the third partition and
have both OSes recognize that installation and its settings
etc. so that I can access it no matter which OS I'm booted
into.
Is that clearer?
thanks.
-- Matt

>--Original Message--
>Can you explain your question more clear?
>
>.
>|||Forgive my ignorance but I'm new to SQL and MS's SQL
Server. How would I go about doing that?

>--Original Message--
>Hello,
>Yes you can you just need to have two separate connection
objects.
>--
>I hope this helped
>Greg O
>Save HOURS documenting your SQL Server! -- FREE Trial!
>http://www.ag-software.com/ags_scribe_index.aspx
>Crosstab Queries without OLAP -- 30 day free Trial!
>http://www.ag-software.com/xp_ags_crosstab.aspx
>|||That is clear
If you see database files from both instalations you must install SQL Server
and attach these files in both instalation.
Bojidar Alexandrov
<anonymous@.discussions.microsoft.com> wrote in message
news:82f601c40780$ecffec60$a601280a@.phx.gbl...
> I guess I was a little ambiguous there
> I have XPP installed on C: then I have 2K3 installed on H.
> What I want to do is intall SQL Server on both OSes and
> have them share a database on another partition. Or is it
> possible for me to install it on the third partition and
> have both OSes recognize that installation and its settings
> etc. so that I can access it no matter which OS I'm booted
> into.
> Is that clearer?
> thanks.
> -- Matt
>|||Hi Matt,
Reading your other post I understand more of what you want to do now.
First you need to install SQL server on both installations.
Then you need to detach the User databases (Using EM) before you switch to
the other OS once on the other OS then attach the databases. It's important
to do that because it ensures the DB are in good working order.
I hope this helped
Greg O
Save HOURS documenting your SQL Server! -- FREE Trial!
http://www.ag-software.com/ags_scribe_index.aspx
Crosstab Queries without OLAP -- 30 day free Trial!
http://www.ag-software.com/xp_ags_crosstab.aspx
"matt" <harmonciace@.hotmail.com> wrote in message
news:b0f301c40781$4da4d440$a501280a@.phx.gbl...
> Forgive my ignorance but I'm new to SQL and MS's SQL
> Server. How would I go about doing that?
>
> objects.