Hello Is there any plans to implement Code Insight in to SQL Server 2008? Thx

I've tried several times, enabling IIS as instructed (I can see the IIS 7 home page), but I keep getting the warning message when setup runs the system check that IIS is either not installed or enabled. If no one else has run across this, I'll try to uninstall 2008 and then reinstall again. ...

hello developers!!!!! How I have to do a Report against oracle with multiple statements? I need execute multiple SQL statements in the generic query designer with an oracle connection. thanks

I'm getting an error with the script task - I suspect some sort of installation problem but any pointers would be gratefully received. I've created a package with just a script task. I've then edited the task and inserted one line: Code Snippet Public Sub Main() ' ' Add your code ...

There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc. If we envision db with a ...

I have tried to change font in SQL Server Managenet Studio Katmai . Set enviroment : Tools -> Option -> Enviroment -> Fonts and Colors - does not work . Regards Jiri Lichtenberg

Hi,when I try to install the client components I receive this error:Upgrade failed due to the following error. The error code is:-2147467259. Message: Unspecified errorI think the problem is during the upgrade of the report server components.my computer has the SQL 2005 client components ...

Will Katmai address the long standing bug(reported in 2005) of linked reports losing their layout from the parent? It would be very helpful if the linked reports would access/retain the interactive page layout, page orientation and margin information stored in the base report. See this post on ...

SSIS 2005 Execute Package task doesn’t have properties to support dynamic configurations. Here are a couple of scenarios: 1) Package could be executed on its own. In such scenario it is easy to make the package use an external configuration file. 2) The same package could be executed as a ...

Hello! I have a few questions (and suggestions) related to the new HierarchyID datatype in SQL Server 2008 (Katmai). In general, I'm really pleased to see a native hierarchical datatype. Having tested various tree operations using the new datatype over the weekend, it looks like a sound ...

Hi all~I installed SQL Server 2008 July CTP on my Windows Vista computer (OS: Vista Ultimate).When I use SSMS to connect to SQL Server 2008, a error message shown: No process is on the other end of the pipe. I check the advanced information: Advanced Error InformationServer Name: ...

I am unable to install the latest CTP of SQL 2008 on my Windows Vista machine. It gets through all the things that happen before the install starts, but when it tries to install I get the following error message:"The installer package could not be opened. Verify that the package exists and ...

Just curious if in the katmai version the subreport header/footer will be avaliable as a toggle item?

Hi Guys, When I try to import data into Sql 2008 July CTP, I get the following error: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection ...

I read the BOL, besides the "Disk Usage" collection set, are there other collection sets to be added? What are the various collections sets that we can add. Can we add performance collection sets? The sproc for adding collections sets sp_syscollector_create_collection_set didn't ...

Hi all~I installed SQL Server 2008 July CTP on my Windows Vista computer (OS: Vista Ultimate).When I use SSMS to connect to SQL Server 2008, a error message shown: No process is on the other end of the pipe. I check the advanced information: Advanced Error InformationServer Name: ...

I have installed on Windows XP 32 bit. This is running under VPC 2007. The basics seem to be working so far, but I haven't dug into it too much. Wally

Without giving away all secrets, does anyone know if management tools for SSRS will be enhanced in final 2008? As an ADMIN, not WRITER, I want to manage my SSRS to its' max, and resolve issues with individual reports and performance and security. Right now I must (1) decipher the SSRS logs, ...

SSIS 2005 Execute Package task doesn’t have properties to support dynamic configurations. Here are a couple of scenarios: 1) Package could be executed on its own. In such scenario it is easy to make the package use an external configuration file. 2) The same package could be executed as a ...

There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc. If we envision db with a ...

I have tried to change font in SQL Server Managenet Studio Katmai . Set enviroment : Tools -> Option -> Enviroment -> Fonts and Colors - does not work . Regards Jiri Lichtenberg </span>

Hi,I can not install the client components in Windows XP SP2. I have Visual Studio Professional 2005, SQL Server 2005 Express Edition, office word 2007 and power point 2007 components installed. I do not deal because this happens(passes). Would these components cause the error?The error is: It ...

Hi, Currently I am using SSRS 2005 and the Dundas Map and Chart controls. I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#. For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be ...

Dear All can i upgrade from DTS on sql Server 2000 to SSIS on SQL Server 2008 and what is about compatability? thanks ahmed mosa

Hello! I have a few questions (and suggestions) related to the new HierarchyID datatype in SQL Server 2008 (Katmai). In general, I'm really pleased to see a native hierarchical datatype. Having tested various tree operations using the new datatype over the weekend, it looks like a sound ...

My OS is WinXP </font> I don't find Management Studio after installed SQL 2008 CTP JULY.</font> Why? Thanks! bill

SQL Server Version: SQL Server 2008 CTP (Katmai Developer Edition X86, english) 10.0.1019.17SQL Server Management Studio (SSMS) version: 10.0.1019.17 ((SQL_PreRelease).070524-1510)Summary:during installation, the automatically started SQL Server Management Studio (SSMS) crashes (see step2+6, ...

For the map control in 2008, has the format of the shapes used in the control been finalized? Does the team intend to use ESRI compliant shapefiles as the SSRS2005 Dundas control does, or something else. I know it's kind of a long shot, but specifying the shapes using WPF would be wild. ...

Hi Guys, When I try to import data into Sql 2008 July CTP, I get the following error: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection ...

Hello! I have a few questions (and suggestions) related to the new HierarchyID datatype in SQL Server 2008 (Katmai). In general, I'm really pleased to see a native hierarchical datatype. Having tested various tree operations using the new datatype over the weekend, it looks like a sound ...

Any chance to get this feature in SSMS? http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124530 http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125147Also nice blog post about it: ...

Hello,I'm trying to install CTP3 of katmai on Windows Server 2004 running inside Virtual PC.It installs the setup files OK. Straight after that I get an error message box saying "The application has failed to start because XOLEHLP.DLL was not found. Re-installing the application may fix ...

Any improvement made in RS 2008 to reporting off SAP BI data sources?

Dear All can i upgrade from DTS on sql Server 2000 to SSIS on SQL Server 2008 and what is about compatability? thanks ahmed mosa

Hi, as per the BOL, In the "Optimizing Data Warehouse Query Performance Through Bitmap Filtering" the cost of Clustered Index Scan as well as Table Scan takes more time in Katmai according to sql Server 2008. Can you verify it please.

I uninstalled SQL Server 2005, and loaded SQL Server 2008 on my XP SP2 pc. After everything installed, I'm still missing the SQL Server Management Console for SQL Server 2008. During installation, I ensured I did check client management tools to have the GUI interface to the 2008 SQL ...

Evening all,I'm tearing my hair out trying to get katmai CTP3 installed.Setup files get installed OK but then it conks out with 2 error messages:"The application has failed to start because XOLEHLP.DLL was not found. Re-installing the application may fix this problem" "TITLE: ...

Does SQL Server 2008's Reporting Services RepotViewer control enable export to Word? I know that the server reports will support that. Thank you.

Hi, I have a SSIS packages which I've developed on SQL 2005 (SP2) which contains a number of ActiveX script task objects and it runs successfully on SQL Server 2005. When I tested the same SSIS package on SQL Server 2008 (June CTP) all the ActiveX scipt tasks fails without any great details ...

I read in a blog I as pointed to that the compression indexes are built online -- how is this done, live page-by-page so the impact on query is only a single page? Is it done like a shadow approach using snapshot and then switched over?

<font face="Times New Roman"></font><font face=Arial size=2> My OS is WinXP </font> <font face=Arial size=2>I don't find Management Studio after installed SQL 2008 CTP JULY.</font> Why? Thanks! bill

Tried to install the CTP and got a message stating that 2008 won't coexist with 2000. I had an instance of 2000 Developer Edition on here that I was testing some stuff with. I removed that, rebooted, and I still get the same message. Am I to assume that you can't even install 2008 if you've ...

I posted this as part of another thread in the ReportViewer area but this forum will probably provide me with a better anwser: I'm kind of concerned about the ReportViewer roadmap because it’s really confusing. On one hand, it sounds like there aren't many updates to reporting in VS2008. ...

Hi guys. This problem is somewhat related to my other problem here. This time, whenever I add a configuration file to a package I get the an error Constructor on type 'Microsoft.DataWarehouse.Wizards.WizardInitializer' not found (EnvDTE). All these weird messages came out after I uninstalled ...

Sorry - -a little new to SQL Server, but I see there is a single choice of a page at 8KB. Is there a limit to the # of rows I can get on a page outside of calculating header information and the size of each row? I know that DB2 (and I think Oracle) have actual architecual limits on the number ...

Any chance to get this feature in SSMS? http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124530 http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125147 Also nice blog post about it: ...

Tried to install the CTP and got a message stating that 2008 won't coexist with 2000. I had an instance of 2000 Developer Edition on here that I was testing some stuff with. I removed that, rebooted, and I still get the same message. Am I to assume that you can't even install 2008 if you've ...

Has the RDL 2008 spec been released yet? Thanks, James

Hi guys. This problem is somewhat related to my other problem here. This time, whenever I add a configuration file to a package I get the an error Constructor on type 'Microsoft.DataWarehouse.Wizards.WizardInitializer' not found (EnvDTE). All these weird messages came out after I uninstalled ...

<font face=Arial></font> <font face=Verdana>Is this issue handled in Katmai?</font>