replicating UDT's to subscribers

SQL Server Replication

Index ‹ SQL Server

- Previous
  - 1
    - need to changes the default port address of apache server can any one guide me how to change the default port address of apache which is 80 to any other port number. coz the default port number is taken by iis also. Tag: replicating UDT's to subscribers
  - 2
    - selecting top 20 and the rest Hi, I have a select command that returns an ID and an amount. I want to display the top 5 amounts in descending order and then the rest of them as one sum. So if the table is like: ID Amount 1 5 2 200 3 15 4 325 5 12 6 37 7 121 8 32 9 31 10 177 Then my select should display: ID Amount 4 325 2 200 10 177 7 121 6 37 rest 95 Any ideas Please let me know. Thanks a lot in advance. Tag: replicating UDT's to subscribers
  - 3
    - how can I substract a SUM from a SUM? hey Chris, it's perfect but just one more thing... in this line: SUM ( CASE WHEN visit_items . item_code != 'DISCOUNT' THEN visit_items . item_price ELSE 0 END ) I want to show the (!='DISCOUNT') - (='DISCOUNT') Tag: replicating UDT's to subscribers
  - 4
    - Problem in Installing SQL Server 2000 Personal Madhu, I didnt take it personnally.I am indeed happy that you pointed out my mistake so that i can learn from my mistakes.......i just felt like apologising for providing a wrong information........thanks once again friend Tag: replicating UDT's to subscribers
  - 5
    - Deployment problem Help Hello all experts, I have tried to deploy my cube using an XML Script in dev box, modify connecting string by changing server name, run in QA box, and process cube, but always failed. Error massage: боProcess failed. Trace information is still being transferred. If you do not want to wait for all of the information to arrive press Stop.бп Any one had experience for this error Thanks in advance. Tag: replicating UDT's to subscribers
  - 6
    - Reporting Services printer problem I have a windows NT service, which prints to a laser printer programmatically using MSRS 2K. It works fine with a HP printer however when I try printing to a Lexmark Printer it does not always print. Somebody help. Microsoft please release a latest patch for MSRS 2K, its been so long since we had one. Tag: replicating UDT's to subscribers
  - 7
    - Month/Year comparison against a date Hi, Is there a way to get the last day of a month, given a date in a datetime variable I have a stored procedure that accepts a datetime parameter. I need to find the last day of the month for that parameter value. For example, if the stored procedure is passed the datetime value, '6/13/2007', I need to be able to get from that '6/30/2007.' Here's the bigger picture: The sp actually takes two datetime parameters (unfortunately, I don't have access to change the user interface). The sp needs to select records between the month/years of those dates, not including the first but including the second. For example, if the user specifies the following dates: 6/7/2006 7/15/2007 the sp needs to select all records that come after 6/30/2006 and on or before 7/31/2007. I've tried this: ("ReportDate" is the name of the datetime field in a table in the sp and "@StartDate" and "@EndDate" are the datetime parameters in the sp) Month(ReportDate) > Month(@StartDate) And Year(ReportDate) >= Year(@StartDate) And Month(ReportDate) <= Month(@EndDate) And Year(ReportDate) <= Year(@EndDate) But this returns fewer records than when I enter 6/30/2006 and 7/31/2007 as the parameters and just compare dates like this: ReportDate > @StartDate And ReportDate <= @EndDate Thank you. Tag: replicating UDT's to subscribers
  - 8
    - VB6 RDO error I've been given a legacy app that I have to change to point to a Sequel 2005 database (from a sequel 6.5 database). The app falls over when trying to execute a stored proc. The message I get is: Run-time error '40041': Object collection: Couldn't find item indicated by text The above message is displayed when the following line is executed: qryStoredProc(0).Direction = rdParamReturnValue I have reinstalled service pack 6 for vb6 but this hasn't made any difference. Unfortunately due to build difficulties I can't point to the existing sequel 6.5 database from the machine that is pointing to sequel 2005 !! So I'm not sure if this is due to the version of sequel or a problem with my developer machine build. Anybody got any ideas Thanks in advance. Tag: replicating UDT's to subscribers
  - 9
    - Transaction Question When I run the following in Query Analyzer: SET QUOTED_IDENTIFIER OFF -- allows double quotes (") used as wrapper for dynamic sql. DECLARE @E int BEGIN TRAN T1 PRINT 'Start...' EXEC ( " begin tran T2| raiserror( ' inside proc', 16, 11) PRINT STR(@@ERROR) rollback tran T2 PRINT STR(@@ERROR) return " ) SET @E = @@ERROR IF @E <> 0 BEGIN PRINT 'Error ' + LTRIM ( STR ( @E )) + ' out of here...' ROLLBACK TRAN T1 RETURN END PRINT 'Done.' COMMIT TRAN T1 I get the following output and error: Start... Msg 50000, Level 16, State 11, Line 3 inside proc 50000 Msg 6401, Level 16, State 1, Line 5 Cannot roll back T2. No transaction or savepoint of that name was found. 6401 Msg 266, Level 16, State 2, Line 7 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 2. Error 266 out of here... Anyone have an idea why I would get the 6401 and 266 error JD Waleska, GA MSBassSingerNO-SPAM@alltel.NO-SPAMnet (just remove the string NO-SPAM) Tag: replicating UDT's to subscribers
  - 10
    - Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4 Hi, I have installed " SQL Server 2000 SP 4" to SQL server and it is running fine. But when i install the " SQL Server CE version 2.0 Update for use with IIS and SQL Server 2000 SP4 ", i get below error: "SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher. When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000." I have go thougth few articles in the forum, try to open the sqlce20sql2ksp4.exe file and then run only the MSI, but still fail. By the way, i found that the sqlce20sql2ksp4.exe does not include any MSI, it is a direct executable file. Appreciate if anyone tell me the solution. Thanks in advance. Best regards, Plane. Tag: replicating UDT's to subscribers
  - 11
    - Integrating SSRS with report viewer Your words made me confused. Just ask you some questions about your issue 1. Are you using web page which include Report Viewer Component to show RS Report 2. If you use your own web page, you need do programe code to call web serrvice in youe asp.net. 3. The report viewer is a web component which is used for showing RS Report in web form. Suggest you do research on MSDN and you will find a lot of samples of RS Web Service. Tag: replicating UDT's to subscribers
  - 12
    - successful implementation of dataware house and data mining hi all i want an article on a company or organization that has successfully implemented dataware house and data mining, and by its help they have been able to increase their business or sale etc etc help will really be appreciated Tag: replicating UDT's to subscribers
  - 13
    - Aggregation wizard I changed my data source tables to views which effectively reduced the number of rows being loaded into dimension to only those items that appear in the fact table. However, in the Aggregation Wizard, when I request a row count, it appears that the wizard is not looking at the view, but the original table. Is this possible Thanks, Sully Tag: replicating UDT's to subscribers
  - 14
    - USING SSIS for scheduled import Are you trying to schedule it on the Express edition server or the Standard edition SSIS isn't included in Express. Tag: replicating UDT's to subscribers
  - 15
    - Monitor network resources used by single database Hi, Is there any methord to monitor network utilization per database on single instance of SQLServer2005 or SQLServer2000. Please help Regards Mohd Sufian Tag: replicating UDT's to subscribers
  - 16
    - Drop database on a different SQL Server. Hi, I am new to SQL Server 2005.Till now, I have been using a SP to execute DROP DATABASE command to drop databases on my existing database server. but now i want to delete a database which is on a different SQL Server 2005 instance on a different machine. but i am not sure how to do this. Can anyone please help me on this Any help would be appreciated. Thanx in advance. Kawal Tag: replicating UDT's to subscribers
- Next
  - 1
    - XQUERY / XPATH versus nodes containing ":"-character Hi, all. I'm having problems using XPATH / XQUERY versus input containing ":" in the node names. Example: Code Snippet <MyData:Output xmlns:MyData=" www.myprovider .com"> <MyData:Provider> <MyData:Property MyData:Name="FirstName">Joe</MyData:Property> </MyData:Provider> </MyData:Output> T-SQL (breaks): Code Snippet SELECT XMLContents.query('/MyData:Output/MyData:Provider') FROM dbo.Some_Table __________________________________________________________ XQuery [dbo.Some_Table.XMLContents.query()]: The name "MyData" does not denote a namespace. However, if I remove all the "MyData:" references from code and data, it works fine. I don't have an option of getting the incoming data changed; is there a way to escape the character to get this code to work Tag: replicating UDT's to subscribers
  - 2
    - SQL Server vs. XML Configurations Sam, Configurations based on a SQL Server table work just fine. But there is a slight difference when compared against XML files. As you are telling the package to go to a SQL server table and 'grab' some configuration values; you also would need to provide the connection information to get to that table right . That is why, when creating a SQL Server based configuration the wizard ask you to provide the configuration settings directly (using an existing connection manager in the package) or indirectly (using an Environment variable). It seems to me like you are using the direct method; if so, you need to make sure that connection manager is properly configured at run time (basically it can get connected). BTW, the password needs to be specified in either of SQL Server or XML file configurations; so yes, you need to add it after creating the configuration. Tag: replicating UDT's to subscribers
  - 3
    - converting to numeric (6,3) Hey guys, I am trying to achive the following: Truncate the values 1680.390000000000000000 to numeric (6,3) All works ok until i hit a value over 1000, (as above) The code i was using is: cos1 = 1680.390000000000000000000 CONVERT (NUMERIC(6 , 3), ROUND(COS1, 3)) I have tried a few others, but nothing seems to work.. I get the following error. "Arithmatic Overflow" Has anyone got any suggestions Thanks guys, Scotty Tag: replicating UDT's to subscribers
  - 4
    - Datasource Views and Teradata I'm trying to to use SSAS 05 w/ our Teradata warehouse (VERSION 05.01.02.70 RELEASE V2R.05.01.02.40) and I'm having a problem creating datasource views. My issue is that the wizard returns every view and table in the warehouse (tens of thousands) which takes over 10 minutes . I can't seem to limit it to only the database I'm intersted in using. I've tried using the restrict schema option but then no objects are returned. Any ideas on how to do this Can you create the datasource views without the wizard Thanks. Tag: replicating UDT's to subscribers
  - 5
    - Understanding code created by SSIS import/export Wizard The first package is created when you create a new Project. So it is probably empty and does not contain anything. You may probably delete it. The second package should contain a data flow task that contains most of the package logic. Don't try to edit XML - it is somewhat useful for experienced user or for advanced troubleshooting, but most of the editing should be done in the GUI designer. Tag: replicating UDT's to subscribers
  - 6
    - SQL Server 2005 Service Pack 2 - RTM - WHEN??? Hi, Does anybody know how many CTPs will be provided before the RTM will be delivered Thanks Tag: replicating UDT's to subscribers
  - 7
    - Parameterized Queries Just getting started using SSce and having a few problems What I want to do is something like this... Dim Code As Integer Dim Description As String = txtDescription.Text.Trim Dim conn As SqlCeConnection = ConnectToLocalDatabase() Dim ssql As New System.Text.StringBuilder ssql.AppendLine( "INSERT INTO T_Titles (Description)" ) ssql.AppendLine( "VALUES(@Description)" ) ssql.AppendLine( "SELECT @Code = @@IDENTITY" ) Dim cmd As New SqlCeCommand(ssql.ToString, conn) Dim sqlCode As New SqlCeParameter( "@Code" , 0) sqlCode.Direction = ParameterDirection.InputOutput cmd.Parameters.Add(sqlCode) cmd.Parameters.Add( New SqlCeParameter( "@Description" , Description)) cmd.ExecuteNonQuery() Code = CInt (sqlCode.Value) ********************************************************************** The above code doesnt work. Firstly I am not sure if I can execute the two statements in one go. Secondly, I am not sure if output parameters are supported. I have been working with SQL Server since 6.5 but have always used sprocs and am feeling a little lost here without them. Any help getting started would be greatly appreciated. Thanks Tag: replicating UDT's to subscribers
  - 8
    - Users and Roles script In 2005, is there a way to automate this I'd like to be able to do this automatically periodically: 1) Script out the development users and their roles in my development database 2) Backup the production database and restore the it to the development database 3) Re-synch the existing users (sp_change_users_login), drop any obsolete users (sp_dropuser), and add any development users with roles back on Does anyone have a script that can help me achieve this Tag: replicating UDT's to subscribers
  - 9
    - how to extract this text? I have options_field contains a lot of data.. here are examples: DTбдNBбдNMбдANI=80088080 39139662 ANI=80088080 36637576 бдDNIS=80088080бдDTбдNBбдNMбдUNIT ANI=80088080 39188390 бдANI=8008808017403125бдDNIS=80088080бдDTбдNBбдNMбдUNIT ANI=80088080 39653135 бдALIASбдDNIS=80088080бдDTбдNBбдNMбдUNIT ALIASбдANI=80088080 39169467 бдANI=8008808017326875бдUNITбдNMбдNBбдDTбдDNIS=80088080 DTбдNBбдNMбдDNIS=80088080бдANI=80088080 36331200 бдANI=80088080 39318646 I want to extract every 39 and 36 mobile numbers in the ANI. All numbers are 8digits as highlighted ad some records will have more than mobile number while some won't have any mobile number listed. so the result should be 39139662 36637576 39188390 39653135 39169467 36331200 - 39318646 Tag: replicating UDT's to subscribers
  - 10
    - Differences in varchar size usage, declaring the maximum available of 8000 characters Yes, your understanding is correct. Thanks, Marcel van der Holst [MSFT] Tag: replicating UDT's to subscribers
  - 11
    - Daylight Saving Time DST 2007 Problems If you go to a cmd prompt and type "time" and open a query window and run "SELECT GETDATE()" Do you get the same hour When was the last time you rebooted the server It use to be, I don't know if it still works this way, Windows would fudge the Windows clock after DST and would reset the RTC clock when the computer rebooted. So your RTC could say 1:13pm and Windows would report 2:13pm, until you rebooted. Tag: replicating UDT's to subscribers
  - 12
    - end conversation : security context could not be retrieved Because of the distributed nature of messaging, all SSB times are UTC Tag: replicating UDT's to subscribers
  - 13
    - Unicode causes Dimension build failure? I ran the select distinct statement as you suggested, in SQL Management Studio as a TSQL statement. The query completed successfully, no error messages were returned. Tag: replicating UDT's to subscribers
  - 14
    - Change member properties order in excel 2007 pivot table Hi everyone, i am trying to change the member properties order in a excel 2007 pivot table but it wont work... I've found how i should do it according to Microsoft Office web site ( http://office.microsoft.com/en-us/excel/HA101777521033.aspx , see : Display member properties as data in a PivotTable report ) but even if i follow the instruction by the letter it is not working... I've searched a lot but i can't find anything on this... Anybody's having the same issues or know a way around it I'm using SSAS 2005 SP2 and Excel 2007 Thank you very much! Tag: replicating UDT's to subscribers
  - 15
    - SQL Server 2005 Limitation: Having many attributes for Neural Network Hello, Say that I have 100,000 attributes/feature selections for my SQL Server Neural Network Algorithm. Customer Attr1 Attr2 Attr3 ..... Atr100000 ============================== Jack 1 0 1 ..... 1 Sam 0 1 1 ...... 0 Mary 1 1 0 ...... 1 Knowing the fact I can't fit those info on a table and SQL Server's Neural Network does not support table prediction . What's an alternative to use Neural Network in SQL Server 2005 to solve my problem Please assist! Mary Tag: replicating UDT's to subscribers
  - 16
    - readonly custom property Well, for now I would do what Jay suggested. Feel free to open a request for adding this feature on the connect site. Thanks. Tag: replicating UDT's to subscribers

teplitsa

I have a sql 2005 publisher and distributor and a sql 2000 subscribers. for some reason on one of the subscribers i'm getting errors that it can't replicate the UDT's. i tried a new snapshot and made sure it was set not to replicate UDT's but i'm still getting Create Type errors.

would anyone have any idea why it's trying to create UDT's at the subscriber when i specify not to replicate UDT's

Re: replicating UDT's to subscribers

Gary Chen

Are you trying to exclude the UDT column, so it doesn't replicate to subscriber How did you specify, so it does not replicate UDT Did you add a vertical filter Or

Gary

Re: replicating UDT's to subscribers

teplitsa

in the article properties i left it on false for replicate user defined data types. it's UDT on the publisher and the base types on the subscribers.

Re: replicating UDT's to subscribers

Raymond Mak

I am not sure if this will solve your problem but you can try re-initializing your subscription before regenerating a new snapshot.

-Raymond

Re: replicating UDT's to subscribers

teplitsa

how many dba's does it take to change a light bulb

stupid mistake. need to change it to true to convert data types like on all our other publications