Answer Questions

• Baloodevil error when changing published article at the subscriber

  Hi Using merge replication - the stored procs are published articles. When trying to change the article at the subscriber (sql express) I get the following errors: Msg 21531, Level 16, State 1, Procedure sp_MSmerge_alterschemaonly, Line 45 The DDL statement cannot be performed at the Subscriber or Republisher. Msg 21530, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 181 The DDL operation failed inside merge DDL replicat ...Show All

• psikadelik Known SMTP bug in .NET 2.0?

  Hi All, A while back I posted a message referring to an inability to send e-mail from SQL 2005 Database mail; the error being "Command not supported" - which appeared to be coming back from the Exchange Server. Looking on the SQL Sentry forums (SQL Sentry having its own alerting function) they report the same errro testing their smtp code, with the post This is the result of a known bug in .NET 2.0. when working with a ...Show All

• jowjow Having problems with variables

  I have a Execute Process Task that pretty much executes a batch file that downloads a file that has a dynamic file name (with datetime stamp). Now I would like to load this file to a Flat File Source task in the Data Flow Task section automatically. So, creating a file manager or something on the fly. Is something like this possible with SSIS Or am I simply hitting the wall here Thank you. Why can you not j ...Show All

• ksmithsba Accessing AdventureWorks DB from ASPNET

  Hi folks, I've been wondering whats the "appropriate" way to configure AdventureWorks DB such that the WHOLE database can be access from Visual Studio and ASPNET webpages. The problem I keep beating my head against is the schema problem which prevents me from accessing tables with different schema. What I've done/can do so far is: 1. Installed AdventureWorks DB 2. Can run SQL cmds from Winforms apps and these are working as expected. 3. I'v ...Show All

• EricTN cant connect to server from another machine

  Hi Friends I have a sql server (2005 standard edition) on Win xp machine. i can connect to this server from my machine ok but others on the network try to connect i get following error "An error has occurred during report processing. Cannot create a connection to data source 'dataSource1'. A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Serv ...Show All

• R. Dobson Search with %t%y% => Error, %ty% => ok...

  Hi! I have a problem with a Select statement: In a ordinary table there is a column called NAME. I want to make the following search: SELECT * FROM TableName WHERE NAME LIKE '%t%y%' this should give me all entries that have a "t" and a "y" in the NAME column. However, it gives me no entries. If I instead run this search: SELECT * FROM TableName WHERE NAME LIKE '%ty% it gives me the correct result. Since the wildca ...Show All

• CAyson Performing a range lookup using two tables

  Hello. I have a car table, whose rows contain cars and their respective weight: Ex: (1, 1000), (2,1100), (3, 900) etx. I also have a car class table with the classes cars can fall into, based on a lower bound and an upper bound in which the car's weight must fit. Ex: (Class1, 0, 999), (Class2, 1000, 1499), (Class3, 1500, 1999), etc. I need to match each car to it's respective class. I've already search the database for post on thi ...Show All

• ComputerMan Sample code for Reporting 2005 Web Service needed

  Hi. I have an ASP.NET project in written in VB.NET 2003 using the RS 2000 Web Service to render HTML report data as a part of web page. The function uses credentials to impersonate an NT user, passes custom report parameters and uses the RenderStream to handle images. My challenge is to convert this code to the new ReportExecution2005 service. I have spent most of the day writing code which returns the not-so-inspiring message "System ...Show All

• happyt Unable to modify database design

  I have replaced the installation of MSDE 1.0 with MSDE 2000. Prior to installation of MSDE 2000, I can perform the activities of all database role. Now, I can only add, change and delete data - no more database design. What should I do to regain database design permission I'm using "sa" user with blank password when I login to MS Access Project. Hi JonM, Would I able to use DTS ...Show All

• JUNKMAN SSIS package fails on execution

  I have just created a simple SSIS package to transfer data from a SQL 2000 source to a SQL 2005 target.  When I execute the package, I get an error: [SQL Server Destination [16]] Error: The thread for the SSIS Bulk Insert task failed initialization. I have tried to execute the package both from within Visual Studio and SQL Server Management Studio. ...Show All

• George.Saliba Task Upgrades, Update and CanUpdate methods.. Why?

  I am writing a new version of a task with and additional property, and wish to support upgrades between the versions. I have implemented the CanUpdate and Update methods, and update the Xml for the new property. The problem I then have it LoadFromXml gets called which promptly fails since it is still using the old version of the Xml. Have I misunderstood the point of the Update mechanism It would seem to me that I’d better off ignoring Update a ...Show All

• JLA_dk1 Is this possible? How

  hello guys, I want to create a report using a bar chart data region from a cube. The cube contains Date and Time dimentions. Here is my question: The catagory field (x-axis) value of the bar chart is dependent on the paramaters value(i.e.StartDate and EndDate). For instance if the difference between StartDate and EndDate is greater than 1 year, the x-axis value for the bar chart should come from the Date dimention and display the year value. ...Show All

• pico1079 SQLEVN70.rll error

  When I boot my system , I get the message that my sqlserver installation is either tampered or corrupt. As a result when I try to restore my system to previous checkpoint I am not able to do so. Please let me know solution for this. I tried installing and uninstalling but that did not work....this is very very imp...please respond ASAP i had tried to install/uninstall sql2k....i am using XP pro..I was not able to locate the directory ...Show All

• Mussye TM Using SMO and ClickOnce deployment

  Hi, I'm writing an app that I want to use ClickOnce deployment with. The app may have to ask the user for the Server and Database name to connect to if it is the first time it has been run. I'm thinking of using Sql SMO but I see the requirements for this include MDAC 9.0. Can anyone tell me how this could affect a clickonce deployed app I'm no export with clickonce, sorry. I'm hopeing it is possible to deploy MDAC 9.0 via clickonce too. Any hel ...Show All

• Fenixk19 XML record from SP

  There is a requirement to return a xml record using SP. The structure of the xml looks like below. <RNetOrderResponse_20 Version="2.0"> <RNetHeader> <ThisDocumentIdentifier>ORE41688745301004467924200605220825263-20060522T082502</ThisDocumentIdentifier> <ThisDocumentDateTime><DateTime DateTimeQualifier="On">Feb 24 2006 11:21AM</DateTime> </ThisDocumentDateTime> ...Show All