Answer Questions

• ploxis isNumeric() - it can not be right?

  hi, i am migrating data from a legacy system with a not nice front-end. as a result, i have all sorts of garbage stored on the tables. i am trying to convert values from varchar(12) to float, but i have an error during selecting data that says that data can not be converted eventhough i am using the ISNUMERIC() function to ...Show All

• Othello How to format leave detail into tabular/pivot format?

  Hello Expert! I need help to I translate this data... Table "LeaveDetail" StaffNo | StartDate | EndDate | LeaveType | 1 | 23/04/2006 | 26/04/2006 | AL | 2 | 24/04/2006 | 25/04/2006 | MC | 3 | 26/04/2006 | 27/04/2006 | EL | 1 | 30/04/2006 | 02/05/2006 | EL | Into this format... |Apr|Apr|Apr|Apr|Apr|Apr|Apr|Apr|May|May|May|May| StaffNo |23 |24 |25 |26 |27 |28 |29 |30 |01 |02 |03 |04.. ----- ...Show All

• lotusvball Parallel SQL Destination Load Pre-Process error

  I cannot find any information on this error. It occurs on packages that are writing to the same table using a sql server destination. I suppose it would be a good exercise in error handling, but I'd rather avoid it. Error: Unable to prepare the SSIS bulk insert for data insertion. Error: component "FACT_BillingLineItem Destination" (22652) failed the pre-execute phase and returned error code 0xC0202071. The ca ...Show All

• NirBenAmi Certificate limitations in SQL Server 2005

  I have a Web site that has a database backend, which stores user information.  I would like to encrypt the user information in a granular way. My question:   Is there a limitation to the number of certificates that can exist in SQL Server 2005   I would like to issue a certificate for each user of my Web site, whereby the certificate is protected by the user's password (which I will not have access to -- the password will b ...Show All

• SurferJoe Calc Measure Immediate Viewing

  This is probably obvious, but.... In MSAS 2000, I could immediately view the new calc measure in Analysis Manager without rebuilding the cube. Is this still possible in SSAS 2005 Can you list the steps Thierry, Thanks for the answer. It was very helpful. I've read that you can develop in Online Mode in the BI Studio to get the same affect as in Analysis Manager (AS 2000). What is the difference between using the debugger in ...Show All

• Shreyas Ranade (MSFT) Time Zone Question

  Is there anybody having experience about Time zone on SQL server we have an application which needs to process difference time zone. If the time is UTC, it will be easy to deal with it. If the time is Daylight Saving Time(DST), that will be so complicated. Anybody has good idea or any suggestion I would appreciate it! Not sure if it helps, but the best website for DST is: www.thetimedifference.com ...Show All

• dbradley Changing Connection string in multiple packages.

  Scenario: 130 dtsx packages using 4 matching connections. 3 of those connections are stored in an SSIS Configuration table in an Operational database. The last connection is in a shared data source and points to the Operational database so the packages can grab the others. Problem: It's time for deployment and all of those connections must change to production servers. The 3 are no issue, just change the ConfiguredValue in the SSI ...Show All

• gennaro ingenito users and limitations

  can sqlExpress handle 200 users all at the same time Yes, but it isn't tuned for that many. I'd recommend breaking up the data into more than one server or upgrading to a commercial version. Buck Woody ...Show All

• Grant Holliday sseutil.exe - passing variables

  I have not been able to successfully pass variables from the sseutil.exe command line to a sql script file. For those of you unfamiliar with sseutil.exe, it is a free utility that works with both SQL 2005 and 2000. Download it from here: http://www.microsoft.com/downloads/details.aspx familyid=fa87e828-173f-472e-a85c-27ed01cf6b02&displaylang=en The ReadMe.htm file contains this:   -run <filepath> [<var1>=<val1>[,... ...Show All

• senthilkumarr Disable password policy enforcement SQL server 2005

  Is there a way to do this at the server level Thanks Yes, but then you would disable the policy enforcement at the OS level, not at SQL Server level. Thanks Laurentiu No, there is no global switch to turn on or off this protection. Thanks Laurentiu I guess yes there is you have to open the Local Security settings using the mmc plugin and disable the Enforcements of policy settings li ...Show All

• Netenrich SQLXML managed classes - passing parameters to templates (error or documentation lack?)

  hello, i just made template file: < xml version="1.0" encoding="utf-8" > <root xmlns:sql="urn:schemas-microsoft-com:xml-sql"> <sql:header> <sql:param name="ids"/> </sql:header> <sql:query> execute comparegoods @ids </sql:query> </root> and it work just fine from virtual directory, but when i try imlement this in C# using SQLXML managed classes ...Show All

• jerrison Problems with remote SQL 2005 server and excel as an input source

  Hello, I am trying to write my first couple Integration Services packages using SQL 2005.  My configuration is a workstation running windows xp professional, and a windows 2003 server that is running the SQL server. Anytime I run a package that accesses the remote server from my workstation, the job fails with an error code.  The workstation cannot seem to run a package to load data to the remote sql server.  Why is thi ...Show All

• A_Maltas Expressions

  When creating expressions we have access to a list of functions. It is my understanding that while these functions seem to have the same names and parameters as SQL functions, they are not so. They are implemented in the package libraries themselves. It is also my understanding that this function library cannot be extended to add new ones. Am I correct If so... why not Leaving alone the fact that they follow the same screwy names as SQ ...Show All

• pano SQL Express - Monitor commands

  Hi, is there a way to monitor all commands run against the database live while they happen I can see single commands in the Activity Monitor but that's only for the last command. Thanks, Tom Hi, Express is without the profiler, so there is none. Perhaps there are some thridparty tools achieving this, but there is none out of the box for Express. HTH, jens Suessmeyer --- http://www.sqlserver2005.de ...Show All

• Dina Holan MSFT installing sql

  i have a problem installing sql server 2005 CTP editon,iam using  visual express beta 2 editions of  vb and vc# 2005 what is the compaitable sql version i can use with them You can download the June CTP of SQL Server Express at: http://www.microsoft.com/downloads/details.aspx FamilyId=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en Since the version of .Net Framework changed you will also ...Show All