Answer Questions

• Kai123 Will FTP and File System Tasks run in Workgroup Edition?

  I have a package that does an FTP and some File System Tasks. It runs perfectly fine in BIDS but doesn't want to run via SQL Agent. Is the SQL Server Edition the problem The error message is: The task "Get CMP File - FTP Task" cannot run on this edition of Integration Services. It requires a higher level edition. Or you could try to use FTP component in script task Or you could try to create batch file and execute that I suppose it could be. But then do you have any error messages Erik Sampsell wrote: The error message is: The task "Get CMP File - FTP Task" cannot run on this edition of Integration Services. It requires a h ...Show All

• Neil Enns MSFT Landscape Printing issue in SQL Reporting services

  I have reports, set to print on Landscape and Legal ie 14 * 8.5. However, when certain users try to print the report, it prints it in Letter, even though the report is set to print in legal /landscape. The strange part is that for most users it prints correctly in legal, only for some it is on letter. Any idea why this would happen 1. Yes, The issue ocurs consistently for the same users. 2. Will try setting to PORTRAIT and see. 3. Yes, the user is able to print the report in legal from other applications. I found the issue.It had to do with reports printing off of LEXMARK printers. The printer driver had to be updated and that seemed to fix the issue. ...Show All

• Bradrover how can i use comma like a decimal separator in Sql Server Express?

  I need HELP "update product set price='1,99' where cod='001'" I need COMMA... not DOT In oracle i use "alter session set language='Brazil'"... but... in SQL SERVER Moving to the "Transact-SQL" forum. Take a look if maybe that will help you: ms-help://MS.MSDNQTR.2003FEB.1033/tsqlref/ts_sp_da-di_2tk5.htm ...Show All

• papadi Verfiying stored procedures

  Hi, I wish to run a stored procedure which will verify a digital signature on some data and return a pass or fail. Is there a way for me to ensure that the stored procedure returning the result is one created by me rather than one created by someone else that always returns a pass without checking the digital signature I know i can encrypt stored procedures but these encryptions can be broken with a profiler/ debugger. Thanks, Ewen Thought that might be the case but thought i would ask anyway. Thanks for your replies. Ewen OK, nothing changed in here. You can still only obfuscate your procedures with encrypting them. http://groups.google.de/group/ ...Show All

• AndersBank READ_COMMITTED_SNAPSHOT

  READ_COMMITTED_SNAPSHOT in 2005 is what I wanted. However, I am still using 2000. READ_COMMITTED in 2000 is different. Can anyone give me advice on this issue (or there is no way in Sql Server 2000 to handle the following scenario: Process One UPDATE tableA SET fieldB = 'testing' WHERE fieldA = 1; Process Two SELECT * FROM tableA WHERE fieldA = 1; While Process One is working, Process Two will fail. But I just want to allow Process Two to read the data (i.e. the version that before Process One is working). This is what READ_COMMITTED_SNAPSHOT do in Sql Server 2005. ) Thanks for any advice. Thanks for your confirmation. Better to upgrade to Sql Server 20 ...Show All

• Jason Baginski SSIS - Connection String Issue

  Hi I have been trying to resolve a connection string issue all day, and havent figured out whats the problem. I keep getting the Acquire Connection error everytime I run my package. Can you someone review the format of my connection string, and confirm that it is indeed the correct format: I have two conn strings specified in my config file, one is to connect to a remote database and one is for local. I have validated the connectivity from my server to these databases via Management Studio, and it seems to connect fine. But when I run my package it keeps failing. SQL Server Authentication(Remote Database Server): Data Source=server_name;Username=useraccount;Password=xxxxx;Initial Catalog=dbname;Provider=SQLNCLI.1; Window ...Show All

• pdavis68 Export format - restrict list

  Hi! How I can restrict list of export formats for custom reports E.g. "Production report" requires only XLS and PDF formats in the list. Is it possible Sorry, it is not possible to restrict export formats on a per-report basis. Thanks, Donovan. You can modify your ReportServer/rsreportserver.config file on the server. Find the Render section and comment out any Extension entries you don't want available. Thanks, Donovan. Thanks. But this solution will be applied to ALL reports. What of separate report ...Show All

• iowa242943 SQL Native Client Error during MS SQL 2005 Instalation on MS Vista Ultimate RC1

  Hi ! How to avoid a SQL Native Client Instalation (a corrupted package from MSDN Disc ! ) during MS SQL 2005 Server Standard instalation on MS Windows Vista Ultimate RC1 ! Generally after this error all instalation failed ! Thanks in advance. Hi. I've also tried to install SQL 2005 Express with Advanced Services (included SP1 and...) but I had the same nature of an error connected with SQL Native Client that was during MS SQL 2005 Std. I've read some tips from the internet (for instance : a copying binaries from CD to the hard disk, an arising a privilidge level of a running setup) but without the effects ! Bye. Hi. I have the problem with install SQL 2005 Express. During setup I recive: shared me ...Show All

• ks06 Scalable Text mining with Sql Server 2005

  Hi, I have a large dataset of website content that I am trying to classify using the Logistic Regression Algorithm. I am running into a memory issue with the Sort Transform after the Term Lookup. With about 45,000 sites in the source DB the number of rows after term lookup is 6,790,311. The Sort transform is unable to handle this large an input. If I do not use the sort transform, then the prediction query returns an error. Can anyone help me out on how to make the text mining example provided at http://www.sqlserverdatamining.com/dmcommunity/_tutorials/688.aspx more scalable Thanks, Mohit ...Show All

• zdrae Problem - cannot connect; but I know this should work ! AHA!

  Hello - I've setup SQL Server 2005 from scratch over half a dozen times now. I have remote connection down cold. Install the SQL Server. Run Surface config. Enable remote connection over TCP/IP and named pipes. Set up client alias. Restart SQL Server. (I install for mixed mode every time.) Every time this has worked up till now. Start up SQL Server Mgmt Studio, select the server to login to, enter the sa user name and password, boom, you're in. This time I cannot get in. Connection is denied both for sa and windows authenticated login as Administrator. This is the two line dump from event viewer - the first is an audit problem, the second is the error. Event Type: Failure Audit Event Source: MSSQLSERVER Event Category: (4) E ...Show All

• einstine98 Visio ShapeStudio and MS SQL Server 2005 Express

  I'm running Visio 2003 on Windows XP with SQL Server 2005 Express rather than MSDE. Is this configuration supported If yes, how does the SQL database get built since SSADMIN.exe (delivered with the Visio SDK) does not detect an MSDE compatible database when SQL Server 2005 Express is not installed I have tried to set up a SQL Server installation for ShapeStudio. The DDL script SStudio.sql has a syntax error on line 1588. I've been able to get ShapeStudio to respond in a read-only capacity. Every time an effort to create an object or otherwise write to the database yields an error. I seem to have all the permissions correct but still no luck. Chris After a prolonged ...Show All

• PublicError Synchronizing SSIS Packages Calls

  I have several SSIS Packages which are called by few different applications. I need to make packages Mutually Exclusive, so that If one is running; calls to any other Package should be put on wait till the running one has finished its execution. What are the best ways to do this I would sincerely appreciate inputs in this. Thanks Brammer, I had something similar in my mind but, here are problems 1. How do I deal with "race condition" on calls to update the control table 2. How would I put either SSIS Package or SP on sleep or wait Thanks you for your reply. Search for "sleep" and you'll get plenty of results. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=131070&SiteID=1 You could u ...Show All

• pfear Really basic question about inserting data into a SQL database

  Hi everyone, I'm new to programming, and trying to learn and can't seem to find a clear-cut answer on how to insert text from a textbox into a database as a new record. I have a textbox and a button that when the button_click even is fired, that it will insert the data from the textbox as a new record. Any help will be greatly appreciated!! i'm using Visual Basic to perform an insert when a button add is pressed its surpose to insert the data from a textbox to the database the data type of the tables column is char(4) its similar to the top code but u have to add some other stuff do u know what they are If it's SQL Server you can do something like this (in C#) SqlConnection c ...Show All

• Erik Eilerts Fortnight Date Dimension in AS2000

  I am new to AS and currently using SQL Server 2000 (upgrading soon). I need to provide information using fortnightly dates. Ie, the user should be able to see data for a specific fortnight beginning (or ending) date. Fortnights always start on a Sunday and finish on a Saturday 2 weeks later. I can write a stored procedure to identify the fortnight start or ending date based on an input date, but how do I call this from AS (as a calculated member ) so that it can be drilled down to within a Time dimension Thank you, you are wonderful :-) !!! Assuming that you already have a date dimension table for the Time dimension, you could create a User-Defined Function (UDF) like u ...Show All

• Frank Cazabon Recover Database File

  hi all, i have SQL 2000 server with SP3, yesterday my database was suddenly goes to suspect mode. then i found log in sql server log. and it shows following text: I/O error (bad page ID) detected during read at offset 0x00000000030000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\MFS_Data.MDF'.. kindly, do needful for recover data from this file... Tejas Kishanwala You will need to restore your backups to recover the database. hi, thanx for giving answer. but i have backup before 1 week. and my all important data is in the database. i have already resotred by backup. but is there any way to read this MDF file Manually and retrive data from it. Kindly, d ...Show All