Hi,
Our production SQL databaseâ' located on SQL Server 2005 (SP2) with 3161
version. When we use the SqlBulkCopy, the following error occurs:
System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS)
protocol stream is incorrect. The TDS headers contained errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
We searched on web site and found this
http://support.microsoft.com/kb/913177/en-us article.
Now, I want know this hot fix version is higher than 3161 or lower because
we are currently on 3161 version.
Regards,
ChenI don't think this fix affects SQL Server versioning, and doesn't seem to
have anything to do with specific SQL Server hotfixes. So, it is probably
worth a try.
There are also later builds available for SQL Server... you may want to
check cumulative updates 1 - 7 for any mention of the issue you are seeing.
The best part is, you no longer have to call CSS to get one of these
updates.
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/04/25/don-t-want-to-call-css-pss-to-get-a-cumjulative-update-you-don-t-have-to.aspx
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:34AB0521-F9E8-4249-B77C-341FDA1DA921@.microsoft.com...
> Hi,
> Our production SQL databaseâ' located on SQL Server 2005 (SP2) with 3161
> version. When we use the SqlBulkCopy, the following error occurs:
> System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS)
> protocol stream is incorrect. The TDS headers contained errors.
> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
> We searched on web site and found this
> http://support.microsoft.com/kb/913177/en-us article.
> Now, I want know this hot fix version is higher than 3161 or lower because
> we are currently on 3161 version.
> Regards,
> Chen|||Thank you very much!
"Aaron Bertrand [SQL Server MVP]" wrote:
> I don't think this fix affects SQL Server versioning, and doesn't seem to
> have anything to do with specific SQL Server hotfixes. So, it is probably
> worth a try.
> There are also later builds available for SQL Server... you may want to
> check cumulative updates 1 - 7 for any mention of the issue you are seeing.
> The best part is, you no longer have to call CSS to get one of these
> updates.
> http://sqlblog.com/blogs/aaron_bertrand/archive/2008/04/25/don-t-want-to-call-css-pss-to-get-a-cumjulative-update-you-don-t-have-to.aspx
>
>
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:34AB0521-F9E8-4249-B77C-341FDA1DA921@.microsoft.com...
> > Hi,
> > Our production SQL databaseâ' located on SQL Server 2005 (SP2) with 3161
> > version. When we use the SqlBulkCopy, the following error occurs:
> >
> > System.Data.SqlClient.SqlException: The incoming tabular data stream (TDS)
> > protocol stream is incorrect. The TDS headers contained errors.
> > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> > Boolean breakConnection)
> >
> > We searched on web site and found this
> > http://support.microsoft.com/kb/913177/en-us article.
> >
> > Now, I want know this hot fix version is higher than 3161 or lower because
> > we are currently on 3161 version.
> >
> > Regards,
> > Chen
>
Showing posts with label apply. Show all posts
Showing posts with label apply. Show all posts
Monday, March 19, 2012
Can i apply any conditon on Replication ,before publishing the data?
i want to use Replication in sql server 2000 at specified condtion ,mean if any condition is satisfied then the data is publish to subscriber database?Extracted from BOL:
Filtering Published Data
Filtering data during replication allows you to publish only the data or partitions of data that are needed at the Subscriber. You can filter data to create partitions that include only the columns and/or only the rows that you specify for replication.
With all types of replication, you can choose to copy and distribute complete tables, or data filtered horizontally or vertically with static filters. Merge replication (mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\replsql.chm::/replintro_0odv.htm#sql:merge_replication) is especially strong in filtering options, and you can use dynamic filters to customize the filter based on a property of the Subscriber receiving the data.
Filtering data horizontally allows you to publish only the data that is needed, partition data to different sites, avoid conflicts (because Subscribers will be viewing and updating different subsets of data), and manage publications based on user needs or applications.
Additionally, you have the option of employing user-defined functions in your static and dynamic filters and leveraging the power of customized functions.|||Thanks Tomh,i got the idea what you are trying to say, this can be done from filtering horizontally or vertically option when we Select Yes, I will define data filters, enable anonymous subscriptions, or customize other properties.
i am explaining what i want to do,i want to apply condition let suppose:
if users.usersId between 10 and 20
begin
-- replication perform
end
and u said in ur comments we can also use or apply user defined function can u give me example of it and where should i call this UDF.
thanks in advance :)|||I've never had to use UDFs to filter, so I don't have an example to give you.
I would suggest you do two things:
1. Experiment ... set up a test replication and work thru simple horizontal (your userid example) and vertical filtering (column subset), then when you have that working, try incorporating functions into the filtering.
2. Search the microsoft.public.sqlserver groups for more information, as well as use GOOGLE to search for user written articles to help lead you to your final result.
You will notice that most of the answers on this forum come from members working thru real life situations that have been overcome by testing and finding the many different ways things don't work before finding the one that does.
Join us and be part of the solution!|||I think a horizontally filtered replication (either merge or transactional) would work just fine for you in this situation. It seems that it would be a bit simpler since it's not dynamic (or it does not appear to be from your description).
As tomh suggested, set up a test environment and practice with it. Replication can be tedious and very involved. Learn all you can, test variouse scenarios, document the test conditions and outcomes and develop your plans accordingly.
Regards,
hmscott|||if users.usersId between 10 and 20
begin
-- replication perform
end
if users.usersId between 10 and 20
begin
exec msdb..sp_start_job 'replicationJobName'
end|||Hy guys it works when i did sample example to test data for (merge replication), from row filter and dynamic row filter we can apply conditions (like where clause)
Thnx to all u guys ur guidance very valueable for me thnx to all once again
one thing which would i want to know is that like cfr want to say to write UDF in a specific condition ,i am unable to do like this Guys do u have any idea? where i should call UDF ?
Filtering Published Data
Filtering data during replication allows you to publish only the data or partitions of data that are needed at the Subscriber. You can filter data to create partitions that include only the columns and/or only the rows that you specify for replication.
With all types of replication, you can choose to copy and distribute complete tables, or data filtered horizontally or vertically with static filters. Merge replication (mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL% 20Server\80\Tools\Books\replsql.chm::/replintro_0odv.htm#sql:merge_replication) is especially strong in filtering options, and you can use dynamic filters to customize the filter based on a property of the Subscriber receiving the data.
Filtering data horizontally allows you to publish only the data that is needed, partition data to different sites, avoid conflicts (because Subscribers will be viewing and updating different subsets of data), and manage publications based on user needs or applications.
Additionally, you have the option of employing user-defined functions in your static and dynamic filters and leveraging the power of customized functions.|||Thanks Tomh,i got the idea what you are trying to say, this can be done from filtering horizontally or vertically option when we Select Yes, I will define data filters, enable anonymous subscriptions, or customize other properties.
i am explaining what i want to do,i want to apply condition let suppose:
if users.usersId between 10 and 20
begin
-- replication perform
end
and u said in ur comments we can also use or apply user defined function can u give me example of it and where should i call this UDF.
thanks in advance :)|||I've never had to use UDFs to filter, so I don't have an example to give you.
I would suggest you do two things:
1. Experiment ... set up a test replication and work thru simple horizontal (your userid example) and vertical filtering (column subset), then when you have that working, try incorporating functions into the filtering.
2. Search the microsoft.public.sqlserver groups for more information, as well as use GOOGLE to search for user written articles to help lead you to your final result.
You will notice that most of the answers on this forum come from members working thru real life situations that have been overcome by testing and finding the many different ways things don't work before finding the one that does.
Join us and be part of the solution!|||I think a horizontally filtered replication (either merge or transactional) would work just fine for you in this situation. It seems that it would be a bit simpler since it's not dynamic (or it does not appear to be from your description).
As tomh suggested, set up a test environment and practice with it. Replication can be tedious and very involved. Learn all you can, test variouse scenarios, document the test conditions and outcomes and develop your plans accordingly.
Regards,
hmscott|||if users.usersId between 10 and 20
begin
-- replication perform
end
if users.usersId between 10 and 20
begin
exec msdb..sp_start_job 'replicationJobName'
end|||Hy guys it works when i did sample example to test data for (merge replication), from row filter and dynamic row filter we can apply conditions (like where clause)
Thnx to all u guys ur guidance very valueable for me thnx to all once again
one thing which would i want to know is that like cfr want to say to write UDF in a specific condition ,i am unable to do like this Guys do u have any idea? where i should call UDF ?
Thursday, March 8, 2012
Can custom assemblies be used to apply styles to reports
What is Custom assembly ? Can I use a custom assembly to apply styles
( bgcolor,font,height,width etc) to report elements at runtime using
reporting services coding ?
Thanks,
Anand Sagar
anandsagar@.gmail.comYou don't need a custom assembly. Click on a report item (for example, a textbox) and in the
Property Browser window (generally in the bottom-right of the Report Designer shell) and change the
desired property to an expression. For example, you could change Color to:
=iif (Parameter!BeColorful.Value = True, "Red", "Black")
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Anand Sagar" <anandsagar@.gmail.com> wrote in message
news:3f76a771.0408110538.71b356e1@.posting.google.com...
> What is Custom assembly ? Can I use a custom assembly to apply styles
> ( bgcolor,font,height,width etc) to report elements at runtime using
> reporting services coding ?
> Thanks,
> Anand Sagar
> anandsagar@.gmail.com
( bgcolor,font,height,width etc) to report elements at runtime using
reporting services coding ?
Thanks,
Anand Sagar
anandsagar@.gmail.comYou don't need a custom assembly. Click on a report item (for example, a textbox) and in the
Property Browser window (generally in the bottom-right of the Report Designer shell) and change the
desired property to an expression. For example, you could change Color to:
=iif (Parameter!BeColorful.Value = True, "Red", "Black")
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Anand Sagar" <anandsagar@.gmail.com> wrote in message
news:3f76a771.0408110538.71b356e1@.posting.google.com...
> What is Custom assembly ? Can I use a custom assembly to apply styles
> ( bgcolor,font,height,width etc) to report elements at runtime using
> reporting services coding ?
> Thanks,
> Anand Sagar
> anandsagar@.gmail.com
Subscribe to:
Posts (Atom)