Answer Questions

• m_r SQL Express license for hosting

  Can SQL Express used in a web hosting scenarion... Does that require any extra license or is free Thx! Yes. SQL Express can be used in web hosting scenarios with no extra licences required as long as SQL Express is not connecting to a higher SQL Server Edition. ...Show All

• Ckiszka Pkg Execution Works in VS but not in SQL

  I'm able to execute a package in VS Pro on my machine. However when I upload it to the sql server and try to execute the package directly it fails with: Error: The product level is insuficient for component "...." (3129) Error: The product level is insuficient for component "...." (5411) The first component is a DataReader Source which is consuming an ODBC (Noble Systems ATOMIX Driver) connection and the second componen ...Show All

• Mai Lan SQL 2005 Upgrade problem.

  Hi: I had a serious problem today. I was upgrading SQL Server 2000 default instance to SQL Server 2005 when the setup failed to upgrade the database services with the error: The password does not meet Windows policy requirements. I chose windows Authentication during the upgrade. I for sure know that my password meets all the windows requirements (length, password charcters as outlined in BOL) and still it failed. I tried more than 3 ...Show All

• jproberts Calculating date/time from Unix time

  Our challenge is as follows: A third party application writes phone call logs to an SQL Server 2000 database. The start and end times are unfortunately inserted as Unix time (seconds from 1-1-1970). We want to make a monthly csv export of these records by selecting the detail records between certain dates/times but we are having problems calculating the correct date/timestamp as there seems to be no function in SQL server that can do this ...Show All

• Acky SQL DMO Support in SQL Server 2005...

  Hi,     We have a C++ application that uses the raw SQL DMO COM interfaces to connect to the SQL Server 2000. When this application tries to connect to SQL Server 2005, it failed to connect for obvious reasons. I tried to use the latest SQL DMO interfaces and, to my surprise, in the June CTP, I didn't find any header files that contains the COM interface definitions for the latest SQL DMO. Is this something that MS ...Show All

• Steve J C .sdf deployment problem VS2005

  I have .sdf and .xds objects in my project for a PocketPC 2003 device. When I debug all of the CF2.0, SQL, and .SDF files are downloaded to the device. However, when I install via the application.cab file, the .sdf, .xds, and CF files do not show up on the device. What am I missing here First ensure that your SDF has Build Action set to 'Content' and Copy to Output Directory = True in your project. When you then create a Smart Devi ...Show All

• sanj Problems with reporting

  Hi, I am testing MS reporting on VS 2005 Beta2 with the report file (.rdlc) embedded in a Windows application (no server involved). Previewing the report works fine, but if I want to print it, I apparently must first click on the print preview icon in the viewer's toolbar and then click on the print icon. I believe that one should be able to print a report without showing the form containing the viewer; but is there at least a way of forcing the ...Show All

• Cep How to assign roles to a user on reporting server through Web Service MEthod

  I am using the Web service of SSRS to assign the roles for a user that exists on that reporting server machine. I am using the followng code to do this. Policy[] p = new Policy[1]; p[0] = new Policy(); Role[] R = new Role[1]; R[0]= new Role(); R[0].Name = "Content Manager"; p[0].GroupUserName = "systemtest\user1"; rs.SetPolicies(@"/",p); The same I have tried with SetSystemPolicy method also. Policy[] ...Show All

• Carriat Query Empty node

  Hello, I have an XML file which contains different shops, where a certain node (<openinhours>) is empty in some occasions. The node displays as <openinghours /> in my xml file in that case. Now when I try to get the openinghour value of all the shops, it shows an error that I cannot atomize. Is there any way to check if the node contains text by using the value or exist Thanks in advance! ...Show All

• Ziga Can I write SQL 2000 databases with SQL Server 2005?

  My shared hosting service only supports SQL 2000. Thank you. Steven - That is EXACTLY what I was looking for.  Bought it today. Thank you very much.  No, you cannot.  What you can do is script your databases (make sure to put them into 8.0 compatibility mode to ensure that you don't use 9.0 features like VARCHAR(MAX)) and use the DDL and DML to populate your shared hosting database. &nb ...Show All

• Challe Out of Memory

  Hi Guys, What i'm trying here is to run a .bat file containing Osql Command's on the server using asp. Which is Generating Out Of Memory Error. In Detail. This .bat file is having a Osql command to connect to a database with a parameter to run a .sql file and output parameter to give to output in .txt file. This is working fine if I simply run the .bat file on the server. its working fine no probes, but when I try the same from a .asp file run ...Show All

• Johan Lindfors - MSFT Reading more than 1 set of files using Foreach Loop Container

  Hi, My requirement is I have to read 2 sets of files from a folder. For example, I have to read all files starting with either 'a' or 'b' only. In 'Foreach Loop', if I say 'a*,b*', it is not working. Instead of comma (,), I tried colon, semi-colon and pipeline characters also. It is not working. So I am using 2 loops now. But I would like to know is there any way to do it using a single loop Thanks. You can't code this condition in ...Show All

• Leonardo Rodriguez ADO.NET Source Custom Properties - Documentation Wrong?

  Ok, so I've looked near and far and have found nothing but info that says data flow properties can not be changed at runtime....then I see in this in the SSIS documentation under ADO.NET Source Custom Properties: SQLCommand String The SQL statement that the ADO.NET source uses to extract data. The value of this property can be specified by using a property expression. Pray tell me how this property can be specified using a property ...Show All

• Betty01 Directing batch pring jobs to a remote printer

  Has anyone tried directing batch sql reporting services print jobs to a remote printer Any tips on how to do this would be appreciated. Thanks, John Take a look at the printer delivery extension that is included with the product. ...Show All

• gurminder Analysis Services 2005 Tutorial Error

  Hello, I am new to SQL Server 2005 and SQL server in general.  Recently I installed the September CTP of Server 2005.  I am currently going through the Analysis Services Tutorial with the AdventureWorksDW database.  In Lesson 2 of the tutorial after I deploy the cube, when I enter the cube browser and try to drag and drop the "Sales Amount" measure into the data pane, I get the error: The query could not be processed: o Memory e ...Show All