Answer Questions

• tutto_24 SSIS Installation Problem

  I tried removing and reinstalling SQL Server 2005 Developer Edition for three times, including "all-at-once" component installation and "component-by-component" and I just can't get Integration Services to install. Here is the setting: - I have WinXPPro SP2 - I had SQL2K and removed it - I installed SQL2k5 (as described above) I am getting the following error: Microsoft SQL Server 2005 Integration Services -- A component that you have specified ...Show All

• CarlofNH SQL Server Reporting Services Installation - Urgent

  Hi all, Wondering even any can help out with the problem below - I am getting an error when I am installing Sql Reporting Services on my web server. The error it gives is 'The domain account that you specified cannot be validated. Verify that the user name and password are correct, and that the account has permission to log on to this computer' Some Back ground Information -  -  The machine am installing it on is outside my netw ...Show All

• Beh99 query for row creation/last update

  I'm working on a database migration. The destination DB has date fields in each table for row creation and last update the source DB does not.  Is there a system table or way to query the transaction long to find the entry date and last update date for a row using the primary key in the source DB Thanks for any help There is no builtin audit function for that. The typical audit is to create a trigger and ...Show All

• Gombly SQL Server 2005 Replication and views

  Hi, I read that views can't be published with SQL Server 2005 replication. Is this planned for the future If not what alternatives are there for this Simple collecting the data needed in a new table ain't a solution for us (memory consuming). And joining the data on the PPC ain't a good solution either (memory and time consuming). We only want to pull the data. Greets, Ivo Klerkx Just to confirm y ...Show All

• Rich Visotcky What's Happened to Copy Objects in Import/Export Wizard?

  I have just upgraded to SQL Server 2005 from 2000 and went to export some objects to another server and found i no longer can - well at least the easy way. Can anyone tell me what has happened to Copy Objects in the Import / Export Wizard Where can i find it now Regards, John http://connect.microsoft.com/ Allows you to file bugs, suggestions and follow their progress. please file these in ...Show All

• DonMartin Set password to database on SQL Server 2005 express running in mixed authentication mode

  Just like with Access DB, can we set password for database in SQL Server 2005 Express Reason to do so is, user with Login having sysadmin previliage can acess all databases in SQL server. so just want to restrict database access to only those users who knows the password. Is there any possible solution Pls comment. Thanks. You cannot set a password for the database. You can encrypt data in the dat ...Show All

• f_scholer Using Reporting Services 2005 on SQL Server 2000?

  Is it possible to use Reporting Services 2005 on licenced SQL Server 2000 without a licence of SQL Server 2005 Thanks for your answer, Andreas I am not sure about the licence but RS 2005 does support connect to SQL 2000. If they are on seperate machines you will need two licences.  I don't know the answer if they are both on the same machine. -Daniel 3 examples: Q: 1 SQL Server 2000 licence, SQL ...Show All

• Damian B Converting a Hex String to a Varbinary or vice versa

  I'm using SQL Server 2005. How can I convert a hex string to a varbinary or the opposite of that Please take a look at the links below for some options: Integer value to hex http://www.umachandar.com/technical/SQL6x70Scripts/Main89.htm Hex to integer http://www.umachandar.com/technical/SQL70Scripts/Main29.htm If you don't have a table of numbers (which the 2nd link uses), you can use ...Show All

• learning_dotnet Newbie question, moving data between sql server 2000 and 2005

  Hi, I'm a newbie on SSIS and am trying to grasp my way through this. I am trying to copy data from a Sql Server 2000 database to a simplified table in Sql Server 2005 database. What I want is to move the data to a staging table, then drop the main table and rename the staging table to the main table, to minimize the down-time of the data. I can't get the workflow to work, because the staging table has to exist when I run the packa ...Show All

• SlinkingFerret DRILLTHROUGH MDX statement or SQL statement

  Hi Ours is homogeneous OLAP with source data coming from SQL Server. The staging server pulls data from Production server and serves the purpose of source for the Analysis server. We are using web based client to display data returned after executing queries these queries can be of both types SQL as well as MDX. We can use DRILLTHROUGH MDX statement to get row level information but the same can also achieved by writing SQL s ...Show All

• Vinival rsInvalidReportServerDatabase

  We are getting the following error when we try to deploy SQL report on to the reporting server the error: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.20'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase) We are using SQL server 2005 CTP and .Net 2005 ...Show All

• Nick Guerrera - MS Model definitions

  I've inherited a database from a vendor. This database has primary keys defined but not any foreign keys to other tables. The vendor establishes all their relationships in their code. I've created a simple model off of the base tables, but can only report on one table at a time which makes perfect sense. What is the best way to create a more usable model Create views with foreign keys defined and then use the views as my source for the ds ...Show All

• Wilson Jiang semi-addittive measures

  Hi everybody. From the site:http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx I saw that, whilst the Time Intelligence is available for both Standard and Enterprise Edition, the semi-addittive measures will be available only for the Enterprise Edition. How is it possible From what I understood the Time Intelligence is also used to have the possibility to have the semi-addittive measures, isnt'it Further, if I can't use the semi ...Show All

• Arun-YEG Extracting Cube detailed info

  Hello, Could I write ActiveX Script in a DTS Package to return cube info (such as CubeName, CubeStatus, CubeSize, CubePartitions, CubeLastProcessed) If that's possible, I could then pump in the result into text file and import them into a table for reporting purposes. Please let me know if this is the best route to explore DSO objects or any alternative way of extracting this type of Cube data. -Lawrence ...Show All

• Oleg V. Shastitko SQL Server 2005, MS Access Merge Replication?

  Hey there! In a nutshell, I want to do a merge replication with a SQL Server and several Access databases. I haven't been able to find anything in the documentation or 3rd party books. Is this possible Thanks! - Erik Good day! It's SQL 2005. I can roll it back to SQL 2000 is SQL 2005 doesn't support the feature as well. Thanks for the link! I'd looked all over the place for that. T ...Show All