Answer Questions

• NetPochi Inserted and Deleted tables

  Hi: Can any of the experts please confirm the fact that Inserted and deleted tables in SQL Server 2005 are stored in tempdb . If so, how can I query them in tempdb ( A code snippet would be useful). Thanks AK Thanks for the reply. I still would like to know if they are stored in tempdb though in SQL Server 2005 Vs getting stored in memory in SQL Server 2000. Any pointers Thanks Thanks OJ for your explanation. I am curious why you would want to do this in the first place. Are you simply trying to access the data before and after the record is created. In a trigger you can access the date using inserted and deleted ...Show All

• eyupcinar Merge Join's poor performance

  Hello All, I'm experiencing performance problems with the merge join task. Every time I'm building a nice package using this task, I'm ending up deleting it and using SQL statement in the OLE DB source to accomplish the join since it takes forever to run and crushing my computer at the process. It makes me feel I don't use the abilities SSIS has to offer compared to DTS. Of course for the use of several thousands of records it works fine, but in a production surrounding with hundred of thousands of rows, it seems to be futile. Maybe someone had a little more luck with it Liran R wrote: Hello All, I'm experiencing performance problems with the merge join task. Every time I'm ...Show All

• Ido Ran Error trying to create cube partition

  I've converted 4 AS2000 databases to AS2005. In just one of these databases, I am not able to add any partitions to any of the cubes. As soon as I click the "New Partition" link, get the following error: The wizard will close because of the following error: An item with the same key has already been added (mscorlib). I get this error if I try to create a parition from either Visual Studio 2005 or SQL Server Management Studio. AS2005 version is 9.00.2047.00. I can add paritions to cubes in other databases on the same server. I've been all over looking for help on this, with no luck at all. If anyone can help me, I'd sure appreciate it. I've checked the AS2000 datbase ...Show All

• Hans1982 Image .BMP only shows on first page, place holder on the rest

  I am printing a batch of Explanation of Benefits and the image only shows on the first page for each person. If they have additional pages all I get is the little red X. Thanks, Phil Why isn't the page header repeated on every page. Am I missing something in what I expect the definiton of a page header would be. The globabl function for printing page number knows that it is a new page. So why doesn't the image print on the second page. I eneded up telling the user SSRS wasn't cable of what we wanted and I removed the functionality for printing images based on a selection in a list box. Back to sw.writeline. I'm afraid I'm still not clear on exactly what you are trying t ...Show All

• qjay Suppressing text messages

  When I run sp_start_job I get the message 'Job... started successfully!'. As I execute the procesure many times my logg fills up with these messages - is there a way to suppress these text messages Rgds Bertrand Try setting the output_flag to 0. It says reserved, but it indicates that it works in the definition of the procedure. I tested it and it was silent for me: msdb .. sp_start_job @job_name = 'test' , @output_flag = 0 How obvisous... :-) Thanks! Bertrand ...Show All

• jheddings passing a timestamp datatype column to a variable and back

  After several hours of trying, I trow the towel in the ring and come here to ask a question. Source system uses a timestamp column in the transaction tables. which is equal to a non-nullable binary(8) datatype (sql 2000 bol). What I want to do is get the timestamp at the start of the transfer and at the end of the transfer of data. and store these in a controltable I try to do this in 2 sql execute tasks: sqltask 1: "select @@DBTS AS SourceTimestamp" and map the resultset to a variable. Here come's the first problem what variable type to take DBNULL works (meaning it doesn't give errors) (BTW: is there a way to put a variable as a watch when debugging sql tasks ) INT64 and UINT64 don't work error message that t ...Show All

• bond12 SSIS Bulk insert to 2k

  I am using SSIS (2005) to insert records into a sql2k database and getting error: The selected connection manager uses an earlier version of a SQL Server provider. Bulk insert operations require a connection that uses a SQL Server 2005 Provider. Using the Bulk Insert Control Flow object is not an option because it requires the file be on the 2000 server and I am not able to create temporary tables on the 2005 server (some nutty security lockdown). Any suggestions Thanks in advance. Thankyou very much for your quick response, it worked perfectly as did the tech forum concept ! Just use the oledb destination rather than the SQL Destination. The SQL Destination has optimisations that allow the bulk insert to ...Show All

• X4U Database Mail Fails For SQL Server Agent Jobs / Maintenace plans - Why ?

  Database Mail Fails For SQL Server Agent Jobs / Maintenace plans - Why This has been a very common question I have seen relatedt to Database mail and I thought will post here so if you run into this issue, it could be due to one of the following and also have mentioned below how to get around them. Bottom line is datbase mail works fine with SQL Agent jobs and maintenace plans in SP1 on all platforms. 1. If you see this on 64 bit platform and on RTM build, this is a bug that is addressed in SP1. 2. If you see the below error message, it is known issue and this is because of design that requires SQL Agent to restart, if SQL Agent was started before enabling databasemail and setting a new profile. We are evaluating to change this d ...Show All

• Seiggy Is it possible that Adomdclient being automatically downloaded and installed in the GAC on the Client?

  In a winFX xaml brower project, a reference to Microsoft.AnalysisServices.AdomdClient.dll is added. After building, the project is published to the web server on the same machine. But when running the application on a client the following error occures: Platform Requirements Not Met Unable to install or run the application. The application requires that assembly Microsoft.AnalysisServices.AdomdClient Version 9.0.242.0 be installed in the Global Assembly Cache (GAC) first. Is it required to install AdomdClient on the client machine Is there any possibility that Adomdclient automatically downloaded on the client machine and installed in the Global Assembly Cache You should be able to build a simple s ...Show All

• Mike Riley RecordSet into a DataFlow Task

  In the control flow I have an "Execute SQL Task" that executes a stored procedure. The stored procedure returns a result set of about 2000 rows of data into a package variable that has been typed as Object to contain the data. What I have not been able to figure out is how to access the rows of data (in the package variable) from within a data flow task. There does not seem to be a data flow source task to perform that operation. What am I missing that would make this easy ...cordell... Cordell Swannack wrote: In the control flow I have an "Execute SQL Task" that executes a stored procedure. The stored procedure returns a result set of about 2000 rows of data into a ...Show All

• Milzit Query Analyzer

  I am new to SQL and I need t run a Query on how the company database is performing. I need to determine if any indexes, partitions are needed to help improve performance. I have never done this before. Can someone help me with the proper steps to accomplish this I am using SQL Enterprise 2000 to access the databases. Thanks in advance, Carl Johnman AH, ok this request makes more sense to me. If you are executing a query or a stroed procedure use the Estimated execution plan functionality for investigating any bottlenecks. More on SQL Server performance is available at www.sql-server-performance.com HTH; Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Tommi Pitkälä Locked out of reporting services

  Hi. I have a server with reporting services set up and SQL server 2000 running. Recently I renamed the server (because it just had the generic HP server name that the machine ships with and I just noticed that no "real" name was ever given during setup). Ever since the computer name change, I no longer have administrative rights to reporting services. SQL Server databases function fine but I can't get into Rep Svcs. The Built-in/Administrator is gone and I am not allowed to add it since I now don't have the admin rights. (even though I'm logged onto the server as the administrator.) I haven't been able to find any information how to remedy this issue short of uninstalling and reinstalling reporting services. Can someone ...Show All

• Alastair Q How to maintain alternating row background colors while making blank rows invisible.

  I am currently checking textbox values to see if they are blank and then setting the hidden property to true. This however disrupts the flow of the alternating row bgcolor. How can I maintain the alternating row colors Thanks Hey, this is really an interesting one. OK, there are many approaches (I didn’t try one on my own, but here is the idea). You query your data with adding one column which sums up +1 for every row which will be displayed in your report. With this you can easily use the "Mod 2" (as seen on many examples) to alternate the color. THis was the server otion, the client option would be to make a RunningSum on a added value (with the value 1 for to displyed rows) and do the ...Show All

• rpreston sp_replcmds not getting the desired output

  hi, I fired the replication command sp_replcmds on my publisher and it returned the fillowing output. "Another log reader is replicating the database." can anybody out there explain why is that so and how can i get the output. Thanks in advance Jacx sp_replcmds is used by logreader and replication treats the first client that runs sp_replcmds with a given database as the log reader. Only one client can run sp_replcmds at a given time. So you will have to disconnect other client/logreader that runs sp_replcmds, otherwise you will receive the above message. Thanks, Peng ...Show All

• Dana Lutz How to hide a value within a Dimension

  Hello, I am trying to hide a value within a Dimension. Currently, the Dimension contains (NewBooker, RepeatedBooker, Others). I would like to hide Others (so people cannot see and filter on this value) while for Total (ALL)still show the GrandTotal (including Others). I would rename the Dimension name so users would understand Total includes Others. Is it a MDX statement I have to specify at Dimension or Cube level to hide this scenario. Any help is appreciated! -Lawrence Have a look at the HideMemberIf property on the levels of the hierarchy. By manipulating the member names you should be able to achieve the effect you desire. Sorry, it was getting late and I was a bit brief with my resp ...Show All