Answer Questions

• Jun_1111 Architecture question

  I am a newbie to Notification service and I need your help to determine what's the best way to handle my situation. First of all, I need to determine if Notification service is the right approach. We have a ASP.NET application that creates purchase orders to various suppliers. Few suppliers are fine with just "Email notifications". But few of them need the PO XML sent to their FTP site. We might have future suppliers and they may want a different mode of communication. Here's my solution to this problem and I need your expert advice Step 1: Create an event schema that captures all the item details in a PO. Question: What is the best way to implement hierarchies [PO Header, PO Line item] I am thinking of adding all the ...Show All

• Fahd Trace stored proc calling event

  I wanna use the SQL Profiler to trace some stored proc. calling events, such callings are originated from an .NET or Java application. Which event, RPC:Starting or SP:Starting, should I use Hi, look in the MSDN Online Library. It describes the events in detail. RPC means RemoteProcedureCall, SP mean Stored procedure. These event are for showing the information which is sgiving when any of these events occur. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Start with: STMT:Starting SP:Starting Errors eventually audits HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- Thanks for your reply, Jens. But what's the differen ...Show All

• adityap Function in select statement

  How can I put a function in a select statement such as SUM(code.GetValue( A, B, C, D, E)) AS TC_Reserve I want to pass the function several values and have it perform a complex formula and return a value.  And then sum the value returned for each row. This data is then used to create a chart "Dollars by Product Category" Is this possible.  I've only been at this for a week so I have no idea if it can done.   I get the message below =============================================================== TITLE: Microsoft Report Designer ------------------------------ Could not generate a list of fields for the query. Check the query syntax, or click Refresh Fields on the query toolbar. ------ ...Show All

• Leadfoot If WCF can communicate with ServiceBroker?

  hi, I want tomake wcf and service broker communicate with each other,Are there some resources about that thanks in advance DeadlyViper: Have you posted your sample solution Please share the link to it Thanks, Tom WCF is not a protocol itself, but a programming model and framework for building service oriented communication. The stack comes with some stock bindings for protocols such as TCP, UDP, HTTP and MSMQ. But you could write your own set of channels and bindings for Service Broker such that you could leverage WCF on top of Service Broker. Can you explain why you are interested in this type of usage Rushi ...Show All

• Luka Ivkic Converted report too far against left side of screen

  I converted an RS2000 report to RS2005 and uploaded it to a new 2005 Report Server. When I view the report through IE 6 at the Report Server URL, the report seems jammed against the left side of the screen. This didn't happen when the report was in RS2000. When it was still an RS2000 report, there appeared to be some space (perhaps 1/8 - 1/4 inch) of space between the left edge of the screen and the left margin of the report. Using Visual Studio 2005, I've tried moving all the objects within the report a little to the right, but that messes up the way the report prints. Is this a common problem Is there a way to get the space to the left of the report back when the report is rendered Thanks for your help! Nancy ...Show All

• Seth Livingston SP "Upgrade" fails.

  So I've tried today to upgrade a SQL Express instance on a machine where "proper" SQL has already been upgraded. It fails. The error code is 2259. Database: Table(s) Update failed So I thought I'd uninstall SQL Express altogether and just do a full install. But it cannot find the MSI files to uninstall itself. The part of the log file referring to it appears to be <Func Name='ProcessHeaderTable'> <Func Name='ProcessScriptTable'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='ProcessScriptTable'> ...Show All

• Hassan Ayoub Update XML Source and generate new xml

  Hi ! I have a very simple problems with SSIS. I have a "XML Source". I update some value in my SQL2000 with OLE DB Command (No problem at this point) Now i need to update one value inside this XMLSource (Confirmation variable) and generate a new XML file. What objects i need to use to make this ! Thanks ! Use the Xml Task. Double-click to edit properties. Choose XSLT from the OperationType drop down. Set the SaveOperationResult drop down to true, and choose your destination. You'll need to write a transform to update the nodes value. If you're not familiar with XSLT you can probably find plenty of samples on the web. Does this answer your question Hi Philipp ...Show All

• tribal Multiple Cross Apply

  Good Afternoon, I'm attempting to leverage SQL's new 'APPLY" operator and I guess I don't fully understand it proper usage. This is a relatively simple request, first i want to count the models produced within a valid period of time. The first 'Cross Apply' gets the valid starting and ending dates and looks ups the number of models produced for the period of time. This section of code works perfectly fine. The problem appears to be with the second "Cross Apply".  What I'm attempting to accomplish is to count all models produced, regardless of time frame. When executed the query appears to go into an loop and I end up canceling out the request. Any ideas where I went wrong Any help is greatly appreciated!   s ...Show All

• Jamie Thomson creating user procedures in the master database

  I'm running mssql 2005. And any stored procedure I create in the master database gets created as system procedures since recently. I have created procs in the master database as user procs previously. As sp_MS_upd_sysobj_category is not supported in mssql 2005, does anyone know why this is happening.. or how I can rectify it Thanks... Moving thread to the DB Engine forum. It is not a best practice to create user stored procs in master. This SP was undocumented and not subject to the 3 release deprecation policy. I think it went away with the move to the resource database in SQL2K5. With that, what is your specific scenario for creating stored procs in master ...Show All

• Liam64 Add space between matrix row group

  I have a 2 row groups in a matrix and I need to add some space between the top one so that all the columns don't run together. Is there a way to do this I have to lay them out horizontally bc of how many rows there are. If I do it vertically the report gets too long to read. That's what it currently looks like. How do you want it to look I guess I wasn't clear. I dont need space between the rows, but between the last column in a row group and the first column in the next row group. Does that make sense Would you still want the tables to appear horizontally next to each other Have you considered placing the matrix in a list contro ...Show All

• Javier_Uy trsafering access record in sql data base...

  Assumig i have acces my_db.md and my_mdb.mdf (in instace named DVD377-14D9E48C\SQLEXPRESS) Access mdb have table named my_table with: field1 field2 field3 i have same table named my_table in sql instance with same named record and same property of access mdb i want to transfer all record from access table in sql db, record by record... similiar: rs.recorset1 of access in rs.recorset1 of sql db rs.recorset2 of access in rs.recorset2 of sql db rs.recorset3 of access in rs.recorset3 of sql db ...ecc record by record becose during the export from access to sql i make various operation on single record... Hi, You may use SSIS and SSMA for the purpose, here is ...Show All

• James Cornell Credentials used to run this report are not stored

  Hi all, When I create a new report subscription in report manager, I got this error Credentials used to run this report are not stored any idea Thanks, Jone Thanks, Jarret. According to your suggestion, I configured my datasource and ran my report, and I got error Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https. I'm really frustrated. Could you give me more thoughts Thanks, Jone Hi, more question: since the application will be used by others, what shoul ...Show All

• x868 x-Axis labeling

  Hi, In my report, I have StartDate and EndDate parameters.In my Line chart on x-axis i need to show the dates like this:Suppose startdate=1/1/2005 and enddate=12/31/2005 then x-axis labels like this:1/1/2005,4/1/2005,7/1/2005,10/1/2005,1/1/2006.In x-axis i put the Minimum value:Parameters.StartDate.Value and the Interval is 90( days),it is not working properly. How to show quarter of the year on x-axis. Please help me Thanks in advance Hi, Where to add the quarter column Thanks Hi, I put the Fields!Quarter.Value in label.But it is not displaying any thing. Please help me Thanks in advance Hi, Reporting ...Show All

• Carter_D need advise on DELETE action.

  Hi friends i've a table that has 3 columns that refer to same parent table(foreign keys).am trying to following as part of action. ALTER TABLE dbo.u_childTable ADD CONSTRAINT FK_childTable_MASTER_BATCHTO FOREIGN KEY ( FK_BATCHTO_MASTERID ) REFERENCES dbo.u_master ( MASTERID ) ON UPDATE NO ACTION ON DELETE NO ACTION GO ALTER TABLE dbo.u_childTable ADD CONSTRAINT FK_childTable_MASTER_FEESCALER FOREIGN KEY ( FK_FEESCALER_MASTERID ) REFERENCES dbo.u_master ( MASTERID ) ON UPDATE set null ON DELETE set null GO ALTER TABLE dbo.u_childTable ADD CONSTRAINT FK_childTable_MASTER_SUBDEBT FOREIGN KEY ( FK_SUBDEBT_MASTERID ) REFERENCES dbo.u_master ( MASTERID ) ON UPDATE set null ON DELETE set nu ...Show All

• Andrei G. SQLXMLBulkLoad and MSOLAP provider

  Hi All, I tried to connect Foodmart 2000 in AS 2000 by SQLXMLBulkload using MSOLAP.2: Dim objBL Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0") objBL.ConnectionString = "provider=MSOLAP.2;data source=localhost;database=Foodmart 2000;integrated security=SSPI" objBL.ErrorLogFile = "d:\Users\Bulkxml\error.log" objBL.CheckConstraints=true objBL.XMLFragment = True objBL.SchemaGen = True objBL.SGDropTables = True objBL.Execute "SampleSchema.xml", "SampleXMLData.xml" Set objBL = Nothing and get the error message: Line 12 Error: Invalid connection string Code: 8004e21 Source: Microsoft XML Bulkload for SQL Server. Using another examples (ADOMD i ADOMD.NET) result in succeeded connection. Can anyone ...Show All