Answer Questions

• friggityfraggity This exception gets generated every 60 secs..Any resolutions?? Thanks in advance

  Description : Error Message : System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Library.ReportSnapshot.EnsureAllStreamsAreClosed() at Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext repor ...Show All

• Tigerwood2006 ERROR IN SQL SERVER ENGINE

  I have a problem starting my SQL Server engine. Its service has been stopped. It was working properly till evening “ December 8, 2006 ”. But when I came to office at 10:00 AM, it did not start. When I checked the service in “Services.msc”, it was stopped. So, I tried to start the service “ SQL Server (MSSQLSERVER) ”, but it failed with message “ Error 1069: The service did not start due to a logon failure ”. I opened “Event viewer” and looked the list in “Application” log to find out what had happened. There was an entry for “SQL Server” source with type “Failure Audit”. There was a message “ Login failed for user sa ”. What went wrong….Can someone help me Plz its urgent…. Hi Ritesh, I think the problem is with yo ...Show All

• blange Database Mail SQL 2005

  I'm having a problem with database mail in SQL Server 2005. I have set up a default profile. My SMTP server is not a localhost instead i've fed SMTP ip address and port no. The same setting in Outlook express works fine for Incoming and outgoing mails. but in SQL 2005 i'm not able to send test emails. The following errors show up in the sql server agent log Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-06-13T10:47:27). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine). ) Please help me out.... Hi, I would use something like ...Show All

• pblecha TableAdapter and variable

  Hello, I want to do something like this in a TableAdapter's SQL Statement: SELECT Type.* FROM Controllers INNER JOIN @Type AS Type ON Type.ConfigurationId = Controllers.ActiveConfig INNER JOIN Tank ON Controllers.ControllerId = Tank.ControllerId WHERE (Tank.TankId = @TankId) But I get an error because of the @Type variable. Is there any other way to choose a table in a TableAdapter with variables Thanks for your help! skuehner wrote: Additional information: @Type is a Function that returns a table... but that might not be the problem. If You want to execute this command in first You may put this command into a string (use concatenate + ...Show All

• PareshGheewala jumping to report from report within a same frame

  Let's say I have a web page that has two frames, A and B. Frame A shows lists of products, Frame B shows the Inventory Chart of after clicking a product at Frame A. The inventory Chart has a drill down link to another report XYZ. Once you click on the drill down link, the whole IE will be occupied by the report XYZ. How can I have the drill down report XYZ to be shown in Frame B and Frame A still remain there Hi, I tried putting javascript:void... in navigation but getting an error "The Hyperlink expression for the textbox ‘textbox14’ contains a colon or a line terminator. Colons and line terminators are not valid in expressions." How do I resolve it TIA, Tanmaya ...Show All

• Bigteddy How to transfer database to mobile device?

  Hi all, I'm new to mobile devices. I have a desktop application that uses SQL Server Compact Edition. I will soon have a mobile application that will use the same database. How can I (at runtime of the desktop app, say when the user clicks a button) transfer the sdf file to the mobile device I'm not necessarily interested in synchronizing the databases, simply overwriting the database on the mobile device with the one on the desktop would suffice. Is something like this possible Thanks! Thanks, I'll check that out. You can copy the SDF file from the desktop to the device using RAPI. ...Show All

• ailuz How to encrypt all existing stored procedure?

  I know that we can CREATE PROCEDURE procedure_name WITH ENCRYPTION. But how about if I want encrypt existing stored procedures Which command should I use As of now, I mark this thread as no answer. There is no easy way. You have to script out the SQL modules (Create or Alter) and then add the WITH ENCRYPTION option to the definitions. There is no DDL to just encrypt SQL modules without specifying the definition. Why do you want to encrypt your code The encryption mechanism is really obfuscation and it is a reversible encryption. So it is possible to get the original code from the encrypted content. If you want to protect your code then you should look at legal binding terms and copyright mechanisms. how about sc ...Show All

• Scherild SSL To SQL Server 2000 From VB6 : Error

  Hi All, I am trying to connect to SQL Server 2000 database from my VB6 code. The SQL Server is having the setting ON to force all incoming connections to use SSL. It is using a valid certificate with the same name as FQDN of the server and has been provided by the security department in my organization. I have got my client code on my desktop. I have installed the root CA certificate for the SSL certificate on DB server in my desktop's Trusted Root Certificates. When I try to access the database from my .NET 2.0 code, it works fine. The .NET code gives an error if I remove the CA certificate from my desktop. This behaviour is as expected. I am using Encrypt=True setting in my code here although I dont think it is necessary when se ...Show All

• Chris-M OLEDB Destination Error in SSIS Package not returning error column/desc

  I have a SSIS package that reads data from a dump table, runs a custom script that takes date data and converts it to the correct format or nulls and formats amt fields to currency, then inserts it to a new table. The new table redirects insert errors. This process worked fine until about 3 weeks ago. I am processing just under 6 million rows, with 460,000 or so insert errors that did give error column and code. Now, I am getting 1.5 million errors. and nothing has changed, to my knowledge. I receive the following information. Error Code -1071607685 Error Column 0 Error Desc No status is available. The only thing I can find for the above error code is DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE To add to the confus ...Show All

• Mattdu Filtering KPI if already included dimension in calculation

  Re: SQL 2005 AS. Is there a way to filter a KPI if already included a dimension in the MDX calculation For example have created a calculation called "Profit" which is made up of [Account, Product subset, $] .  When try to filter by Product in the KPI browser, does not work. Another example is say have a set of data which only includes apples, oranges, & apricots in the calculated member.  Can I apply a filter to the resulting KPI to just show oranges   Is there a way around this, without creating separate calculations/KPI's for each product (e.g. Profit apples, Profit oranges, Profit apricots) DataSet GL Account Set {...} Product Set {PA010,PA020,... ...Show All

• BeaverMan Use of temp table

  Hi there In Control flow of my package I have  created a temp table. How do I use that temp table in my next task which is Data flow task. I want to use my temp table as source in data flow task. I have set retain connection property of my connection as true.\   Thanks and Regards Rahul Kumar, Software Engineer Hi OOh ...ok you have to use Globale Temproray table for that, it should be verified that after the execution that what is the session managment. You have to Just use ## sign instead of # one for creating Globale Temproaray Table Hi Akbar Session is not the problem i am able to retain session. Problem area is, as is insert a Data Flow Tas ...Show All

• jlwilliamson Convert Date

  Hi ! I think I need your help... to convert the date (2006-09-09) to weekday, weeknumber, month number, month, year in OLE DB source editor ... created following sql, which is not working. How about using derived Column transformation editor SELECT DATENAME (WEEKDAY, YYYYMMDD) AS weekday, DATEPART(WEEK,YYYYMMDD) AS weeknumber, MONTH(YYYYMMDD) AS month_number, DATENAME(MM,YYYYMMDD)AS Month, YEAR(YYYYMMDD) AS year, DAY(YYYYMMDD) AS date FROM Purchase thank you so much... Throw this around your month: right('0' + (dt_str,2,1252)datepart('mm',[datefield]),2) it seems very easy, but just don't get it right. using the columns 'year' and 'month', 'week' the function looks like this in derived transformation ... DATEPART( [year] [ ...Show All

• Novelle Books for SSIS

  Hi, Please give the Microsoft suggested book material list for learning SSIS Thanks & Regards S.Nagarajan http://msdn2.microsoft.com/en-us/library/ms141026.aspx I don't think MS has ever given book recomendations officially, unless it was for MS Press, but since they don't have a SSIS book out, try this list for now- Books ( http://www.sqlis.com/default.aspx 400 ) ...Show All

• Evgeny Popov can i restore only a table from a backup file?

  Hi, i have a backup file , and i saw the wizard to restore the file in sql2005. But i need to restore only a table. Is there a wizard for that Unless your database is laid out with the table in question in a separate filegroup before you find yourself needing to restore, you cannot use that approach. Also note that when restoring an individual filegroup, it MUST be brought up to the same point in time as the rest of the database in order to bring it online. So, if you're trying to recover from a mistake ("I didn't really mean to truncate that table!!") this won't help, as you'd need to roll the filegroup forward, including the mistake. One way in which you can make filegroups work for you if you have enterp ...Show All

• Alexie1668 problem connecting to sqlexpress

  Hi all, I'm getting this error message from the ASP.NET configuration manager in VS 2005 Pro: There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. I have no problem connecting using the sql server management studio tool. I need help ASAP, can't afford the down time. Thanks, Andy ...Show All