Answer Questions

• OsirisTerje Problem with User Defined Function

  I wrote a UDF to get a rolling average based upon a date passed to the UDF. The error I get is: Server: Msg 102, Level 15, State 1, Procedure fn_RollAverage, Line 26 Incorrect syntax near ')'. SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE FUNCTION fn_RollAverage(@CURVE_DATE AS SMALLDATETIME) RETURNS @TBLRESULT TABLE (US0001M_Index AS FLOAT, US0003M_INDEX AS FLOAT, US0006M_INDEX AS FLOAT, US0012M_INDEX AS FLOAT, usswap2_i ...Show All

• JoneLee MSSQL service restart on principal whilst mirroring...

  I have a problem that has happened a couple of times now. I'm in the process of testing our 2005 deployment - Standard edition on 2003 x64 servers for principal and mirror and 2005 express witness. All are pre SP1. Two databases are being mirrored. I have successfully set up mirroring which seems to work fine - but when I restart the MSSQL service on the principal, spurious things happen: The server that *was* the principal before restart ...Show All

• Vollstrecker Text field problem

  Hi, in MSDN is written reguarding WRITETEXT : data Is the actual text , ntext or image data to store. data can be a literal or a variable. The maximum length of text that can be inserted interactively with WRITETEXT is approximately 120 KB for text , ntext , and image data. I am tring to insert a text which has around 9000 charcters using WRITETEXT which is less then 10KB , but surprise: after the execution of the sq ...Show All

• Sinergy equivalent of render command and session header in reporting services 2005

  What is the equivalent of render command and session header in reporting services 2005 ...Show All

• Gregouille How to receive files in FTP task

  Hi everyone, I want to design a FTP task to download all the xml files from a FTP site. And I don't know what the file's name is. How can I design this task Thank you for your helps! Tony Can you share what mistake you made I have the same problem and would like to learn too. Sorry Craig, I made a small mistake:-P. It works! Thank you so much! Tony ...Show All

• Alex Ivanov The proxy auto-configuration script could not be downloaded

  Hi, I am trying to create a Merge Replication through Web synchronization , i used the publish server as distributor and i installed IIS on the same server. i tried the following URL https://mysite/replisapi.dll  from publish server and it was ok. i got the following message: SQL Server WebSync ISAPI. from the subscriber server i checked the url https://mysite/replisapi.dll  too and it was ok too and i got the following message: SQL S ...Show All

• Shantnj Can it be a bug in SQL CE?

  Hi! I use SQL CE with VS.NET 2003. I find the following bug second time. The table has an " ID int IDENTITY(0,1) PRIMARY KEY,". That is my row identity. I add rows to the table, then I made some select and update queries. Then I realized that the ID order not in the general order (from 0 to ........) For example: 6,7,8,0,1,2,3,4,5. Of course row 6,7 and 8 was added the very last. The content of each row is not mixed, ...Show All

• ChicagoDave Cognos Powerplay and Analysis 2005

  Hi everybody, we have an AS2000 cube and we use Cognos Powerplay for reporting. We are investigating about migrating to AS2005 and we are looking for information about compatibility between 2005 and Powerplay. If anyone can help us. Thank you. We are also using PowerPlay to deliver MSAS 2000 cubes. According to Cognos Support: " At this time, MS SAS 2005 is not supported with Cognos including the latest version ...Show All

• Clemens Vasters An attempt to attach an auto-named database ....\aspnetdb.mdf failed

  I've installed VWD 2005(Beta 2) and MS SQL Express and also followed the aspnet tour at http://beta.asp.net/guidedtour2 . After trying new webcontrol (login control) and trying to execute the page, I've got an error such as below: An attempt to attach an auto-named database for file c:\inetpub\wwwroot\Demo\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. ...Show All

• minority80 How do I attach query results to send mail

  I have several tasks that I don't want to use conditional failure on. I have a ON ERROR send mail task right now that works. I want to have that send mail task include query results from a separate query. How do I do that Peter Cwik How about dropping the result of the query into a file usig the Flat File Destination and then attaching that file within Send Mail Task Just an idea... -Jamie ...Show All

• jacky1019 SSIS Auto Documentation

  Is there a tool that documents the contents of any given SSIS package Thanks, Loonysan There isn't yet but there was always plan to be: http://blogs.conchango.com/jamiethomson/archive/2005/09/14/2150.aspx Don't know what has happened to this. -Jamie ...Show All

• Stephen020960 problem connecting to datatbase via c# express

  I have a problem connecting to all databases via c# express.the error message says 'failed togenerate a user instance due to a failure in copying database files. The connection will be closed' I am using SQL server 2005 express with managment studio express and visual C# 2005 express. I fixed the problem by deleting all stff to SQL server on add and remove programmes Hi there, A few other people have experienced similar problems ...Show All

• jdang Calculated member--

  I have a reporting services report that I'm creating from an Analysis Services cube.  I created two calculated memebers.  When I put either one of the calculated members in the report and try to render the query or generate the report, I get an error: Memory Error: Allocation Failure: Not enough storage is avaliable to process this command.   I have 21 GB of hard drive space.  I do only have 1 GB or RAM, put I thin that ...Show All

• jayman16 SSIS thinks an invalid expression is valid

  I have put the following invalid expression: @[Metadata ::ValidStream == TRUE (note the lack of a closing square bracket) into a precedence constraint, clicked the "Test" button and got the message "Expression validated successfully". Can anyone replicate this -Jamie Well its a bug in IDW16 then cos ....hang on...ITS THROWING THE ERROR NOW exactly as you'd expect! I swear on my mother's life when I did that an hour ago it was ...Show All

• scuba79 Oracle and DTC

  Does anyone have any experience of using DTC with Oracle. I'm trying to enlist an Oracle connection in a distributed transaction and am getting the following error: An OLE DB error has occurred. Error code: 0x8000D048.  COM error object information is available.  Source: "ProductionHierarchy"  error code: 0x8000D048  Description: "The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with e ...Show All