Answer Questions

• Jedrzej OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All

• FS2K Cannot show requested dialog Error on View Database Permissions

  I am having issues with the database permissions on SQL Server Express. I downloaded the SQL Server 2005 Express Edition with Advanced Services SP1 and everytime I try to view database/schema permissions I get an error "Cannot show requested dialog."  I have 3 different installs of Sql Express 2005 on different machines and they all throw the same error.  The error happens in a couple locations but one way is going databases > select any database > Security > Schemas > Select and right click on a schema > permissions > and click view database permissions, I get the error message below.  Does anyone else have this problem   Thanks Scott   ================= ...Show All

• andyedw SSIS FTP Task problems

  We are unable to retrieve a file from an FTP server using SSIS FTP Task. With the settings indicated below: IsRemotePathvariable: False RemotePath: /home/ftpu/test.csv IsLocalPathVariable: False LocalPath: working_directory (with Connection Manager entry setup for this) Operation: Receive files The following error is produced: Error: 0xC0029183 at FTP data, FTP Task: File represented by "/home/ftpu/ns_test.csv" does not exist. Performing a manual ftp works fine, hence suggesting a fault with the SSIS TFP Task. Has anyone else successfully used an FTP task, and if so, any ideas on what's going wrong Thanks Neil When editing the RemotePath value within FTP Ta ...Show All

• chakravarthy_b Populate a variable

  During a dataflow - I like to populate a variable with True or False based on a value in one of the data records. How do I do this excercise  if I use a script - can someone provide me with simple script on how to populate one variable   Thanks heaps         Thanks all - finally I got it to worrk. Public Sub Main() MsgBox(Dts.Variables( "RutaFicheroCarga" ).Value) Dts.TaskResult = Dts.Results.Success End Sub If you retrieve your record using the Execute Sql Task... Double-click to edit properties. In the ResultSet drop down choose Single Row In the Resu ...Show All

• Radiant-designer Versioning RDL files?

  How do I version rdl files I would like to be able to look at a report that is load on the ReportServer and see a version number. Any thoughts or ideas on how I can do this ...Show All

• NewGuy212 RS2005 Date parameter - JScript error

  I have a RS2005 report that was deployed to a ReportServer and has been running for over 1 month. I personally have not run this report in the past month, however, today when I tried to run it I got an error trying to select a date parameter. I can't paste samples of the windows displayed, so I'll do my best to explain. When I click on the report, it goes to the View window and displays 2 date parameter fields. When I click the icon next to one of the parameter fields, I get an error window that says A Runtime Error has occurred. Do you wish to Debug Line: 383 Error: 'resultfield.id' is null or not an object I click Yes and get a VS Just-in-Time Debugger window, where I choose New instance of VS 20 ...Show All

• MauricioUY ODBC support

  Can CE be called from an app. that makes ODBC calls Thanks. Yes, but he was asking about ODBC access. No, I'm not sure why he needs to use ODBC... Ah, be that as it may, OLE DB and the .NET Framework providers are also industry standards. Yes, ODBC is certainly the oldest, and least flexible but granted, it's still in wide use. ODBC is supported in both OLE DB data access interafaces and .NET providers. The tiny SQLCe database is small because its support is focused on current technology. If it was more flexible in its interfaces I expect it to be larger and less useful for its intended purpose. I you can remember the neame, that would be very helpful. - A ...Show All

• KitGreen Sql Management Studio Express

  I recently installed Sql Server Management Studio Express on my computer. I am unable to connect to a remote instance of Sql 2005 using this program on my computer. I have shut off windows firewall as well as my third-party firewall but have come up with the same error message. TITLE: Connect to Server ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) I installed Management Studio on another computer and was able to ...Show All

• Senthil Nathan.S Parallel Processing of Partition

  Guys, I would like to thanks Elizabeth for a great document. Appreciate it. Under " Maximize parallelism during processing", I see the following bench mark. # of Processors # of Partitions to be processed in parallel 4 2 – 4 8 4 – 8 16 6 – 16 In our scenario, we have a huge dataset which means processing about 20 partitions in parallel. The box we have is a beefy box DL 585 4dual core CPU with 32 GB memory and we are using the 64 bit architecture. However when monitoring the trace I see the following:- 1 - Process Processing of Fact 2001 Partition 8:05:43 10:11:04 25 - Execute SQL S ...Show All

• Crane101 incorrect syntax near '\'

  hi! i'm using a linked server and currently executing this query: "insert into tbl_local ( fieldname )" + "select * from openquery( server\instance_remote , 'select fieldname from db_remote .dbo. tbl_remote' )" ; when i run this on a C# program it gives me the error of 'incorrect syntax near '\''. What should i do with this please help!! here is the code: private DataSet ds1 = new DataSet ( "local_table " ); private String cs1 = "data source=SQL;uid=user;password=password;database=local_db" ; private String cs2 = "data source=SQL\\mysample;uid=user;password=password;database=remote_db" ;   private void button1_Click( object sen ...Show All

• DavidSB The attempt to connect to the report server failed

  I have RS running on Standard server 2003 I receive the follow when trying to access the main page. The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version I can view reports from the location below just not view the main page. servername/ReportServer works fine included error log file 01/02/07 18:10:34, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514) 01/02/07 18:10:34, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied 01/02/07 18:10:34, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2364 01/02/07 18:10:34, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0 01/02/07 18:10:34, AC ...Show All

• LennardF1989 Bulk insert in SSIS

  Has anyone else had this problem I am using 'OLE DB Destination' task in a data flow. When I select 'Table or view - fast load', check 'Table lock' and 'Check constraints' and run the flow, I get only one row inserted. The data flow edge shows hundreds of thousands of rows flowing to destination and the task completes (turns green). The problem goes away if I uncheck bulk load (e.g., select 'Table or view'). Is fast load using bulk insert or some internal code That is weird. Have you tried to set a value for 'Maximux insert commit size' As far as I know SSIS uses bulk inserts when fast load is selected. Use SQL Server profiler to see the databse activity while the package is being run and insepect the results o ...Show All

• Coriolan How to find oldest file in a folder

  I may have one or several files in a folder that act as source files. How do I loop through the folder, picking the oldest dated file according to its 'Date Modifield' attribute. Do I have to use a Script Task or similar as I can't seem to find a way to do it with normal tasks. If so, does anyone have example code. Thanks P R W. I have not done that; but I think this thread can help you: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=632171&SiteID=1 Make sure you vote on that suggestion... ...Show All

• Praveen.Yarlagadda Can multiple apps connect to the same database?

  I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message; "Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use." I would like to be able to copy the file to my office computer where it would be ...Show All

• Kartit T-SQL Question--right place?

  Hello, all. I couldn't find a forum for T-SQL questions so I hope I am in the right place. I am creating a very simple UDF to calculate a percentage difference: Create Function [dbo] . [AmtDiffPercentPY] ( @CY decimal ( 15 ), @PY decimal ( 15 )) Returns decimal ( 15 ) as begin Declare @difference decimal select @difference = ( @CY - @PY )/ @CY return @difference End My problem is that when I use float, numeric, or decimal types I get an integer result of zero, when I use money I get a decimal result of 0.00, as if the division is using integer division and not returning the fractional value during division. Any advice Thanks, Lisa Morgan Thank you! ...Show All