Answer Questions

• UdiAms Cannot open a connection with SQL Server 2005 Developer Edition.

  I have installed on one computer Sql Server 2005 Developer Edition (CTP Version) together with a Visual Studio 2005 Beta Edition (July Version) and after configuration some properties by example the Network access, I had a lot of errors from the SQL Server Management Studio received(The most of them are a Connection timeout error but others errors too). In the same time I have made a test program to test the new SQL Server 2005 using DB Li ...Show All

• Rod_Kane Derived Column Calculation

  Example: (47 / 204709) * 12000 = 2.754 Both values (47 & 204709) are of data type Int. SQL Sever - Derived Column Calculation returns 2.74 The destination data type is Float I have converted the data types to Float, Decimal & Numeric and still got the same answer. Any suggestions Can you post your expression up here -Jamie Michael E ...Show All

• xmlfan Random access in a result set

  I use an SQL task to produce a result set which I store in a package variable. It works fine to access the result set in a script task by first casting it to a ADODB.Recordset, and then enumerating it and accessing the rows in the given order. But is there a simple and clean way to randomly access the result set  In other words to repeatedly select a random row from it One thought I had was to conver ...Show All

• DirtyHowi Catch Error message in Variable?

  Greetings all, When an error occurs it is written to a log file (Assuming you have loggin on). Anyone know of a way to catch the error in a variable When an error occurs I send an email explaining where there error happened and to view the logfile. I would like to include the last error in the email. Saves having to go view the log... Thanks JAmin, How Can I put conditional precedence constraints into the OnError eventha ...Show All

• Ben Gracewood Financial function

  Hello, I seek a solution for the cacule of YIELD TO MATURITY of the bonds. In Excel av YIELD() but SQL server Do you have an idea Thank you SET NOCOUNT ON CREATE TABLE Cash_Flows ( cashflow DECIMAL(8,2), valuta DATETIME ) INSERT INTO Cash_Flows VALUES (-95.92,'20060115') INSERT INTO Cash_Flows VALUES (5,'20070115') INSERT INTO Cash_Flows VALUES (5,'20080115') INSERT INTO Cash_Flows VALUES (5,'2009 ...Show All

• LuisSpain Mismatch in Conversion Handles

  Hi, I am developing an application to mail the Newsletters on a daily basis with Service Broker . I have a peculiar problem, that the queues associated with same dialog is giving different conversation handles. I'm testing the application with one mail at a time, i.e., there are not more than one item in both the queue at one point of time. But the handles returned by the queues are different within the same conversation. Why it is happeni ...Show All

• AlBu70 SQL 2005, replicating Encrypted Data?

  Hello, I've been searching for information on this for awhile unsuccessully. I am using SQL Server 2005 Enterprise Edititon and transactional replication with separate publisher, distributor and subscribers. I need to encrypt data on our publisher and then I need to replicate that data out (i.e., encrypted data, not encrypted transmission). Since the keys are server specific, I imaging there might be some difficulty in doing this, but I f ...Show All

• arun gaikwad SQL 2005 Very Slow on Itaniam 64bit

  Hi, I am facing a very wierd problem with SQL 2005 Itaniam 64bit with 4 processor machine. A simple SQL Select Statement: Select * from table The statement takes almost 45 minutes on a table of 7 million records, while on SQL 2000 32bit 2 processor machine it takes 10 minutes. The checked the index, and rebuilt it several times and still the problem persists. I tried the database fine tuning wizard but still no effect. Tried ...Show All

• JerryJK Hundreds Of VIEWS

  What are the downsides to have many multiple views on a SQL Server Database It was somebody's design decision to create 10 views for each vendor in our database- that could range from 20 to 500 vendors ... which means we could potentially have 5000+ views in our database. What is the downside/problems with doing this Is it not possible to create ten views that allow you to specify the vendor ...Show All

• Alexei Vladychevski Looping over files not available in my ssis

  I'm downloading zip'd files and would like to loop through each file that was downloaded. I'd also like to unizip each file and append all of them to one file. I have a dos batch that is fairly simple and would like to emulate it using ssis. Here is what the dos batch file looks like. DATE /T >%TEMP%\D.txt FOR /F "usebackq tokens=2,3,4 delims=/, " %%i IN ("%TEMP%\D.txt") DO SET fname=TAMF_162%%i%%j%%k-%%k.zip ...Show All

• Helios Proxy Account

  Hi, I am using SQL Server 2005 June CTP and having trouble seeing the active subsystems for a given proxy account. I can successfully create a proxy account and assign Activex Script and Operating system (CmdExec) subsystems access to this account. However, when i goto the proxy account and click properties, i cannot see the subsystems to which the proxy account has access to. Thanks, Priyanga Hi Laur ...Show All

• Michael Cain SSIS Send Mail task problem

  Hi, I have got the problem connected with Send Mail Task in SSIS. The general idea was: sending email alert to different email users. I tried to use Foreach Loop task which loops through dataset (where the emails are stored) and assign different email addresses to SSIS package variable. When I try to use this task inside Foreach Loop task I receive this error message: "Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occu ...Show All

• malefly Currency Symbol Problem

  I am currently writing a report in SQL 2005 RS and have a problem with the format of a currency field. I am creating the report through the 'SQL Server Business Intelligence Development Studio' In the report preview (and live) it shows the prefix for the field to be $, and yet when I look at the custom format for the field it shows it as being Format Currency and the sample shows the output will be ￡1,234.00. If I change the format to percentag ...Show All

• format1337 Stopping User instances

  Can't seem to find the right place for this question, so I'll try here. We're using SQL Express User Instances in an application we're developing, and we'd like to know if there is a way from the parent instance to stop all child user instances (ie kill the processes) Thanks! ...Show All

• John van Kaam http protocol violation when webrequest in sqlfunction, thanks

  when I use webrequest to call a url, I got "The server committed a protocol violation", I found out this is because the url returns something 2.0 think is not standard, the solution is turn on useUnsafeHeaderParsing, so I add the below to my machine.config <system.net> <settings> <httpWebRequest useUnsafeHeaderParsing = "true" /> </settings> </system.net> but after I add that, I got different error when I call the ...Show All