Hi, I am looking for a way to transfer data from sql server to sql server ce. I am using sql server management studio express wich has no export/import wizard. How can I accomplish this task? are there any tools available? thanks
I have developed a set of tools that can help you with this. Please note that 3.5 is not supported yet.|||Thanks! I will check it out!
|||Jo?o, I have tried your tools. But when i try to run it it says it can't open the device database. I want to export the sql 2005 database to a .sdf file. When I check the 'local' checkbox I still get the same error.
Is there any other way to port sql ce databases to sql server?
|||You must install SQL Compact Edition 3.1 on your desktop in order to use the "Local" checkbox.|||Great! it works! thanks. Does it also migrate foreign keys to sql ce?
|||It migrates PRIMARY KEY and FOREIGN KEY constraints. UNIQUE constraints are not migrated (they may show up as UNIQUE INDEX) nor are column defaults (due to the SQL language difference between engines, especially Access). IDENTITY columns are correctly migrated.
Showing posts with label management. Show all posts
Showing posts with label management. Show all posts
Wednesday, March 28, 2012
Migrating data from sql server to sql server ce
Hi, I am looking for a way to transfer data from sql server to sql server ce. I am using sql server management studio express wich has no export/import wizard. How can I accomplish this task? are there any tools available? thanks
I have developed a set of tools that can help you with this. Please note that 3.5 is not supported yet.|||Thanks! I will check it out!
|||Jo?o, I have tried your tools. But when i try to run it it says it can't open the device database. I want to export the sql 2005 database to a .sdf file. When I check the 'local' checkbox I still get the same error.
Is there any other way to port sql ce databases to sql server?
|||You must install SQL Compact Edition 3.1 on your desktop in order to use the "Local" checkbox.|||Great! it works! thanks. Does it also migrate foreign keys to sql ce?
|||It migrates PRIMARY KEY and FOREIGN KEY constraints. UNIQUE constraints are not migrated (they may show up as UNIQUE INDEX) nor are column defaults (due to the SQL language difference between engines, especially Access). IDENTITY columns are correctly migrated.sql
I have developed a set of tools that can help you with this. Please note that 3.5 is not supported yet.|||Thanks! I will check it out!
|||Jo?o, I have tried your tools. But when i try to run it it says it can't open the device database. I want to export the sql 2005 database to a .sdf file. When I check the 'local' checkbox I still get the same error.
Is there any other way to port sql ce databases to sql server?
|||You must install SQL Compact Edition 3.1 on your desktop in order to use the "Local" checkbox.|||Great! it works! thanks. Does it also migrate foreign keys to sql ce?
|||It migrates PRIMARY KEY and FOREIGN KEY constraints. UNIQUE constraints are not migrated (they may show up as UNIQUE INDEX) nor are column defaults (due to the SQL language difference between engines, especially Access). IDENTITY columns are correctly migrated.sql
Friday, March 9, 2012
Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
I'm trying to find ANY examples of using the
Microsoft.SqlServer.Management.Trace namespace.
Microsoft.SqlServer.Management.Trace namespace.
What I'm looking for is an example of being able to create and initialise a
new trace, haing this processed on the Server, and then initializes some
sort of traceReader against this.
e.g the equivalent of:
MyTraceConnection = new Something ("localhost");
MyTrace = new SqlTrace (CaptureTSQL || CaptureLogonEvent ||
CaptureLogoutEvent 0)
MyTrace.Open(MyTraceConnection)
OnTraceEvent (TraceInfo x) {
Console.Writeline ( x.ToString() ) ;
}
Any examples ? There seems to be nothing in MSDN, or SQL2005 info.
Thanks
Steven
Please refer to the SMO samples Tracer and SmoEvents as they create and read trace event logs.
The sample code, if installed in the default folderr, should be in the C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\SMO\... folder.|||I installed all subcomponents from the MSDN Download: en_sql_2005_dev_all_dvd.iso
And, I don't have such a folder
Am I missing something ?|||Also, it doesn't seem to be in
http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en|||The samples are available during the installation of SQL Server but are not automatically installed. If you re-run setup or use Add/Remove Programs you need to go to the Feature Selection and make sure the Sample databases and programs are set to install.
Also, I found the SqlServerSamples.msi on http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en about half way down the page.|||OK - Thanks .
I tried AddRemovePrograms, but didn't find it
However, I've had yet another look at the files from SqlServerSamples.msi, and finally found it...
After I removed the "SignAssembly", the project worked
Though it does seem odd that you can't create a trace against a server, without a .TDF file.
I thought this was what the Microsoft.SqlServer.Management.Smo.ServerTraceEventSet was for, to allow you to define a dynamic trace
Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
I'm trying to find ANY examples of using the
Microsoft.SqlServer.Management.Trace namespace.
What I'm looking for is an example of being able to create and initialise a
new trace, haing this processed on the Server, and then initializes some
sort of traceReader against this.
e.g the equivalent of:
MyTraceConnection = new Something ("localhost");
MyTrace = new SqlTrace (CaptureTSQL || CaptureLogonEvent ||
CaptureLogoutEvent 0)
MyTrace.Open(MyTraceConnection)
OnTraceEvent (TraceInfo x) {
Console.Writeline ( x.ToString() ) ;
}
Any examples ? There seems to be nothing in MSDN, or SQL2005 info.
Thanks
StevenHello Steven,
I found the following link for your reference:
Trace and Replay Objects: A New API for SQL Server Tracing and Replay
http://msdn.microsoft.com/library/d...-us/dnsql90/htm
l/SQLTrcRpOb.asp
Hope this is helpful.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Reply-To: "Steven Wilmot" <steven-news@.wilmot.me.uk>
| From: "Steven Wilmot" <Steven_W@.newsgroups.nospam>
| Subject: Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
| Date: Tue, 15 Nov 2005 01:15:01 -0000
| Lines: 26
| Organization: Data Utilities Ltd
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <u8YSyHY6FHA.2040@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: wilmot.me.uk 217.169.5.59
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.programming:562129
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
| I'm trying to find ANY examples of using the
| Microsoft.SqlServer.Management.Trace namespace.
|
| What I'm looking for is an example of being able to create and initialise
a
| new trace, haing this processed on the Server, and then initializes some
| sort of traceReader against this.
|
| e.g the equivalent of:
| MyTraceConnection = new Something ("localhost");
| MyTrace = new SqlTrace (CaptureTSQL || CaptureLogonEvent ||
| CaptureLogoutEvent 0)
| MyTrace.Open(MyTraceConnection)
|
| OnTraceEvent (TraceInfo x) {
| Console.Writeline ( x.ToString() ) ;
| }
|
| --
|
| Any examples ? There seems to be nothing in MSDN, or SQL2005 info.
|
| Thanks
|
| Steven
|
|
||||"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl...
> Hello Steven,
> I found the following link for your reference:
> Trace and Replay Objects: A New API for SQL Server Tracing and Replay
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm[/ur
l]
> l/SQLTrcRpOb.asp
> Hope this is helpful.
>
Excellent
It is just a shame that there doesn't seem to be a way to create a TDF file
without using SQL Profiler
(and nothing to suggest who the ServerTraceEvent class should be used)
S.|||Hello Steven,
Thank you for your feedback on this and rest assured it is routed to the
proper channel. Also, it is suggsted that you use template to define events
you want to monitor in this situation. :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Reply-To: "Steven Wilmot" <steven-news@.wilmot.me.uk>
| From: "Steven Wilmot" <Steven_W@.newsgroups.nospam>
| References: <u8YSyHY6FHA.2040@.TK2MSFTNGP14.phx.gbl>
<j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
| Date: Tue, 15 Nov 2005 20:35:12 -0000
| Lines: 24
| Organization: Data Utilities Ltd
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <O$dNTQi6FHA.4076@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: wilmot.me.uk 217.169.5.59
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.programming:562415
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl...
| > Hello Steven,
| >
| > I found the following link for your reference:
| >
| > Trace and Replay Objects: A New API for SQL Server Tracing and Replay
| >
http://msdn.microsoft.com/library/d...-us/dnsql90/htm
| > l/SQLTrcRpOb.asp
| >
| > Hope this is helpful.
| >
|
| Excellent
|
| It is just a shame that there doesn't seem to be a way to create a TDF
file
| without using SQL Profiler
|
| (and nothing to suggest who the ServerTraceEvent class should be used)
|
| S.
|
|
||||"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:csfytqp6FHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hello Steven,
> Thank you for your feedback on this and rest assured it is routed to the
> proper channel. Also, it is suggsted that you use template to define
> events
> you want to monitor in this situation. :-)
>
Is the format of a TDF file defined anywhere ?|||Hello Steven,
To my knowledge, there is no public document on format of TDF. You shall
use SQL profiler to create a new TDF file you want. Also, you could use the
Send Feedback button from the SQL Server Books Online. Have a great day!
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Reply-To: "Steven Wilmot" <steven-news@.wilmot.me.uk>
| From: "Steven Wilmot" <Steven_W@.newsgroups.nospam>
| References: <u8YSyHY6FHA.2040@.TK2MSFTNGP14.phx.gbl>
<j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl>
<O$dNTQi6FHA.4076@.tk2msftngp13.phx.gbl>
<csfytqp6FHA.1236@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
| Date: Wed, 16 Nov 2005 20:30:45 -0000
| Lines: 14
| Organization: Data Utilities Ltd
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| Message-ID: <OAbNeyu6FHA.472@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: wilmot.me.uk 217.169.5.59
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.programming:562679
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:csfytqp6FHA.1236@.TK2MSFTNGXA02.phx.gbl...
| > Hello Steven,
| >
| > Thank you for your feedback on this and rest assured it is routed to the
| > proper channel. Also, it is suggsted that you use template to define
| > events
| > you want to monitor in this situation. :-)
| >
|
| Is the format of a TDF file defined anywhere ?
|
|
||||"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl...
> Hello Steven,
> I found the following link for your reference:
> Trace and Replay Objects: A New API for SQL Server Tracing and Replay
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm[/ur
l]
> l/SQLTrcRpOb.asp
> Hope this is helpful.
>
Any idea if there is anything indicating how to use
Microsoft.SqlServer.Management.Smo.ServerTraceEvent
or Microsoft.SqlServer.Management.Smo.ServerTraceEventSet
These would APPEAR to be ideal for creating a TDF, but with no such thing as
a ServerTraceEventSet.WriteToFile()
S.|||Hello Steven,
Based on my research, ServerTraceEventSet is used to specify the currently
selected trace events
Smo.ServerTraceEventset. selectTraceEvents specifies the Trace events to
receive. Events will be sent to the event handler(s) that are registered
with the OnEvent event. There is no method to serialize the set to a TDF
file though.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Reply-To: "Steven Wilmot" <steven-news@.wilmot.me.uk>
| From: "Steven Wilmot" <Steven_W@.newsgroups.nospam>
| References: <u8YSyHY6FHA.2040@.TK2MSFTNGP14.phx.gbl>
<j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
| Date: Thu, 17 Nov 2005 11:32:41 -0000
| Lines: 28
| Organization: Data Utilities Ltd
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| Message-ID: <OehJdq26FHA.1248@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: wilmot.me.uk 217.169.5.59
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
4.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.programming:562828
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl...
| > Hello Steven,
| >
| > I found the following link for your reference:
| >
| > Trace and Replay Objects: A New API for SQL Server Tracing and Replay
| >
http://msdn.microsoft.com/library/d...-us/dnsql90/htm
| > l/SQLTrcRpOb.asp
| >
| > Hope this is helpful.
| >
|
| Any idea if there is anything indicating how to use
|
| Microsoft.SqlServer.Management.Smo.ServerTraceEvent
|
| or Microsoft.SqlServer.Management.Smo.ServerTraceEventSet
|
|
|
| These would APPEAR to be ideal for creating a TDF, but with no such thing
as
| a ServerTraceEventSet.WriteToFile()
|
| S.
|
|
||||"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:xWeu$%23$6FHA.3648@.TK2MSFTNGXA02.phx.gbl...
> Hello Steven,
> Based on my research, ServerTraceEventSet is used to specify the currently
> selected trace events
> Smo.ServerTraceEventset. selectTraceEvents specifies the Trace events to
> receive. Events will be sent to the event handler(s) that are registered
> with the OnEvent event. There is no method to serialize the set to a TDF
> file though.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> 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.
> ========================================
=============
>
Sorry to be a pain.
ServerTraceSet LOOKS ideal (to register the list of bitflags of events to
receive)
These all seem to be nicely grouped together in a ServerTraceSetEvent.
So, I would expect something such as
TraceServer.InitialiseasTraceReader(string ServerName, ServerTraceSetEvent
WhatToTrace) ;
This is the bit that seems to be missing.|||Hello Steven,
This is a great idea for a future product enhancement. Please rest assured
it is routed to the right channel. Also, you could click "Send feedback"
button in Toolbox of Books Online to send your feedback to product team.
Have a great day!
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Reply-To: "Steven Wilmot" <steven-news@.wilmot.me.uk>
| From: "Steven Wilmot" <Steven_W@.newsgroups.nospam>
| References: <u8YSyHY6FHA.2040@.TK2MSFTNGP14.phx.gbl>
<j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl>
<OehJdq26FHA.1248@.TK2MSFTNGP14.phx.gbl>
<xWeu$#$6FHA.3648@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
| Date: Fri, 18 Nov 2005 23:40:18 -0000
| Lines: 40
| Organization: Data Utilities Ltd
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <OD2pslJ7FHA.3440@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: wilmot.me.uk 217.169.5.59
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.programming:563233
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:xWeu$%23$6FHA.3648@.TK2MSFTNGXA02.phx.gbl...
| > Hello Steven,
| >
| > Based on my research, ServerTraceEventSet is used to specify the
currently
| > selected trace events
| >
| > Smo.ServerTraceEventset. selectTraceEvents specifies the Trace events to
| > receive. Events will be sent to the event handler(s) that are registered
| > with the OnEvent event. There is no method to serialize the set to a TDF
| > file though.
| >
| > Best Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > 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.
| >
| > ========================================
=============
| >
|
| Sorry to be a pain.
|
| ServerTraceSet LOOKS ideal (to register the list of bitflags of events to
| receive)
|
| These all seem to be nicely grouped together in a ServerTraceSetEvent.
|
| So, I would expect something such as
| TraceServer.InitialiseasTraceReader(string ServerName,
ServerTraceSetEvent
| WhatToTrace) ;
|
| This is the bit that seems to be missing.
|
|
|
|
Microsoft.SqlServer.Management.Trace namespace.
What I'm looking for is an example of being able to create and initialise a
new trace, haing this processed on the Server, and then initializes some
sort of traceReader against this.
e.g the equivalent of:
MyTraceConnection = new Something ("localhost");
MyTrace = new SqlTrace (CaptureTSQL || CaptureLogonEvent ||
CaptureLogoutEvent 0)
MyTrace.Open(MyTraceConnection)
OnTraceEvent (TraceInfo x) {
Console.Writeline ( x.ToString() ) ;
}
Any examples ? There seems to be nothing in MSDN, or SQL2005 info.
Thanks
StevenHello Steven,
I found the following link for your reference:
Trace and Replay Objects: A New API for SQL Server Tracing and Replay
http://msdn.microsoft.com/library/d...-us/dnsql90/htm
l/SQLTrcRpOb.asp
Hope this is helpful.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Reply-To: "Steven Wilmot" <steven-news@.wilmot.me.uk>
| From: "Steven Wilmot" <Steven_W@.newsgroups.nospam>
| Subject: Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
| Date: Tue, 15 Nov 2005 01:15:01 -0000
| Lines: 26
| Organization: Data Utilities Ltd
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <u8YSyHY6FHA.2040@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: wilmot.me.uk 217.169.5.59
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.programming:562129
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
| I'm trying to find ANY examples of using the
| Microsoft.SqlServer.Management.Trace namespace.
|
| What I'm looking for is an example of being able to create and initialise
a
| new trace, haing this processed on the Server, and then initializes some
| sort of traceReader against this.
|
| e.g the equivalent of:
| MyTraceConnection = new Something ("localhost");
| MyTrace = new SqlTrace (CaptureTSQL || CaptureLogonEvent ||
| CaptureLogoutEvent 0)
| MyTrace.Open(MyTraceConnection)
|
| OnTraceEvent (TraceInfo x) {
| Console.Writeline ( x.ToString() ) ;
| }
|
| --
|
| Any examples ? There seems to be nothing in MSDN, or SQL2005 info.
|
| Thanks
|
| Steven
|
|
||||"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl...
> Hello Steven,
> I found the following link for your reference:
> Trace and Replay Objects: A New API for SQL Server Tracing and Replay
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm[/ur
l]
> l/SQLTrcRpOb.asp
> Hope this is helpful.
>
Excellent
It is just a shame that there doesn't seem to be a way to create a TDF file
without using SQL Profiler
(and nothing to suggest who the ServerTraceEvent class should be used)
S.|||Hello Steven,
Thank you for your feedback on this and rest assured it is routed to the
proper channel. Also, it is suggsted that you use template to define events
you want to monitor in this situation. :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Reply-To: "Steven Wilmot" <steven-news@.wilmot.me.uk>
| From: "Steven Wilmot" <Steven_W@.newsgroups.nospam>
| References: <u8YSyHY6FHA.2040@.TK2MSFTNGP14.phx.gbl>
<j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
| Date: Tue, 15 Nov 2005 20:35:12 -0000
| Lines: 24
| Organization: Data Utilities Ltd
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <O$dNTQi6FHA.4076@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: wilmot.me.uk 217.169.5.59
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.programming:562415
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl...
| > Hello Steven,
| >
| > I found the following link for your reference:
| >
| > Trace and Replay Objects: A New API for SQL Server Tracing and Replay
| >
http://msdn.microsoft.com/library/d...-us/dnsql90/htm
| > l/SQLTrcRpOb.asp
| >
| > Hope this is helpful.
| >
|
| Excellent
|
| It is just a shame that there doesn't seem to be a way to create a TDF
file
| without using SQL Profiler
|
| (and nothing to suggest who the ServerTraceEvent class should be used)
|
| S.
|
|
||||"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:csfytqp6FHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hello Steven,
> Thank you for your feedback on this and rest assured it is routed to the
> proper channel. Also, it is suggsted that you use template to define
> events
> you want to monitor in this situation. :-)
>
Is the format of a TDF file defined anywhere ?|||Hello Steven,
To my knowledge, there is no public document on format of TDF. You shall
use SQL profiler to create a new TDF file you want. Also, you could use the
Send Feedback button from the SQL Server Books Online. Have a great day!
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Reply-To: "Steven Wilmot" <steven-news@.wilmot.me.uk>
| From: "Steven Wilmot" <Steven_W@.newsgroups.nospam>
| References: <u8YSyHY6FHA.2040@.TK2MSFTNGP14.phx.gbl>
<j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl>
<O$dNTQi6FHA.4076@.tk2msftngp13.phx.gbl>
<csfytqp6FHA.1236@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
| Date: Wed, 16 Nov 2005 20:30:45 -0000
| Lines: 14
| Organization: Data Utilities Ltd
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| Message-ID: <OAbNeyu6FHA.472@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: wilmot.me.uk 217.169.5.59
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.programming:562679
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:csfytqp6FHA.1236@.TK2MSFTNGXA02.phx.gbl...
| > Hello Steven,
| >
| > Thank you for your feedback on this and rest assured it is routed to the
| > proper channel. Also, it is suggsted that you use template to define
| > events
| > you want to monitor in this situation. :-)
| >
|
| Is the format of a TDF file defined anywhere ?
|
|
||||"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl...
> Hello Steven,
> I found the following link for your reference:
> Trace and Replay Objects: A New API for SQL Server Tracing and Replay
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm[/ur
l]
> l/SQLTrcRpOb.asp
> Hope this is helpful.
>
Any idea if there is anything indicating how to use
Microsoft.SqlServer.Management.Smo.ServerTraceEvent
or Microsoft.SqlServer.Management.Smo.ServerTraceEventSet
These would APPEAR to be ideal for creating a TDF, but with no such thing as
a ServerTraceEventSet.WriteToFile()
S.|||Hello Steven,
Based on my research, ServerTraceEventSet is used to specify the currently
selected trace events
Smo.ServerTraceEventset. selectTraceEvents specifies the Trace events to
receive. Events will be sent to the event handler(s) that are registered
with the OnEvent event. There is no method to serialize the set to a TDF
file though.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Reply-To: "Steven Wilmot" <steven-news@.wilmot.me.uk>
| From: "Steven Wilmot" <Steven_W@.newsgroups.nospam>
| References: <u8YSyHY6FHA.2040@.TK2MSFTNGP14.phx.gbl>
<j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
| Date: Thu, 17 Nov 2005 11:32:41 -0000
| Lines: 28
| Organization: Data Utilities Ltd
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| Message-ID: <OehJdq26FHA.1248@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: wilmot.me.uk 217.169.5.59
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
4.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.programming:562828
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl...
| > Hello Steven,
| >
| > I found the following link for your reference:
| >
| > Trace and Replay Objects: A New API for SQL Server Tracing and Replay
| >
http://msdn.microsoft.com/library/d...-us/dnsql90/htm
| > l/SQLTrcRpOb.asp
| >
| > Hope this is helpful.
| >
|
| Any idea if there is anything indicating how to use
|
| Microsoft.SqlServer.Management.Smo.ServerTraceEvent
|
| or Microsoft.SqlServer.Management.Smo.ServerTraceEventSet
|
|
|
| These would APPEAR to be ideal for creating a TDF, but with no such thing
as
| a ServerTraceEventSet.WriteToFile()
|
| S.
|
|
||||"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:xWeu$%23$6FHA.3648@.TK2MSFTNGXA02.phx.gbl...
> Hello Steven,
> Based on my research, ServerTraceEventSet is used to specify the currently
> selected trace events
> Smo.ServerTraceEventset. selectTraceEvents specifies the Trace events to
> receive. Events will be sent to the event handler(s) that are registered
> with the OnEvent event. There is no method to serialize the set to a TDF
> file though.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> 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.
> ========================================
=============
>
Sorry to be a pain.
ServerTraceSet LOOKS ideal (to register the list of bitflags of events to
receive)
These all seem to be nicely grouped together in a ServerTraceSetEvent.
So, I would expect something such as
TraceServer.InitialiseasTraceReader(string ServerName, ServerTraceSetEvent
WhatToTrace) ;
This is the bit that seems to be missing.|||Hello Steven,
This is a great idea for a future product enhancement. Please rest assured
it is routed to the right channel. Also, you could click "Send feedback"
button in Toolbox of Books Online to send your feedback to product team.
Have a great day!
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.
| Reply-To: "Steven Wilmot" <steven-news@.wilmot.me.uk>
| From: "Steven Wilmot" <Steven_W@.newsgroups.nospam>
| References: <u8YSyHY6FHA.2040@.TK2MSFTNGP14.phx.gbl>
<j2Y1oKb6FHA.1240@.TK2MSFTNGXA02.phx.gbl>
<OehJdq26FHA.1248@.TK2MSFTNGP14.phx.gbl>
<xWeu$#$6FHA.3648@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?
| Date: Fri, 18 Nov 2005 23:40:18 -0000
| Lines: 40
| Organization: Data Utilities Ltd
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <OD2pslJ7FHA.3440@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: wilmot.me.uk 217.169.5.59
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.programming:563233
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:xWeu$%23$6FHA.3648@.TK2MSFTNGXA02.phx.gbl...
| > Hello Steven,
| >
| > Based on my research, ServerTraceEventSet is used to specify the
currently
| > selected trace events
| >
| > Smo.ServerTraceEventset. selectTraceEvents specifies the Trace events to
| > receive. Events will be sent to the event handler(s) that are registered
| > with the OnEvent event. There is no method to serialize the set to a TDF
| > file though.
| >
| > Best Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > 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.
| >
| > ========================================
=============
| >
|
| Sorry to be a pain.
|
| ServerTraceSet LOOKS ideal (to register the list of bitflags of events to
| receive)
|
| These all seem to be nicely grouped together in a ServerTraceSetEvent.
|
| So, I would expect something such as
| TraceServer.InitialiseasTraceReader(string ServerName,
ServerTraceSetEvent
| WhatToTrace) ;
|
| This is the bit that seems to be missing.
|
|
|
|
Friday, February 24, 2012
Microsoft SSMSE - Printing database layout?
I'm connected to my remote SQL 2000 server using Microsofts SQL Server
Management Studio Express.
I can't see any way to print out my database table properties. Under
Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
which does not work.
How does one print out the layout of their database from this app?
Thanks!Noozer
Do you want to print a diagram by using SSMS of the SQL Server 2000
database?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
> Management Studio Express.
> I can't see any way to print out my database table properties. Under
> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
> which does not work.
> How does one print out the layout of their database from this app?
> Thanks!
>|||Diagrams would be great!
But, I'd settle for simply printing the properties from each of my tables.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
> Noozer
> Do you want to print a diagram by using SSMS of the SQL Server 2000
> database?
>
>
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>|||Noozer
What properties? There is an option Script Table As , are you talking about
this feature?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>|||Why can't you go to File, Print...
or right-click the db diagram, "Copy Diagram to Clipboard," and paste/print
from Word?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>|||Because "Print..." is coming up disabled.
The server is a remote MS SQL 2000 server.
Diagrams does not work at all.
"JFoushee" <someone@.somewhere-donotspam.com> wrote in message
news:O$O9PTRbGHA.4116@.TK2MSFTNGP05.phx.gbl...
> Why can't you go to File, Print...
> or right-click the db diagram, "Copy Diagram to Clipboard," and
> paste/print from Word?
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
>> Diagrams would be great!
>> But, I'd settle for simply printing the properties from each of my
>> tables.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000
>> Diagrams", which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>>
>
Management Studio Express.
I can't see any way to print out my database table properties. Under
Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
which does not work.
How does one print out the layout of their database from this app?
Thanks!Noozer
Do you want to print a diagram by using SSMS of the SQL Server 2000
database?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
> Management Studio Express.
> I can't see any way to print out my database table properties. Under
> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
> which does not work.
> How does one print out the layout of their database from this app?
> Thanks!
>|||Diagrams would be great!
But, I'd settle for simply printing the properties from each of my tables.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
> Noozer
> Do you want to print a diagram by using SSMS of the SQL Server 2000
> database?
>
>
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>|||Noozer
What properties? There is an option Script Table As , are you talking about
this feature?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>|||Why can't you go to File, Print...
or right-click the db diagram, "Copy Diagram to Clipboard," and paste/print
from Word?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>|||Because "Print..." is coming up disabled.
The server is a remote MS SQL 2000 server.
Diagrams does not work at all.
"JFoushee" <someone@.somewhere-donotspam.com> wrote in message
news:O$O9PTRbGHA.4116@.TK2MSFTNGP05.phx.gbl...
> Why can't you go to File, Print...
> or right-click the db diagram, "Copy Diagram to Clipboard," and
> paste/print from Word?
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
>> Diagrams would be great!
>> But, I'd settle for simply printing the properties from each of my
>> tables.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000
>> Diagrams", which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>>
>
Microsoft SQL Sever management Studio: Failed to open connection dialog
Does anyone encount the following problem before? When I tried to connect to Microsoft SQL server 2005 with MS SQL Server Management Studio, I received: "Failed to open connection dialog" message with additional information is "Package 'Mircrosoft SQL Server Object Explorer' failed to load.
This's just happened recently. Although I am receiving that message, I still able access into database with different types of connection.
Can someone shred some light?
Thanks
Tommy.
Have you attempted to connect the server using another client's machine.|||This looks like some of your .NET components have corrupted. Reinstalling the same should help.
Thanks,
Kuntal
The most likely cause of this is if a file has been deleted or corrupted. Does repairing the SQL Server management tools fix the problem?
Repairing SQL Server is a command-line operation. You can repair by inserting the installation media into the disk drive and typing the following:
start /wait <CD or DVD Drive>\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS
You can find more information on installing SQL Server from the command line here: http://msdn2.microsoft.com/en-us/library/ms144259.aspx
|||
Good morning ( or afternoon for me )
Goo and helpful answer whether you have the cd disk but if you have downloaded from Microsoft (for example Express Edition or School version ), i think i must contact Microsoft to have the agreement to downloa and validate again
Have a nice day
Microsoft SQL Sever management Studio: Failed to open connection dialog
Does anyone encount the following problem before? When I tried to connect to Microsoft SQL server 2005 with MS SQL Server Management Studio, I received: "Failed to open connection dialog" message with additional information is "Package 'Mircrosoft SQL Server Object Explorer' failed to load.
This's just happened recently. Although I am receiving that message, I still able access into database with different types of connection.
Can someone shred some light?
Thanks
Tommy.
Have you attempted to connect the server using another client's machine.|||This looks like some of your .NET components have corrupted. Reinstalling the same should help.
Thanks,
Kuntal
The most likely cause of this is if a file has been deleted or corrupted. Does repairing the SQL Server management tools fix the problem?
Repairing SQL Server is a command-line operation. You can repair by inserting the installation media into the disk drive and typing the following:
start /wait <CD or DVD Drive>\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS
You can find more information on installing SQL Server from the command line here: http://msdn2.microsoft.com/en-us/library/ms144259.aspx
|||
Good morning ( or afternoon for me )
Goo and helpful answer whether you have the cd disk but if you have downloaded from Microsoft (for example Express Edition or School version ), i think i must contact Microsoft to have the agreement to downloa and validate again
Have a nice day
Microsoft SQL Server vs Sybase
Hello,
We have Trading Applications (Equities & Portfolio written on C++) on MS SQL Server 2000. Now the management is deciding to move it on Sybase 12.5. We currently don't have any issues on any matter, but because everyone is SYbase fan here, thinks applications are critical and we need to move to Sybase. Can anyone who has worked on both knows the major pros & cons of both the system. Actually I wanted these systems to be on MS SQL Server. I need solid reasons except being cheaper than Sybase to show why we should use MS SQL Server
If anyone can share their experiences, it would be really great.
Thanks
ReaI have used both Sybase ASE and MS SQL Server 2000 in mission-critical systems. Up front I will say that I personally prefer ASE.
ASE and SQL Server have much the same base T-SQL syntax. However SQL Server has introduced a number of functions to do analytics that Sybase thought best to place into a separate product, Sybase IQ. So if you are using CUBE and other functions they will have to be re-written in T-SQL or application logic.
Both ASE and SQL Server have triggers and stored procedures that use T-SQL.
ASE and SQL Server both support user defined datatypes, have identical clustered index approaches, and offer much the same stored procedures to administer the DBMS.
SQL Server has sort of implicit locking scheme in which SQL server will dynamically choose row or page locking (and of course table). ASE requires you to explicitly state whether the granularity of locks are row or page, and a row-lock table cannot lock a data page and vice versa.
ASE has a wider array of tuning tools to change parameters and such. SQL Server has more built-in 'self tuning' tools and can auto-grow devices, auto-backup, etc. Having administered both I prefer ASE's if I have a mission-critical DB that I can devote time to (since our DBAs tend to know more than the server does) but if I want a 'set it and forget it' system I prefer the more autonomous SQL Server.
ASE's next interim release is supposed to have a built-in scheduler feature much like SQL Server. It will have a number of prefab T-SQL templates built in to do things like backups, growing database devices, etc. which helps narrow the feature gap.
ASEs replication, via Sybase Replication Server, is much better than SQL Servers built-in replication. However it is a stand-alone product which costs additional money. ASE does contain ASE Replicator which is a small-scale replication system (I think it maxes out at something like 15 transactions per second) but can be useful if your replication needs are not as demanding for Rep Server.
You can run ASE on Solaris, AIX, Windows, Linux, etc. however SQL Server only runs on the Windows NT family. This can be a big plus if you have competent Unix admins because they can generally tune the system to outperform comparable Windows systems.|||MattR, I was with you up to your last sentance. I have seen Oracle, Sybase and SQL Server run head to head, 10 CPU boxes, 8 + gig of memory and large drive arrays each tunned for the OS/RDBMS. Of course each did some thinges better than the others but at the end of the day there was no "CLEAR" winner. Now that observation was based only on performance. Facter in cost of ownership, cost to impliment, available developers, code base etc... and it was a diffrent picture all together.
Rea, Botton line here is each RDBMS has sommething to offer over the other, you have to look at your needs and decide whit fits your needs best. If the majority of your servers run Unix and the majority of your DB apps use Sybase one has to ask what the benafits of running a few systems under NT/SQL Server are for the company!|||Paul,
That's just my pro-unix bias coming in. :) Generally we've seen more stability from our unix boxen than our NT (NT meaning 2000 and now XP) ones -- I attribute that to better admins being able to poke more at the OS (Linux for example can be ripped apart and pieced back together). But of course we're talking minor differences -- something like a weekly (now more like monthly) reboot on NT on off-peak hours vs. a quarterly one 'for good measure' on the unix ones.
But yes performance shouldnt be the deciding factor you have to take the big picture (TCO) into account.|||Matt, I would clearly take Unix of almost any flavor over a Windows OS. Our NT servers generally run 6 months before needing a reboot but some of our HP servers running HPUX have been up for almost two years!|||I have worked on both the system as a DBA and my personal feeling is that given a choice I would always recommend Sql Server over any database.Reason being Cheap,easily avaliable(resources),a very good tech support,easy to maintain and lot's and lot's of other benefits.
With Sql Server you can reach to the bottom of the problem(Profiler is a great help).
There are some plus points with Sybase which would have been nice with Sql server(like password expring,locking the account),but hey you don't get all the things in one DB.
We were so happy the day we moved from Sybase to Sql Server.
With Sql Server you can control the access of different users at different levels like 'db_dataread/write/denyread/denywrite'.
I would suggest that 'do what everyone is doing and Sql Server is the best choice' specially when you compare Sql Server with ASE.
Just take a small example : You post a Sql Server related problem at www.dbforums.com and within the first one hour you will get the reply,not so with ASE.
;)|||Thanks All of you for your input. Is there any performance gains? Mostly I've heard for very large databse SYbase can handle very well than MS SQL Server, Is it true?|||No, I guarantee you if Sybase is installed on a server with to few resources it will suck wind big time as will SQL Server.
The question should be, what is the hardware cost to properly configure a server to run Sybase Vs SQL Server for MY environment. 8 cpu Sun boxes are cheaper the 8 cpu Intel boxes.|||One more thing with Sybase you need a DBA for things like Backup and Restore,increasing the database size etc etc.
Also the performance is good with Sql Server,it's way way ahead of Sybase.
We have Trading Applications (Equities & Portfolio written on C++) on MS SQL Server 2000. Now the management is deciding to move it on Sybase 12.5. We currently don't have any issues on any matter, but because everyone is SYbase fan here, thinks applications are critical and we need to move to Sybase. Can anyone who has worked on both knows the major pros & cons of both the system. Actually I wanted these systems to be on MS SQL Server. I need solid reasons except being cheaper than Sybase to show why we should use MS SQL Server
If anyone can share their experiences, it would be really great.
Thanks
ReaI have used both Sybase ASE and MS SQL Server 2000 in mission-critical systems. Up front I will say that I personally prefer ASE.
ASE and SQL Server have much the same base T-SQL syntax. However SQL Server has introduced a number of functions to do analytics that Sybase thought best to place into a separate product, Sybase IQ. So if you are using CUBE and other functions they will have to be re-written in T-SQL or application logic.
Both ASE and SQL Server have triggers and stored procedures that use T-SQL.
ASE and SQL Server both support user defined datatypes, have identical clustered index approaches, and offer much the same stored procedures to administer the DBMS.
SQL Server has sort of implicit locking scheme in which SQL server will dynamically choose row or page locking (and of course table). ASE requires you to explicitly state whether the granularity of locks are row or page, and a row-lock table cannot lock a data page and vice versa.
ASE has a wider array of tuning tools to change parameters and such. SQL Server has more built-in 'self tuning' tools and can auto-grow devices, auto-backup, etc. Having administered both I prefer ASE's if I have a mission-critical DB that I can devote time to (since our DBAs tend to know more than the server does) but if I want a 'set it and forget it' system I prefer the more autonomous SQL Server.
ASE's next interim release is supposed to have a built-in scheduler feature much like SQL Server. It will have a number of prefab T-SQL templates built in to do things like backups, growing database devices, etc. which helps narrow the feature gap.
ASEs replication, via Sybase Replication Server, is much better than SQL Servers built-in replication. However it is a stand-alone product which costs additional money. ASE does contain ASE Replicator which is a small-scale replication system (I think it maxes out at something like 15 transactions per second) but can be useful if your replication needs are not as demanding for Rep Server.
You can run ASE on Solaris, AIX, Windows, Linux, etc. however SQL Server only runs on the Windows NT family. This can be a big plus if you have competent Unix admins because they can generally tune the system to outperform comparable Windows systems.|||MattR, I was with you up to your last sentance. I have seen Oracle, Sybase and SQL Server run head to head, 10 CPU boxes, 8 + gig of memory and large drive arrays each tunned for the OS/RDBMS. Of course each did some thinges better than the others but at the end of the day there was no "CLEAR" winner. Now that observation was based only on performance. Facter in cost of ownership, cost to impliment, available developers, code base etc... and it was a diffrent picture all together.
Rea, Botton line here is each RDBMS has sommething to offer over the other, you have to look at your needs and decide whit fits your needs best. If the majority of your servers run Unix and the majority of your DB apps use Sybase one has to ask what the benafits of running a few systems under NT/SQL Server are for the company!|||Paul,
That's just my pro-unix bias coming in. :) Generally we've seen more stability from our unix boxen than our NT (NT meaning 2000 and now XP) ones -- I attribute that to better admins being able to poke more at the OS (Linux for example can be ripped apart and pieced back together). But of course we're talking minor differences -- something like a weekly (now more like monthly) reboot on NT on off-peak hours vs. a quarterly one 'for good measure' on the unix ones.
But yes performance shouldnt be the deciding factor you have to take the big picture (TCO) into account.|||Matt, I would clearly take Unix of almost any flavor over a Windows OS. Our NT servers generally run 6 months before needing a reboot but some of our HP servers running HPUX have been up for almost two years!|||I have worked on both the system as a DBA and my personal feeling is that given a choice I would always recommend Sql Server over any database.Reason being Cheap,easily avaliable(resources),a very good tech support,easy to maintain and lot's and lot's of other benefits.
With Sql Server you can reach to the bottom of the problem(Profiler is a great help).
There are some plus points with Sybase which would have been nice with Sql server(like password expring,locking the account),but hey you don't get all the things in one DB.
We were so happy the day we moved from Sybase to Sql Server.
With Sql Server you can control the access of different users at different levels like 'db_dataread/write/denyread/denywrite'.
I would suggest that 'do what everyone is doing and Sql Server is the best choice' specially when you compare Sql Server with ASE.
Just take a small example : You post a Sql Server related problem at www.dbforums.com and within the first one hour you will get the reply,not so with ASE.
;)|||Thanks All of you for your input. Is there any performance gains? Mostly I've heard for very large databse SYbase can handle very well than MS SQL Server, Is it true?|||No, I guarantee you if Sybase is installed on a server with to few resources it will suck wind big time as will SQL Server.
The question should be, what is the hardware cost to properly configure a server to run Sybase Vs SQL Server for MY environment. 8 cpu Sun boxes are cheaper the 8 cpu Intel boxes.|||One more thing with Sybase you need a DBA for things like Backup and Restore,increasing the database size etc etc.
Also the performance is good with Sql Server,it's way way ahead of Sybase.
Monday, February 20, 2012
Microsoft sql server smo
Im trying to use
Microsoft.SqlServer.Management.Smo
to load a dropdown of available sql server databases.
On my computer it works fine but when i try and run the application on my virtual it throws and unhandled exception that it couldn't load SMO assembly. I know this is because 2005 isn't installed on my virtual but i want to be able to catch this error and just ignore it and load a blank dropdown. I tried putting try catch blocks around the load but it still errors. I then tried instead of importing it i tried to reference smo by using the whole name inside of my try catch block.
Does anyone know how to catch this error
Try' Create a new connection to the selected server nameDim srvConnAs New Microsoft.SqlServer.Management.Common.ServerConnection(txtServerName.Text)Dim srvSqlAs Microsoft.SqlServer.Management.Smo.Server' Log in using SQL authentication instead of Windows authentication srvConn.LoginSecure =False' Give the login username srvConn.Login = txtUserID.Text' Give the login password srvConn.Password = txtPassword.Text' Create a new SQL Server object using the connection we created srvSql =New Microsoft.SqlServer.Management.Smo.Server(srvConn)' Loop through the databases listFor Each dbServerAs Microsoft.SqlServer.Management.Smo.DatabaseIn srvSql.Databases' Add database to combobox txtDatabase.Items.Add(dbServer.Name)Next Catch exAs Exception MsgBox(ex.Message)End Try
I know this is because 2005 isn't installed on my virtual but i want to be able to catch this error and just ignore it and load a blank dropdown
smo object should work on a sql 2000 server, I have done it before. What is th exact error message your getting?
|||What i have read tells me that smo is new in 2005 and does not work in 2000. But any case i want to ignore this error and just populate the dropdowns as blank if no sql server is installed at all.
The exact error message is:
Could not load file or assembly Microsoft.SqlServer.SMO
Version 9.0.242.0, Culture=neutral
PublicKey Token=89845dcd8080cc91 or one of its dependencies. The system cannot find the file specified
Microsoft SQL Server Management Studio SP2 upgrade
Hi
Having an issue after sp2 install on SQl 2005. The problem I am having is
when I try to open the Maintenance Plans applet in system manager. I get the
following error:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
--
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
--
BUTTONS:
OK
--
I do not see any of the previse jobs the only thing I get is this error.
Any help is appreciated.
Dell Poweredge 1950
Windows 2003 STD sp2
Intel Xeon 3.2
4.0 gb Ram
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCPDid you upgrade the client tools but not the server instance (database
services)?
--
Aaron Bertrand
SQL Server MVP
"jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> Hi
> Having an issue after sp2 install on SQl 2005. The problem I am having is
> when I try to open the Maintenance Plans applet in system manager. I get
> the
> following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'from_msx'.
> Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I do not see any of the previse jobs the only thing I get is this error.
> Any help is appreciated.
> Dell Poweredge 1950
> Windows 2003 STD sp2
> Intel Xeon 3.2
> 4.0 gb Ram
> --
> Joel Cavazos
> Network Administrator
> MCSE, MCSA, MCP|||Aaron
Going back thur the update summary log I did find that thier was a error in
the update process regarding the database services the error is:
----
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (1067) The process terminated unexpectedly.
----
Sorry I totally missed this.
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCP
"Aaron Bertrand [SQL Server MVP]" wrote:
> Did you upgrade the client tools but not the server instance (database
> services)?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
> news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> > Hi
> >
> > Having an issue after sp2 install on SQl 2005. The problem I am having is
> > when I try to open the Maintenance Plans applet in system manager. I get
> > the
> > following error:
> >
> > TITLE: Microsoft SQL Server Management Studio
> > --
> >
> > Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> >
> > Invalid column name 'from_msx'.
> > Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >
> > I do not see any of the previse jobs the only thing I get is this error.
> > Any help is appreciated.
> >
> > Dell Poweredge 1950
> > Windows 2003 STD sp2
> > Intel Xeon 3.2
> > 4.0 gb Ram
> > --
> > Joel Cavazos
> > Network Administrator
> > MCSE, MCSA, MCP
>
>
Having an issue after sp2 install on SQl 2005. The problem I am having is
when I try to open the Maintenance Plans applet in system manager. I get the
following error:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
--
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
--
BUTTONS:
OK
--
I do not see any of the previse jobs the only thing I get is this error.
Any help is appreciated.
Dell Poweredge 1950
Windows 2003 STD sp2
Intel Xeon 3.2
4.0 gb Ram
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCPDid you upgrade the client tools but not the server instance (database
services)?
--
Aaron Bertrand
SQL Server MVP
"jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> Hi
> Having an issue after sp2 install on SQl 2005. The problem I am having is
> when I try to open the Maintenance Plans applet in system manager. I get
> the
> following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'from_msx'.
> Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I do not see any of the previse jobs the only thing I get is this error.
> Any help is appreciated.
> Dell Poweredge 1950
> Windows 2003 STD sp2
> Intel Xeon 3.2
> 4.0 gb Ram
> --
> Joel Cavazos
> Network Administrator
> MCSE, MCSA, MCP|||Aaron
Going back thur the update summary log I did find that thier was a error in
the update process regarding the database services the error is:
----
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (1067) The process terminated unexpectedly.
----
Sorry I totally missed this.
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCP
"Aaron Bertrand [SQL Server MVP]" wrote:
> Did you upgrade the client tools but not the server instance (database
> services)?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
> news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> > Hi
> >
> > Having an issue after sp2 install on SQl 2005. The problem I am having is
> > when I try to open the Maintenance Plans applet in system manager. I get
> > the
> > following error:
> >
> > TITLE: Microsoft SQL Server Management Studio
> > --
> >
> > Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> >
> > Invalid column name 'from_msx'.
> > Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >
> > I do not see any of the previse jobs the only thing I get is this error.
> > Any help is appreciated.
> >
> > Dell Poweredge 1950
> > Windows 2003 STD sp2
> > Intel Xeon 3.2
> > 4.0 gb Ram
> > --
> > Joel Cavazos
> > Network Administrator
> > MCSE, MCSA, MCP
>
>
Microsoft SQL Server Management Studio SP2 upgrade
Hi
Having an issue after sp2 install on SQl 2005. The problem I am having is
when I try to open the Maintenance Plans applet in system manager. I get th
e
following error:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
BUTTONS:
OK
--
I do not see any of the previse jobs the only thing I get is this error.
Any help is appreciated.
Dell Poweredge 1950
Windows 2003 STD sp2
Intel Xeon 3.2
4.0 gb Ram
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCPDid you upgrade the client tools but not the server instance (database
services)?
Aaron Bertrand
SQL Server MVP
"jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> Hi
> Having an issue after sp2 install on SQl 2005. The problem I am having is
> when I try to open the Maintenance Plans applet in system manager. I get
> the
> following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'from_msx'.
> Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I do not see any of the previse jobs the only thing I get is this error.
> Any help is appreciated.
> Dell Poweredge 1950
> Windows 2003 STD sp2
> Intel Xeon 3.2
> 4.0 gb Ram
> --
> Joel Cavazos
> Network Administrator
> MCSE, MCSA, MCP|||Aaron
Going back thur the update summary log I did find that thier was a error in
the update process regarding the database services the error is:
----
--
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (1067) The process terminated unexpectedly.
----
--
Sorry I totally missed this.
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCP
"Aaron Bertrand [SQL Server MVP]" wrote:
> Did you upgrade the client tools but not the server instance (database
> services)?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
> news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
>
>
Having an issue after sp2 install on SQl 2005. The problem I am having is
when I try to open the Maintenance Plans applet in system manager. I get th
e
following error:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
BUTTONS:
OK
--
I do not see any of the previse jobs the only thing I get is this error.
Any help is appreciated.
Dell Poweredge 1950
Windows 2003 STD sp2
Intel Xeon 3.2
4.0 gb Ram
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCPDid you upgrade the client tools but not the server instance (database
services)?
Aaron Bertrand
SQL Server MVP
"jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> Hi
> Having an issue after sp2 install on SQl 2005. The problem I am having is
> when I try to open the Maintenance Plans applet in system manager. I get
> the
> following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'from_msx'.
> Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I do not see any of the previse jobs the only thing I get is this error.
> Any help is appreciated.
> Dell Poweredge 1950
> Windows 2003 STD sp2
> Intel Xeon 3.2
> 4.0 gb Ram
> --
> Joel Cavazos
> Network Administrator
> MCSE, MCSA, MCP|||Aaron
Going back thur the update summary log I did find that thier was a error in
the update process regarding the database services the error is:
----
--
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (1067) The process terminated unexpectedly.
----
--
Sorry I totally missed this.
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCP
"Aaron Bertrand [SQL Server MVP]" wrote:
> Did you upgrade the client tools but not the server instance (database
> services)?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
> news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
>
>
Microsoft SQL Server Management Studio problem
The 'Reports' button on the Summary screen is disabled. How can I get it enabled so that I can view the database dashboard?
I have installed SQL Server 2005 Developer Edition with Reporting services
ThanksThe Reports button is context sensitive. In the object browser, click/highlight your database, then the reports button should be enabled. A
> The 'Reports' button on the Summary screen is disabled. How can I get it
> enabled so that I can view the database dashboard? >
> I have installed SQL Server 2005 Developer Edition with Reporting
> services >
> Thanks
>|||That is right. It is context specific. It is enabled when a DB is selected and similarly, the report button is enabled when server is selected to see server dashbord.
Microsoft SQL Server Management Studio Express Version to use for SQL Compact
Hello,
i don't know if it was mentioned before, but i solved the issue that Microsoft SQL Server Management Studio Express won't show the option to create/modify a sql compact database by installing not this Version:
Microsoft SQL Server Management Studio Express
Date: 19.04.2006
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en
but this one:
SQL Server Management Studio Express Service Pack 2 – CTP-Version
Date: 19.12.2006
http://www.microsoft.com/downloads/details.aspx?FamilyID=ccbda432-8ecf-4c82-bdef-b575eaf07f55&DisplayLang=en
hope this helps.
Nihat
P.S. i'm curious if anybody else had the same issue, caused of using the wrong Version of SSMSe?
Great,
I have been looking for a version that does this I found the link above didnt work though:
this one did for me anyway.
http://www.microsoft.com/downloads/details.aspx?FamilyID=6053c6f8-82c8-479c-b25b-9aca13141c9e&DisplayLang=en
thanks
Microsoft SQL Server Management Studio Express Version to use for SQL Compact
Hello,
i don't know if it was mentioned before, but i solved the issue that Microsoft SQL Server Management Studio Express won't show the option to create/modify a sql compact database by installing not this Version:
Microsoft SQL Server Management Studio Express
Date: 19.04.2006
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en
but this one:
SQL Server Management Studio Express Service Pack 2 – CTP-Version
Date: 19.12.2006
http://www.microsoft.com/downloads/details.aspx?FamilyID=ccbda432-8ecf-4c82-bdef-b575eaf07f55&DisplayLang=en
hope this helps.
Nihat
P.S. i'm curious if anybody else had the same issue, caused of using the wrong Version of SSMSe?
Great,
I have been looking for a version that does this I found the link above didnt work though:
this one did for me anyway.
http://www.microsoft.com/downloads/details.aspx?FamilyID=6053c6f8-82c8-479c-b25b-9aca13141c9e&DisplayLang=en
thanks
Microsoft SQL Server Management Studio Express Problem
Microsoft SQL Server Management Studio Express
I have restored the database into it with 100tables and stored procedures.
I have also created the new database in it.
But,i don't know how to add the existing database in to Visual Studio.Net 2005 .I m using ASP.Net.
Where are the database stored ??
I don't want to create the new database,.
Can anyone pls tell me ...
Hi,
To add an existing database .mdf file to SQL Server, you can use Attach. Here are the steps.
1. Copy the .mdf file and .ldf(if exists) to another folder.
2. Right click on Databases, and select Attach from the popup menu.
3. In the Attach Databases dialog box, click Add button and select the .mdf file.
4. Click OK to finish, and the database will be attached to your database list in Management Studio.
HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!
Microsoft SQL Server Management Studio Express Load Error!
Hi,
I was using MSSMSE till yesterday absolutely with no problem from last 6
months.
But suddenly when I tried to open it this morning, it said Package
'Microsoft SQL Management Studio Package' failed to load.
Then I reinstalled , (repaired) this package twice. But no luck. Still it
gives same error upon opening. I can't manage my SQL database without it.
Does anyone know what is this and how to fix it?
Your help will be really appreciated.
Thanks & Tegards,
Sujata
Hi,
I am getting the exact same error with the Standard edition. Reinstallation
didn't help either.
Does anyone else have the same problem?
Thanks,
Jim
"Sujata P" wrote:
> Hi,
> I was using MSSMSE till yesterday absolutely with no problem from last 6
> months.
> But suddenly when I tried to open it this morning, it said Package
> 'Microsoft SQL Management Studio Package' failed to load.
> Then I reinstalled , (repaired) this package twice. But no luck. Still it
> gives same error upon opening. I can't manage my SQL database without it.
> Does anyone know what is this and how to fix it?
> Your help will be really appreciated.
> Thanks & Tegards,
> Sujata
I was using MSSMSE till yesterday absolutely with no problem from last 6
months.
But suddenly when I tried to open it this morning, it said Package
'Microsoft SQL Management Studio Package' failed to load.
Then I reinstalled , (repaired) this package twice. But no luck. Still it
gives same error upon opening. I can't manage my SQL database without it.
Does anyone know what is this and how to fix it?
Your help will be really appreciated.
Thanks & Tegards,
Sujata
Hi,
I am getting the exact same error with the Standard edition. Reinstallation
didn't help either.
Does anyone else have the same problem?
Thanks,
Jim
"Sujata P" wrote:
> Hi,
> I was using MSSMSE till yesterday absolutely with no problem from last 6
> months.
> But suddenly when I tried to open it this morning, it said Package
> 'Microsoft SQL Management Studio Package' failed to load.
> Then I reinstalled , (repaired) this package twice. But no luck. Still it
> gives same error upon opening. I can't manage my SQL database without it.
> Does anyone know what is this and how to fix it?
> Your help will be really appreciated.
> Thanks & Tegards,
> Sujata
Microsoft SQL Server Management Studio Express Error At Started!!!
有关调用实时(JIT)调试而不是此对话框的详细信息，
请参见此消息的结尾。
************** 异常文本 **************
System.IO.IOException: 无法在易变父项下创建稳定子项。
在 Microsoft.Win32.RegistryKey.Win32Error(Int32 errorCode, String str)
在 Microsoft.Win32.RegistryKey.CreateSubKey(String subkey, RegistryKeyPermissionCheck permissionCheck, RegistrySecurity registrySecurity)
在 Microsoft.Win32.RegistryKey.CreateSubKey(String subkey)
在 Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.CreateKeyValueIfNotExist(String regPath, String keyName)
在 Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.RegisterLocalInstancesIfFirstTimeUser()
在 Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnLoad(EventArgs e)
在 System.Windows.Forms.Form.OnCreateControl()
在 System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
在 System.Windows.Forms.Control.CreateControl()
在 System.Windows.Forms.Control.WmShowWindow(Message& m)
在 System.Windows.Forms.Control.WndProc(Message& m)
在 System.Windows.Forms.ScrollableControl.WndProc(Message& m)
在 System.Windows.Forms.ContainerControl.WndProc(Message& m)
在 System.Windows.Forms.Form.WmShowWindow(Message& m)
在 System.Windows.Forms.Form.WndProc(Message& m)
在 System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
在 System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
在 System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** 已加载的程序集 **************
mscorlib
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-
Microsoft.SqlServer.Express.AppIDPackage
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.AppIDPackage.DLL
-
Microsoft.SqlServer.Express.VSIntegration
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.VSIntegration.DLL
-
Microsoft.VisualStudio.Shell.Interop
程序集版本: 7.1.40304.0
Win32 版本: 7.0.4054
基本代码: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
-
Microsoft.VisualStudio.OLE.Interop
程序集版本: 7.1.40304.0
Win32 版本: 7.0.4054
基本代码: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
-
System
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
System.Windows.Forms
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System.Drawing
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
Microsoft.SqlServer.Express.SqlTDiagM
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlTDiagM.DLL
-
Microsoft.DataWarehouse.SQM
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
-
Microsoft.SqlServer.Instapi
程序集版本: 9.0.242.0
Win32 版本: 9.00.1399.00
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
-
Microsoft.SqlServer.Express.ObjectExplorer
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ObjectExplorer.DLL
-
Microsoft.SqlServer.Express.ConnectionDlg
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ConnectionDlg.DLL
-
System.Windows.Forms.resources
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_zh-CHS_b77a5c561934e089/System.Windows.Forms.resources.dll
-
Microsoft.SqlServer.Express.RegSvrEnum
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.RegSvrEnum.DLL
-
Microsoft.SqlServer.Express.CustomControls
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.CustomControls.DLL
-
Microsoft.SqlServer.Express.SqlWorkbench.Interfaces
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlWorkbench.Interfaces.DLL
-
Accessibility
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
-
System.Data
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
-
Microsoft.VisualStudio.TextManager.Interop
程序集版本: 7.1.40304.0
Win32 版本: 7.0.4054
基本代码: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
-
Microsoft.SqlServer.Express.SqlMgmt
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlMgmt.DLL
-
Microsoft.SqlServer.Express.SQLEditors
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SQLEditors.DLL
-
Microsoft.SqlServer.Express.ConnectionInfo
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ConnectionInfo.DLL
-
EnvDTE
程序集版本: 8.0.0.0
Win32 版本: 8.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
-
Microsoft.SqlServer.Express.SqlEnum
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlEnum.DLL
-
Microsoft.NetEnterpriseServers.Express.ExceptionMessageBox
程序集版本: 9.0.242.0
Win32 版本: 9.00.2047.00
基本代码: file:///E:/Share%20Prg/MSSQL2005EXP/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.NetEnterpriseServers.Express.ExceptionMessageBox.DLL
-
System.Xml
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
-
mscorlib.resources
程序集版本: 2.0.0.0
Win32 版本: 2.0.50727.42 (RTM.050727-4200)
基本代码: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-
************** JIT 调试 **************
要启用实时(JIT)调试，
该应用程序或计算机的 .config 文件(machine.config)的 system.windows.forms 节中必须设置
jitDebugging 值。
编译应用程序时还必须启用
调试。
例如:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
启用 JIT 调试后，任何无法处理的异常
都将被发送到在此计算机上注册的 JIT 调试器，
而不是由此对话框处理。
I'm going to let the SSMSE guys handle this - moving to the Tools forum.
Mike
Microsoft SQL Server Management Studio Express - Release Date?
Does anyone know if Microsoft has set a release date for Microsoft SQL Serve
r
Management Studio Express? I haven't been able to find any info on their we
b
site, so my guess is no.
Thanks,
JohnHi JohnJohn,
Last I saw just said early this year.
HTH,
Greg
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:23AE3017-67D0-4C0F-BFB1-66D1B08FADF5@.microsoft.com...
> Does anyone know if Microsoft has set a release date for Microsoft SQL
> Server
> Management Studio Express? I haven't been able to find any info on their
> web
> site, so my guess is no.
> Thanks,
> John
r
Management Studio Express? I haven't been able to find any info on their we
b
site, so my guess is no.
Thanks,
JohnHi JohnJohn,
Last I saw just said early this year.
HTH,
Greg
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:23AE3017-67D0-4C0F-BFB1-66D1B08FADF5@.microsoft.com...
> Does anyone know if Microsoft has set a release date for Microsoft SQL
> Server
> Management Studio Express? I haven't been able to find any info on their
> web
> site, so my guess is no.
> Thanks,
> John
Microsoft SQL Server Management Studio Express - Release Date?
Does anyone know if Microsoft has set a release date for Microsoft SQL Server
Management Studio Express? I haven't been able to find any info on their web
site, so my guess is no. :)
Thanks,
JohnHi JohnJohn,
Last I saw just said early this year.
HTH,
Greg
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:23AE3017-67D0-4C0F-BFB1-66D1B08FADF5@.microsoft.com...
> Does anyone know if Microsoft has set a release date for Microsoft SQL
> Server
> Management Studio Express? I haven't been able to find any info on their
> web
> site, so my guess is no. :)
> Thanks,
> John
Management Studio Express? I haven't been able to find any info on their web
site, so my guess is no. :)
Thanks,
JohnHi JohnJohn,
Last I saw just said early this year.
HTH,
Greg
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:23AE3017-67D0-4C0F-BFB1-66D1B08FADF5@.microsoft.com...
> Does anyone know if Microsoft has set a release date for Microsoft SQL
> Server
> Management Studio Express? I haven't been able to find any info on their
> web
> site, so my guess is no. :)
> Thanks,
> John
Microsoft SQL Server Management Studio Express - Release Date?
Does anyone know if Microsoft has set a release date for Microsoft SQL Server
Management Studio Express? I haven't been able to find any info on their web
site, so my guess is no.
Thanks,
John
Hi JohnJohn,
Last I saw just said early this year.
HTH,
Greg
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:23AE3017-67D0-4C0F-BFB1-66D1B08FADF5@.microsoft.com...
> Does anyone know if Microsoft has set a release date for Microsoft SQL
> Server
> Management Studio Express? I haven't been able to find any info on their
> web
> site, so my guess is no.
> Thanks,
> John
Management Studio Express? I haven't been able to find any info on their web
site, so my guess is no.
Thanks,
John
Hi JohnJohn,
Last I saw just said early this year.
HTH,
Greg
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:23AE3017-67D0-4C0F-BFB1-66D1B08FADF5@.microsoft.com...
> Does anyone know if Microsoft has set a release date for Microsoft SQL
> Server
> Management Studio Express? I haven't been able to find any info on their
> web
> site, so my guess is no.
> Thanks,
> John
Subscribe to:
Posts (Atom)