Answer Questions

• luca morelli can pocpet pc direct connect to sql server 2005?

  i plan to upgrade sql express to sql 2005 enterprise. if i upgrade to enterprise can i direct connect to sql server 2005, is it need to install other software on pocket pc or on my server thank you if you are creating a .NET Compact Framework application for your mobile device, then yes, you can use the System.Data.SqlClient namespace to execute queries directly against SQL Server 2005 Enterprise. Darren ...Show All

• OTNS Sharepoint 2007 Report Services Addin Install Problem

  I have the following setup: Windows 2003, Sahrepoint 2007, Report Services Addin (v9.00.3033) on one machine Windows 2003, SQL Server 2005 SP2 CTP (v9.00.3033) on another. When I install the Report Service addin on the Sharepoint machine, the install goes fine; however, when I go to the Application Management screen in Sharepoint Central Admin I don't see a "Reporting Services" section or a "Manage integration settings" link. Any thoguths Thanks, Atul Never mind. I had to log off and log back in as the box's admin. I did a repair. Wa-la the links appeared like magic. BTY: The RS_SP_<number>.log file is located <C>:\Documents and Settings\<_user account_>\Local Settings\Tem ...Show All

• nbaker Shrinking databases or files

  Hi, I have some doubts about Shrinking databases or files. while shrinking a file, I learned that we are alllowed to shrink more than the minimum size of the file, does not it bring damage to the data in that file And no (to my knowledge atleast) performing DBCC SHRINK DATABASE OR FILE does not cause any corruption of your database files. Hi Derek, You claim that databases grows slowly day to day and are you sure that while growing day to day, they always fill the unused spaced in pages I also would like to ask something abou th following: Most databases require some free space to be available for regular day-to-day operations. If you shrink a database repeatedly and notice that the d ...Show All

• Attila Fogel Error converting data type varchar to float.

  Hi, I am experencing a data type cast issue in T-SQL, basically our application comtains both numeric and non-numeric data in the same column, I want to retrieve the numeric data only. Assuming a table has one column create table TT(c1 varchar(20) ) and insert 2 rows into the table insert into TT values('100') insert into TT values('test') Now if I want to do numeric comparison on column c1, I will get an error, e.g. select * from TT where c1 >100 because SQL server trying to convert 'test' to a number impcilitly. I tried to create an UDF to handle the non-numeric data conversion, e.g. if the data is numeric then return the number, if the data is non-numeric, then return a NULL. create function numcas ...Show All

• xavito SQL Beginner's Question - Computed Column

  I'm currently writing an app in VB Express. One of the VB modules is a timesheet where I have to subtract "finishtime" from "starttime". I created a computed column in SQLExpress that accomplishes this, but of course updating the table from my frontend causes an exception.  I know within SQLExpress this can be worked around by running the update twice. Question: Should I place computed columns in a seperate table that is not updated or Stuff programming protocol and not handle the error and just run the update query twice from the frontend or A suggestion of your choice, please be nice, a novice SQL user here. I don't particularly want to have to do the calculations each time the data is downloa ...Show All

• Tigerroad Render InlineHTML Reports doesnt Render Charts.

  Hello, I have a report that has subreports for each row, that subreport is a Pie Chart. Here is an screenshot. http://www.avansoft.net/~levalencia/ejemplo1.gif Look that the report has an image on the header, It RENDERS fine on HTML, but the Pie Charts doesnt render. The PDF Renders fine. http://www.avansoft.net/~levalencia/1.pdf private void GenerarInPlaceHTML2() { string path = reportPath + strReporte; ReportExecutionService rs = new ReportExecutionService(); rs.Url = reportServerURL; System.Net.NetworkCredential reportCredentials = new System.Net.NetworkCredential(reportUser, userPassword, domain); rs.Credentials = reportCredentials; // see if Report URL parameter is defined ...Show All

• Quilnux problem creating varbinary(max) data type

  I'm unable to create a field with the type varbinary(max). When I try doing this with Management Studio, it tells me that the maximum length is 8000 bytes. I've also tried creating the field with DDL as shown below, but that doesn't work either. If I create the varbinary field with a length of 8000 or less, it works fine. Is there some trick to using varbinary(max) Thank you. create table images (filename nvarchar(250) primary key,photo varbinary(max)) The T-SQL folks may be able to help here. Whitney: Your suggestion worked. Thank you very much! Sounds like compatibility level is set to 80(2000) instead of 90 (2005). You can get the level by right clicking on ...Show All

• Monah84 manipulating ntext in stored procedures

  Hi, I have been trying to write a SP where, in the result set is brought back, two ntext columns are combined with a text string, However I get an error when I click on apply; "Error 403: Invalid operator for data type. Operator equals add, type equals ntext" I can only assume that this means you can't add (or even manipulate) ntext columns in a SP. Short of changing the sp to bring back 3 columns and to do the manipulation in my c# code I can't think of a way round this. Anyone with any ideas thanks in advance rich SP code ( I have highlighted the problem area): CREATE PROCEDURE [dbo].[usp_RCTReportQuery] @PersonType varchar(255), @Status varchar(255), @Oustanding varchar(255) AS DECLARE ...Show All

• DarthCoder Executing packages in a specific sequence

  I am facing some issues while working on SSIS in VS2005, The Scenario is we have 35 excel files from which we have to import data to Sql 2005. We have to execute these packages in a specific sequence so we are not using For Each Loop Control. Now the Problem is this that we have 35 executables as an output that is corresponding to each package, and from each executable we can Change excel path and Sql Connection String. The problem is that one has to open each executable to set the path; we wanted to keep them Configurable like , as if we can have any variable define in the packages for path, and in the packages we use that variable and append the XLS file name to it like .. @PathVariable+ test.xls A ...Show All

• Arun C URGENT: Problems with guest user in SQL 2005 restoring databases from sql 2000

  Hi all. I don't know if this is the right forum to post this question, but here it goes. We have restored into sql 2005 the database backups made in sql 2000. We connect with trusted connection and application roles, and when trying to execute a transaction to another database (with the guest user), we get a permission error. Does anyone know if, apart from restoring the databases, we should do something else to get the guest user working the same way as with sql 2000 in the restored databases Thanks in advance for your help. First, If the guest user could do the things you expected, it means that you have assigned permission to it, or the public role has enough permission to finish y ...Show All

• rodniko Exporting a table with changing column names to an excel file

  I'm trying to write an SSIS package that exports a table that has changing column names to an excel file. The column names change due to the fact that the table is created by a pivot daily. the only thing I'm missing is the ability to dynamically map the tables' columns to the excel destination. Is this possible I read in another thread that "It is not possible to create packages or new objects within packages using SSIS." I also read in the books online that "The input and the input columns of the Excel destination have no custom properties." To me this means that I cannot programmatically create or remove columns in the excel destination. Please tell me I'm wrong. So, to summarize my research so far. In writing an ...Show All

• Rupesh Bhurke SP2 Report Builder and default save location

  Prior to SP2, when you clicked the save button it would take you to the root of Report Server. With SP2 (in old-style Report Manager mode, not Sharepoint integrated mode) it takes you to the /Models directory by default when you click save. Is there a way around this If I launch Report Builder via the following URL, it does fix the problem. But it doesn't let me pick table/matrix/chart. I would like to override the default save location AND be able to let the user pick table/matrix/chart: http://localhost/reportserver/reportbuilder/reportbuilder.application model=/Models/MyModel&savelocation= Suggestions I don't really understand why this default location was changed. In what I would assume to be a typical world, ad-ho ...Show All

• barkingdog SQL varchar conversion

  Ok i've been asked to right a sp that converts a date. Now this is usually quite easy, but unfortunatly it was a poorly designed DB, and the date has been stored as a varchar(50) in the for dd/MM/yyyy, so doing a stright CONVERT(dateTime, Field, 101) doesn't work. So my question is, is there a way to do a varchar to varchar conver such as this: CONVERT(varchar(50), <field>, 'MM/dd/yyyy') where <fields> is varchar(50), and data stored within it is in the format dd/MM/yyyy. Thanks for any help you can give. Hello, There's a few ways to tackle this, with the easiest being: SET DATEFORMAT dmy GO SELECT CAST(ColumnNameHere AS DATETIME) GO You can use SET DATE ...Show All

• tee_user5 problem connecting to database server with distributed SRS install

  Hi, I have a sql server 2005 database server that is remote to my SRS intall (SRS is installed on a separate IIS server). The install goes fine, the SRS config all shows green - but when trying to connect via IE ( http://servername/reports ) I get an error that it cannot make a connection to the database: The weird thing is that it is showing the computer account as having login failed instead of my user account (which it just asked prompted me for). I have changed nothing on the IIS server, but the dba's have changed some stuff on the sql install i'm pretty sure. Can anyone tell me what needs to be enabled for this default SRS install to work What could they have changed on the sql server to make it do this or...How can I stop ...Show All

• RajDas Parameters for Report Builder

  Is there a way to set parameters for a Report Model I have a database that includes data for a lot of users and I want to be able to use a Report Model but only allow the user to see data related to their UserID when they are using Report Builder to build a report. Is this at all possible Would I have to set up some custom authentication Thanks for any help. Ok, I understand I can limit access to certain parts of a report or datasource, but I want to be able to filter data based on what user is doing the ad hoc querying. So I can do a Select * From tbl_UserData Where UserID = @UserID. I want to be able to set this @UserID paramater somehow, but not have the user select it. Is this possible Or would I n ...Show All