Viewing 15 posts - 2,461 through 2,475 (of 3,366 total)
It means IIS 6 is either not configured correctly during installation or Asp.net is not registered with IIS. So you need to remove IIS 6 in add remove Windows...
January 28, 2009 at 1:28 pm
Your tables are not UNION compatible because you have 10 and 20 columns which means both tables are not equal. I don't think you can create partitioned views and...
January 28, 2009 at 12:13 pm
You can make it stored procedure then SSRS must execute it because control is passed to the relational engine. But SSRS still rejects stored procedures with many local temp...
January 28, 2009 at 11:38 am
You cannot have any JOIN because that will prevent the update to the base tables. Look in the link I posted there are sample codes showing all tables are...
January 28, 2009 at 11:23 am
N' means Nchar or Nvarchar meaning it is Unicode text data.
January 28, 2009 at 9:57 am
You are saying the same thing I am saying because you can create a view to reference many tables but to be updatable it must reference only one table. ...
January 28, 2009 at 9:50 am
An updatable view must reference only one base table however you can create Partitioned views which can update more than one table but all tables must be UNION ALL compatible....
January 28, 2009 at 9:31 am
In SQL Server 2005 and 2008 Integration Services and the SQL Server Agent are disabled by default so go to configuration manager and right click and enable the services both...
January 28, 2009 at 8:43 am
Vista is IIS 7 not IIS 6 but you need to configure IIS 7 in IIS 6 mode and enable all the features needed to run Asp.net. Check the...
January 28, 2009 at 8:10 am
In most cases Triggers are obsolete but most important Triggers were created by the RDBMS vendors to enforce business rules before added to ANSI SQL so like most things in...
January 26, 2009 at 11:02 pm
The short answer is no because SQL Server 2005 SSRS is IIS dependent but I found a work around using SQL Server 2008 SSRS with SQL Server 2005 relational engine....
January 26, 2009 at 6:55 pm
Update using the FROM clause violates JOINs are idempotent rule in relational algebra.
Microsoft needs to provide Proclarity as MDX query builder in Kilimanjaro because as Ralph Kimball says...
January 26, 2009 at 5:42 pm
You need to make sure IIS is installed because if you are not getting reporting services in 2005 it is related to IIS because it is IIS dependent.
Microsoft...
January 26, 2009 at 4:07 pm
You don't have IIS6 because IIS6 only comes with Windows 2003 so you are running IIS5 but that is not the issue. You need to remove existing SQL Server...
January 26, 2009 at 3:42 pm
It is not complicated to move data from DB2 to SQL Server you can use DTS/SSIS to move the data and automate the process. The first link shows you...
January 26, 2009 at 10:41 am
Viewing 15 posts - 2,461 through 2,475 (of 3,366 total)