Answer Questions

• mnemon New Install - Log Says Eval Expired, But It's Not an Eval

  I have installed the standard edition of SQL2005 w Reporting Services on my XP Pro desktop. SQL2005 works fine, but SSRS will not. In the log, I see the message that the evaluation copy has expired--but the install is not an eval copy. I have tried uninstalling SQL Server a couple of times, but no change. Anyone know why this is happening Another log displays the message "object not set to instance of an ...Show All

• Dan Moreira "Could not find schema information ..." error in XSD annotation

  When I open any annotated schema in VC# 2005 Express, I get the error: "Could not find schema information for the attribute 'urn:schemas-microsoft-com:mapping-schema:relation'." Am I missing a reference   MSXML4.0 and the SQL Client are installed on my workstation. An example of one of the annotated schemas I've tried is this one, from Andrew Conrad's MSDN article "A Survey of Microsoft SQL Server 2000 XML Features": < ...Show All

• Gungmas 'Incorrect Syntax near' Error in Create Type in 2005

  This is getting really frustrating. I've searched and tried about everything I can think of. I have an assembly added to my database by using Sql Management Console. The assembly is called TestUDT. I have defined 4 structs within that assembly, Person, Transaction, Payment, and Seller. The assembly was added to SqlServer 2005 with dbo as the owner, the permission set is SAFE, and the assembly is signed. The structs are within the Test ...Show All

• Peter Jausovec About Login Account

  Hi everyone, I have a simple question for you which is too important for me. My question is about logins in my own(local) server. I know that my local server(my computer's server) has to default login account which are called sa and BUILTIN/ADMINISTRATOR. While I am using my own server, I do not know which default login account is used by my Server since I use windows authentication while connecting to the Server. Another question is that while ...Show All

• tzmedia Cast data type problem.Please help!

  1. My Script Task use an C# assembly which provide SQL Connection data type as a public property. SSIS Global variable as  Object data type accept it with no problem. Dts.Variables("SSISConnection").Value = DTX55AppDefaults.GetSSISConParam() - - - - - - - - - - 2.  Inside my Script Task I  declare local variable                 ...Show All

• ovmidori Server Name problem

  Hi, I have chart on a report. If i access a report from the Reportserver by the IP address of the machine, the chart shows up otherwise( i.e if i invoke it with the machine name) it does'nt show What may be the problem Have you tried it with http://localhost from the server Sometimes underlines ( _ ) in servernames have strange effects, whats your servername Wh ...Show All

• Clint_77 How can i replicate from SQL Server 2005 to Informix 10

  Hi. In SQL Server 2000 the replication from SQL SERVER to Informix 10, works excelent...! and I dont have a problem at all. But, in SQL SERVER 2005 I just can't do that... I can't add a different type of suscriber different of Oracle or IBM DB2.... Any help Please....  We want to migrate to sql server 2000 to sql server 2005 .. but we cant do that if the replication doesnt work...   ...Show All

• jonchicoine client redirect

  Trying just to figure out how this works...how does it know the other server to reconnect to What does the application see, just a SQL error and the application has to redrive the TX Can it route TX to the MIRROR and redrive it like Oracle's TAF Thanks! Ok -- one last question -- can you list for me what the native SQL Server interfaces are. I'll assume .NET for sure. OLEDB, ODBC, JDBC, that kind of stuff..is t ...Show All

• LAPIS SCD component in SQL2005

  Hello, I have problems specifying my historical attribute in the SCD component. Regardless of wich option I choose on the Historical attribute options I cannot choose a field in the table, it is simply empty, nor can I write in the information... I am using the 1st release version so I suspect that this function should be fully functioning. What am I doing wrong and how should I go about this Hanna, thanks for the additional inf ...Show All

• kerm007 how to display the fields in column?

  Good day.. can any body help me or give some ideas on how to display a fields in column Coz i have try but the info or field will display in row. i used a table. example i query a name it display in colums not in row. Christian Joseph Rey can any body help me how to do it. your help is greatly appreciated ...Show All

• Anver Error when starting Report Manager

  When trying to start report manager ( http://localhost/reports ) I get the following error. I have since given access to ASPNET and IUSR_<machinename> rights to the listed path & file, but still get same error. Any ideas Thanks. Parser Error Message: An error occurred loading a configuration file: Access to the path 'C:\Inetpub\wwwroot_sps2003\web.config' is denied. Source Error: [No relevant source lines] Sour ...Show All

• jerrymei Forecast Model

  Hi I am new to Data mining in SQL Server. I am using SQL 2005 to create a forecast model for Product sales. I two fact tables that I am using. One has all the Orders historically with the line item details. The other table is a time dimension table which has the value of each of the time values referenced in the Orders. So the time dimesion has multiple values for one day as it goes down to the hour the order was placed. Can I create a fo ...Show All

• Dinesh Kulkarni - MSFT Report Jump in Page Header

  I tried to add a report jump to a page header - visual studio mentions that this is not supported by all renders, but I did not find any information which renderers support this. It seems the default html renderer does not support it, because i receive the following error "The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalid ...Show All

• dubdiz ISO 8601 complient week numbering

  I want to make a time dimension with TSQL. To get the week number I use datepart(week, @data_variable). The problem is that the function is not compatible with ISO 8601. The first day each year is always part of week number 1 and the last day is never part of week number 1. It seems that the datpart function in VB has all this functionality: DatePart(interval,date[,firstdayofweek[,firstweekofyear]]) but the TSQL has not. See http://ww ...Show All

• Pandaurae Easiest way to get a value in af file into a variable ?

  I get a file with some key information delivered to an ftp destination each day along with some files containing rawdata. The file is a csv file containing some short description of what is being delivered. Numrows;pulltime;sourceinfo 25302524;25-01-2006;dssrv34 So the file has columndescription and 1 row with some information. My question is, what is the easiest way to get those 3 informations into 3 variables ...Show All