migrate dynamic properties

hi,

How do you migrate dynamic properties? I think successful rate is 0% in my tests. Does anyone have an example to show me?

What do you mean "dynamic properties"? Package configurations?|||

hi, I think your looking for this information. Its a good idea to review the whole article but pasted below what I believe is the relevant information.

SQL Server 2005 Books Online

Known Package Migration Issues

http://msdn2.microsoft.com/en-us/library/ms143462.aspx

Replace functionality of Dynamic Properties task after package migration

The SQL Server 2005 Integration Services (SSIS) Package Migration Wizard does not migrate Dynamic Properties tasks in SQL Server 2000 Data Transformation Services (DTS) packages. After migration, you must manually edit the resulting SSIS package to restore former package behavior.

Corrective action: After migration, re-create the functionality of the Dynamic Properties task by using Integration Services features such as variables, property expressions, and package configurations. For more information, see Integration Services Variables and Using Variables in Packages; Using Property Expressions in Packages; and Package Configurations.

Microsoft's AdventureWorks CTE example - different ordering desired

I pulled this example from Books Online. I cannot figure out how to make
the CTE return the data in a different order.
I don't want the data ordered by the Level. I want the child data to appear
directly under the parent data. Is that possible?
USE AdventureWorks;
GO
WITH DirectReports (ManagerID, EmployeeID, Title, DeptID, Level)
AS
(
-- Anchor member definition
SELECT e.ManagerID, e.EmployeeID, e.Title, edh.DepartmentID, 0 AS Level
FROM HumanResources.Employee AS e
INNER JOIN HumanResources.EmployeeDepartmentHistory AS edh
ON e.EmployeeID = edh.EmployeeID AND edh.EndDate IS NULL
WHERE ManagerID IS NULL
UNION ALL
-- Recursive member definition
SELECT e.ManagerID, e.EmployeeID, e.Title, edh.DepartmentID, Level + 1
FROM HumanResources.Employee AS e
INNER JOIN HumanResources.EmployeeDepartmentHistory AS edh
ON e.EmployeeID = edh.EmployeeID AND edh.EndDate IS NULL
INNER JOIN DirectReports AS d
ON e.ManagerID = d.EmployeeID
)
-- Statement that executes the CTE
SELECT ManagerID, EmployeeID, Title, Level
FROM DirectReports
INNER JOIN HumanResources.Department AS dp
ON DirectReports.DeptID = dp.DepartmentID
WHERE dp.GroupName = N'Research and Development' OR Level = 0
GO
-- Here is the output from the CTE:
ManagerID EmployeeID Title
Level
-- -- ---- -
--
NULL 109 Chief Executive Officer 0
109 12 Vice President of Engineering 1
12 3 Engineering Manager 2
3 4 Senior Tool Designer 3
3 9 Design Engineer 3
3 11 Design Engineer 3
3 158 Research and Development Manager 3
3 263 Senior Tool Designer 3
3 267 Senior Design Engineer 3
3 270 Design Engineer 3
263 5 Tool Designer 4
263 265 Tool Designer 4
158 79 Research and Development Engineer 4
158 114 Research and Development Engineer 4
158 217 Research and Development Manager 4
-- Here is my desired output:
ManagerID EmployeeID Title
Level
-- -- ---- -
--
NULL 109 Chief Executive Officer 0
109 12 Vice President of Engineering 1
12 3 Engineering Manager 2
3 9 Design Engineer 3
3 11 Design Engineer 3
3 270 Design Engineer 3
3 158 Research and Development Manager 3
158 79 Research and Development Engineer 4
158 114 Research and Development Engineer 4
158 217 Research and Development Manager 4
3 267 Senior Design Engineer 3
3 263 Senior Tool Designer 3
263 5 Tool Designer 4
263 265 Tool Designer 4
3 4 Senior Tool Designer 3
Keith KratochvilKeith,
Here is an idea:
USE AdventureWorks;
GO
WITH DirectReports (ManagerID, EmployeeID, Title, DeptID, Level,
PathToLevel)
AS
(
-- Anchor member definition
SELECT e.ManagerID, e.EmployeeID, e.Title, edh.DepartmentID, 0 AS Level,
CAST(N'.' AS nvarchar(50)) AS PathToLevel
FROM HumanResources.Employee AS e
INNER JOIN HumanResources.EmployeeDepartmentHistory AS edh
ON e.EmployeeID = edh.EmployeeID AND edh.EndDate IS NULL
WHERE ManagerID IS NULL
UNION ALL
-- Recursive member definition
SELECT e.ManagerID, e.EmployeeID, e.Title, edh.DepartmentID, Level + 1,
CAST(PathToLevel+CAST(e.EmployeeId AS nvarchar(5))+N'.' AS nvarchar(50))
FROM HumanResources.Employee AS e
INNER JOIN HumanResources.EmployeeDepartmentHistory AS edh
ON e.EmployeeID = edh.EmployeeID AND edh.EndDate IS NULL
INNER JOIN DirectReports AS d
ON e.ManagerID = d.EmployeeID
)
-- Statement that executes the CTE
SELECT ManagerID, EmployeeID, Title, Level, PathToLevel
FROM DirectReports
INNER JOIN HumanResources.Department AS dp
ON DirectReports.DeptID = dp.DepartmentID
WHERE dp.GroupName = N'Research and Development' OR Level = 0
ORDER BY PathToLevel
GO
Dejan Sarka
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OufHP8liGHA.4284@.TK2MSFTNGP05.phx.gbl...
>I pulled this example from Books Online. I cannot figure out how to make
>the CTE return the data in a different order.
> I don't want the data ordered by the Level. I want the child data to
> appear directly under the parent data. Is that possible?
>
> USE AdventureWorks;
> GO
> WITH DirectReports (ManagerID, EmployeeID, Title, DeptID, Level)
> AS
> (
> -- Anchor member definition
> SELECT e.ManagerID, e.EmployeeID, e.Title, edh.DepartmentID, 0 AS Level
> FROM HumanResources.Employee AS e
> INNER JOIN HumanResources.EmployeeDepartmentHistory AS edh
> ON e.EmployeeID = edh.EmployeeID AND edh.EndDate IS NULL
> WHERE ManagerID IS NULL
> UNION ALL
> -- Recursive member definition
> SELECT e.ManagerID, e.EmployeeID, e.Title, edh.DepartmentID, Level + 1
> FROM HumanResources.Employee AS e
> INNER JOIN HumanResources.EmployeeDepartmentHistory AS edh
> ON e.EmployeeID = edh.EmployeeID AND edh.EndDate IS NULL
> INNER JOIN DirectReports AS d
> ON e.ManagerID = d.EmployeeID
> )
> -- Statement that executes the CTE
> SELECT ManagerID, EmployeeID, Title, Level
> FROM DirectReports
> INNER JOIN HumanResources.Department AS dp
> ON DirectReports.DeptID = dp.DepartmentID
> WHERE dp.GroupName = N'Research and Development' OR Level = 0
> GO
>
> -- Here is the output from the CTE:
> ManagerID EmployeeID Title Level
> -- -- ----
> --
> NULL 109 Chief Executive Officer
> 0
> 109 12 Vice President of Engineering
> 1
> 12 3 Engineering Manager
> 2
> 3 4 Senior Tool Designer
> 3
> 3 9 Design Engineer
> 3
> 3 11 Design Engineer
> 3
> 3 158 Research and Development Manager
> 3
> 3 263 Senior Tool Designer
> 3
> 3 267 Senior Design Engineer
> 3
> 3 270 Design Engineer
> 3
> 263 5 Tool Designer
> 4
> 263 265 Tool Designer
> 4
> 158 79 Research and Development Engineer
> 4
> 158 114 Research and Development Engineer
> 4
> 158 217 Research and Development Manager
> 4
>
> -- Here is my desired output:
> ManagerID EmployeeID Title Level
> -- -- ----
> --
> NULL 109 Chief Executive Officer
> 0
> 109 12 Vice President of Engineering
> 1
> 12 3 Engineering Manager
> 2
> 3 9 Design Engineer
> 3
> 3 11 Design Engineer
> 3
> 3 270 Design Engineer
> 3
> 3 158 Research and Development Manager
> 3
> 158 79 Research and Development Engineer
> 4
> 158 114 Research and Development Engineer
> 4
> 158 217 Research and Development Manager
> 4
> 3 267 Senior Design Engineer
> 3
> 3 263 Senior Tool Designer
> 3
> 263 5 Tool Designer
> 4
> 263 265 Tool Designer
> 4
> 3 4 Senior Tool Designer
> 3
>
> --
> Keith Kratochvil
>
>|||Thanks for the solution, Dejan. I did some more poking around within Books
Online and found this:
http://msdn2.microsoft.com/en-us/library/ms175972.aspx
F. Using a recursive common table expression to display a hierarchical list
Now I have a couple of methods that I can use.
Keith Kratochvil
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eZuw%23OmiGHA.4304@.TK2MSFTNGP03.phx.gbl...
> Keith,
> Here is an idea:
> USE AdventureWorks;
> GO
> WITH DirectReports (ManagerID, EmployeeID, Title, DeptID, Level,
> PathToLevel)
> AS
> (
> -- Anchor member definition
> SELECT e.ManagerID, e.EmployeeID, e.Title, edh.DepartmentID, 0 AS Level,
> CAST(N'.' AS nvarchar(50)) AS PathToLevel
> FROM HumanResources.Employee AS e
> INNER JOIN HumanResources.EmployeeDepartmentHistory AS edh
> ON e.EmployeeID = edh.EmployeeID AND edh.EndDate IS NULL
> WHERE ManagerID IS NULL
> UNION ALL
> -- Recursive member definition
> SELECT e.ManagerID, e.EmployeeID, e.Title, edh.DepartmentID, Level + 1,
> CAST(PathToLevel+CAST(e.EmployeeId AS nvarchar(5))+N'.' AS nvarchar(50))
> FROM HumanResources.Employee AS e
> INNER JOIN HumanResources.EmployeeDepartmentHistory AS edh
> ON e.EmployeeID = edh.EmployeeID AND edh.EndDate IS NULL
> INNER JOIN DirectReports AS d
> ON e.ManagerID = d.EmployeeID
> )
> -- Statement that executes the CTE
> SELECT ManagerID, EmployeeID, Title, Level, PathToLevel
> FROM DirectReports
> INNER JOIN HumanResources.Department AS dp
> ON DirectReports.DeptID = dp.DepartmentID
> WHERE dp.GroupName = N'Research and Development' OR Level = 0
> ORDER BY PathToLevel
> GO
> --
> Dejan Sarka
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:OufHP8liGHA.4284@.TK2MSFTNGP05.phx.gbl...
>

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

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 Visual Studio is busy

I get this message in a balloon that pops up frequently when I am trying to work in the SSIS designer. For example, I get it when working in a DataFlow task, trying to open editors for the OleDb Source and Destination. Is anyone else getting this? What could be the cause, it seems to get sluggish. Thanks.

What OLEDB drivers are you using? As a first step I would check that you have the latest version of all the OLEDB drivers, and upgrade if not.

I used to get this message constantly when using the v7 FoxPro driver. Changing to the most recent driver , v9, cured the problem completely.

Hope this helps,

Richard

|||TFYR. I'm just using the OLEDB source/destination that were installed when I upgraded my default instance to SS 2005. (I had been using SQL2005 side-by-side previously with SQL 2000). I've also noticed that when scripting objects it will also get sluggish and hangs for awhile on the step where it determines objects in the database. Right now, I've been waiting over 2 minutes to script a single proc out of the database, so I think there is some kind of systemic problem. Same problem when I try to expand some nodes in Object Explorer (Tables, procs etc), it'll be real sluggish.|||

Seems odd. Are your source and destination SQL Server machines, or something else?

Maybe the upgrade process didn't tie things together properly? As a possibility, would you be able to backup everything and do a clean uninstall/ re-install of SQL 2005?

Sorry I've not posted back earlier.

Rich

|||

Rich,

TFYR. Yes, both source/dest are SQL Server machines. And yes, I can do an uninstall/re-install but probably won't get to it until next week . Do you think it might help if I tried removing the named SQL2005 instance that I have? Not sure how I would remove a named instance, but I will look in the docs.

Thanks.

|||

Rich,

You got me thinking about uninstalling/reinstalling but before trying it I wanted to try removing my SQL2005 named instance and the performance is now much improved. I haven't gotten the "Visual Studio is busy" message yet. I don't get the long delay when scripting objects out either. Maybe it was because I had originally installed SQL2005 as a named instance side by side with SQL2005 default instance and then upgraded the default instance to SQL2005 but never removed the named instance. Anyway, it is much, much improved. Thanks.

|||Yes... i'm facing that kind of problem almost everytime. Especially when the project contains a lot of packages. After the pop-up appears, it will hang and i have to terminate the process using ctrl+alt+del. Until now, i still can't configure what d problem is! I don think it is oledb connection. I would say it is software problem.|||How much RAM do you have? I found that adding RAM helped.|||

I'm running 2 gigs of memory on a 2 ghz processor. So i know my computer isn't trash. But As of recently, every single time i open Studio I get issues with a pop-up that "Microsoft Visual Studio is busy." let microsoft know....

and it hangs for roughly 10 seconds. so if I make 20 changes to a page, that the changes themselves took me 20 seconds... i just spent (20*10 + 20) 220 seconds, or nearly 4 minutes to make a few quick changes...

Or, let's say that i like saving the pages alot, which I do, so I may copy paste a <br />, and then it locks, then i'll type something and insert a <asp:label tag, and it locks, then i'll delete the ID and insert a new id, and it locks... and maybe it locks again.

|||I can certainly understand the frustration as I was in the same predicament. I was so desperate I added RAM (increased to 1.5GB) and also purchased Registry Booster. I also removed a named instance of SQL2005 that was a remnant of a side-by-side installation with SQL2000. Whatever I did got rid of the problem and I am no longer plagued by the "Microsoft Visual Studio is busy" message.|||

Hi folks:

I have the same exact problem. I see the message Visual studio is busy. For me this started happening after I installed Visual Studio 2005. I have 1 GB memory and i have both SQL 2000 (default instance) and SQL 2005 (named instance) running on the box. I never had this issue when i was running VS.NET 2003.

I started seeing this after I uninstalled VS.NET 2003 and installed VS.NET 2005. Does anyone know if I uninstall SQL 2005 and reinstall it again the problem would be gone?.

Thanks

AK

|||

Hi there,

same problem here. Since I use SSIS development in Visual Studio in combination with Vista, Visual Studio keeps being busy after executing larger SSIS packages. Looks like a Vista problem. Before I used XP where te problem didn't occure. It partically occures when the SSIS package is handling large data volumes (more then 100000 records).

A solution would be welcome.

Thanks.

RK

Microsoft Visual Studio is busy

I get this message in a balloon that pops up frequently when I am trying to work in the SSIS designer. For example, I get it when working in a DataFlow task, trying to open editors for the OleDb Source and Destination. Is anyone else getting this? What could be the cause, it seems to get sluggish. Thanks.

What OLEDB drivers are you using? As a first step I would check that you have the latest version of all the OLEDB drivers, and upgrade if not.

I used to get this message constantly when using the v7 FoxPro driver. Changing to the most recent driver , v9, cured the problem completely.

Hope this helps,

Richard

|||TFYR. I'm just using the OLEDB source/destination that were installed when I upgraded my default instance to SS 2005. (I had been using SQL2005 side-by-side previously with SQL 2000). I've also noticed that when scripting objects it will also get sluggish and hangs for awhile on the step where it determines objects in the database. Right now, I've been waiting over 2 minutes to script a single proc out of the database, so I think there is some kind of systemic problem. Same problem when I try to expand some nodes in Object Explorer (Tables, procs etc), it'll be real sluggish.|||

Seems odd. Are your source and destination SQL Server machines, or something else?

Maybe the upgrade process didn't tie things together properly? As a possibility, would you be able to backup everything and do a clean uninstall/ re-install of SQL 2005?

Sorry I've not posted back earlier.

Rich

|||

Rich,

TFYR. Yes, both source/dest are SQL Server machines. And yes, I can do an uninstall/re-install but probably won't get to it until next week . Do you think it might help if I tried removing the named SQL2005 instance that I have? Not sure how I would remove a named instance, but I will look in the docs.

Thanks.

|||

Rich,

You got me thinking about uninstalling/reinstalling but before trying it I wanted to try removing my SQL2005 named instance and the performance is now much improved. I haven't gotten the "Visual Studio is busy" message yet. I don't get the long delay when scripting objects out either. Maybe it was because I had originally installed SQL2005 as a named instance side by side with SQL2005 default instance and then upgraded the default instance to SQL2005 but never removed the named instance. Anyway, it is much, much improved. Thanks.

|||Yes... i'm facing that kind of problem almost everytime. Especially when the project contains a lot of packages. After the pop-up appears, it will hang and i have to terminate the process using ctrl+alt+del. Until now, i still can't configure what d problem is! I don think it is oledb connection. I would say it is software problem.|||How much RAM do you have? I found that adding RAM helped.|||

I'm running 2 gigs of memory on a 2 ghz processor. So i know my computer isn't trash. But As of recently, every single time i open Studio I get issues with a pop-up that "Microsoft Visual Studio is busy." let microsoft know....

and it hangs for roughly 10 seconds. so if I make 20 changes to a page, that the changes themselves took me 20 seconds... i just spent (20*10 + 20) 220 seconds, or nearly 4 minutes to make a few quick changes...

Or, let's say that i like saving the pages alot, which I do, so I may copy paste a <br />, and then it locks, then i'll type something and insert a <asp:label tag, and it locks, then i'll delete the ID and insert a new id, and it locks... and maybe it locks again.

|||I can certainly understand the frustration as I was in the same predicament. I was so desperate I added RAM (increased to 1.5GB) and also purchased Registry Booster. I also removed a named instance of SQL2005 that was a remnant of a side-by-side installation with SQL2000. Whatever I did got rid of the problem and I am no longer plagued by the "Microsoft Visual Studio is busy" message.|||

Hi folks:

I have the same exact problem. I see the message Visual studio is busy. For me this started happening after I installed Visual Studio 2005. I have 1 GB memory and i have both SQL 2000 (default instance) and SQL 2005 (named instance) running on the box. I never had this issue when i was running VS.NET 2003.

I started seeing this after I uninstalled VS.NET 2003 and installed VS.NET 2005. Does anyone know if I uninstall SQL 2005 and reinstall it again the problem would be gone?.

Thanks

AK

Microsoft Visual Studio is busy

I get this message in a balloon that pops up frequently when I am trying to work in the SSIS designer. For example, I get it when working in a DataFlow task, trying to open editors for the OleDb Source and Destination. Is anyone else getting this? What could be the cause, it seems to get sluggish. Thanks.

What OLEDB drivers are you using? As a first step I would check that you have the latest version of all the OLEDB drivers, and upgrade if not.

I used to get this message constantly when using the v7 FoxPro driver. Changing to the most recent driver , v9, cured the problem completely.

Hope this helps,

Richard

|||TFYR. I'm just using the OLEDB source/destination that were installed when I upgraded my default instance to SS 2005. (I had been using SQL2005 side-by-side previously with SQL 2000). I've also noticed that when scripting objects it will also get sluggish and hangs for awhile on the step where it determines objects in the database. Right now, I've been waiting over 2 minutes to script a single proc out of the database, so I think there is some kind of systemic problem. Same problem when I try to expand some nodes in Object Explorer (Tables, procs etc), it'll be real sluggish.|||

Seems odd. Are your source and destination SQL Server machines, or something else?

Maybe the upgrade process didn't tie things together properly? As a possibility, would you be able to backup everything and do a clean uninstall/ re-install of SQL 2005?

Sorry I've not posted back earlier.

Rich

|||

Rich,

TFYR. Yes, both source/dest are SQL Server machines. And yes, I can do an uninstall/re-install but probably won't get to it until next week . Do you think it might help if I tried removing the named SQL2005 instance that I have? Not sure how I would remove a named instance, but I will look in the docs.

Thanks.

|||

Rich,

You got me thinking about uninstalling/reinstalling but before trying it I wanted to try removing my SQL2005 named instance and the performance is now much improved. I haven't gotten the "Visual Studio is busy" message yet. I don't get the long delay when scripting objects out either. Maybe it was because I had originally installed SQL2005 as a named instance side by side with SQL2005 default instance and then upgraded the default instance to SQL2005 but never removed the named instance. Anyway, it is much, much improved. Thanks.

|||Yes... i'm facing that kind of problem almost everytime. Especially when the project contains a lot of packages. After the pop-up appears, it will hang and i have to terminate the process using ctrl+alt+del. Until now, i still can't configure what d problem is! I don think it is oledb connection. I would say it is software problem.|||How much RAM do you have? I found that adding RAM helped.|||

I'm running 2 gigs of memory on a 2 ghz processor. So i know my computer isn't trash. But As of recently, every single time i open Studio I get issues with a pop-up that "Microsoft Visual Studio is busy." let microsoft know....

and it hangs for roughly 10 seconds. so if I make 20 changes to a page, that the changes themselves took me 20 seconds... i just spent (20*10 + 20) 220 seconds, or nearly 4 minutes to make a few quick changes...

Or, let's say that i like saving the pages alot, which I do, so I may copy paste a <br />, and then it locks, then i'll type something and insert a <asp:label tag, and it locks, then i'll delete the ID and insert a new id, and it locks... and maybe it locks again.

|||I can certainly understand the frustration as I was in the same predicament. I was so desperate I added RAM (increased to 1.5GB) and also purchased Registry Booster. I also removed a named instance of SQL2005 that was a remnant of a side-by-side installation with SQL2000. Whatever I did got rid of the problem and I am no longer plagued by the "Microsoft Visual Studio is busy" message.|||

Hi folks:

I have the same exact problem. I see the message Visual studio is busy. For me this started happening after I installed Visual Studio 2005. I have 1 GB memory and i have both SQL 2000 (default instance) and SQL 2005 (named instance) running on the box. I never had this issue when i was running VS.NET 2003.

I started seeing this after I uninstalled VS.NET 2003 and installed VS.NET 2005. Does anyone know if I uninstall SQL 2005 and reinstall it again the problem would be gone?.

Thanks

AK

Microsoft Visual Studio is busy

I get this message in a balloon that pops up frequently when I am trying to work in the SSIS designer. For example, I get it when working in a DataFlow task, trying to open editors for the OleDb Source and Destination. Is anyone else getting this? What could be the cause, it seems to get sluggish. Thanks.

What OLEDB drivers are you using? As a first step I would check that you have the latest version of all the OLEDB drivers, and upgrade if not.

I used to get this message constantly when using the v7 FoxPro driver. Changing to the most recent driver , v9, cured the problem completely.

Hope this helps,

Richard

|||TFYR. I'm just using the OLEDB source/destination that were installed when I upgraded my default instance to SS 2005. (I had been using SQL2005 side-by-side previously with SQL 2000). I've also noticed that when scripting objects it will also get sluggish and hangs for awhile on the step where it determines objects in the database. Right now, I've been waiting over 2 minutes to script a single proc out of the database, so I think there is some kind of systemic problem. Same problem when I try to expand some nodes in Object Explorer (Tables, procs etc), it'll be real sluggish.|||

Seems odd. Are your source and destination SQL Server machines, or something else?

Maybe the upgrade process didn't tie things together properly? As a possibility, would you be able to backup everything and do a clean uninstall/ re-install of SQL 2005?

Sorry I've not posted back earlier.

Rich

|||

Rich,

TFYR. Yes, both source/dest are SQL Server machines. And yes, I can do an uninstall/re-install but probably won't get to it until next week . Do you think it might help if I tried removing the named SQL2005 instance that I have? Not sure how I would remove a named instance, but I will look in the docs.

Thanks.

|||

Rich,

You got me thinking about uninstalling/reinstalling but before trying it I wanted to try removing my SQL2005 named instance and the performance is now much improved. I haven't gotten the "Visual Studio is busy" message yet. I don't get the long delay when scripting objects out either. Maybe it was because I had originally installed SQL2005 as a named instance side by side with SQL2005 default instance and then upgraded the default instance to SQL2005 but never removed the named instance. Anyway, it is much, much improved. Thanks.

|||Yes... i'm facing that kind of problem almost everytime. Especially when the project contains a lot of packages. After the pop-up appears, it will hang and i have to terminate the process using ctrl+alt+del. Until now, i still can't configure what d problem is! I don think it is oledb connection. I would say it is software problem.|||How much RAM do you have? I found that adding RAM helped.|||

I'm running 2 gigs of memory on a 2 ghz processor. So i know my computer isn't trash. But As of recently, every single time i open Studio I get issues with a pop-up that "Microsoft Visual Studio is busy." let microsoft know....

and it hangs for roughly 10 seconds. so if I make 20 changes to a page, that the changes themselves took me 20 seconds... i just spent (20*10 + 20) 220 seconds, or nearly 4 minutes to make a few quick changes...

Or, let's say that i like saving the pages alot, which I do, so I may copy paste a <br />, and then it locks, then i'll type something and insert a <asp:label tag, and it locks, then i'll delete the ID and insert a new id, and it locks... and maybe it locks again.

|||I can certainly understand the frustration as I was in the same predicament. I was so desperate I added RAM (increased to 1.5GB) and also purchased Registry Booster. I also removed a named instance of SQL2005 that was a remnant of a side-by-side installation with SQL2000. Whatever I did got rid of the problem and I am no longer plagued by the "Microsoft Visual Studio is busy" message.|||

Hi folks:

I have the same exact problem. I see the message Visual studio is busy. For me this started happening after I installed Visual Studio 2005. I have 1 GB memory and i have both SQL 2000 (default instance) and SQL 2005 (named instance) running on the box. I never had this issue when i was running VS.NET 2003.

I started seeing this after I uninstalled VS.NET 2003 and installed VS.NET 2005. Does anyone know if I uninstall SQL 2005 and reinstall it again the problem would be gone?.

Thanks

AK

|||

Hi there,

same problem here. Since I use SSIS development in Visual Studio in combination with Vista, Visual Studio keeps being busy after executing larger SSIS packages. Looks like a Vista problem. Before I used XP where te problem didn't occure. It partically occures when the SSIS package is handling large data volumes (more then 100000 records).

A solution would be welcome.

Thanks.

RK