Answer Questions

• Roland2 firewalls?? port numbers?? ancient curses cast upon my servers??

  Hello All, Hopefully someone has come across this... I have the client side of my application installed in the US , with the application and the database servers running in london .   The program language is C#, all built in .net, with the .net installer. When the user in the US runs the program and it gets to the import progress part (background processing occurring on London servers), they are getting no feedback as to the progr ...Show All

• Nirmal Patel Problems with Lookup task and dates

  I’m trying to make a Lookup transformation with a relation on two string columns and a between dates condition set by parameter: select * from  (select * from [dbo].[RgnErhverv_Ansvar]) as refTable where [refTable].[Opretdato] = and between StartDate and EndDate where the second parameter is my Date column (FakturaDato_konv) . My problem is that I keep getting the error: "Error 1 Validation error. Data Flow Task: Looku ...Show All

• ElroyJ help me connet windows media to MSN video

    can you help me i want watch television on internet , good quality screen , no tracking , good audio , fast stream , can you show me or fix or update ,, thank you very much ,,,, have a nice day ,,,,, You're in the SQL Server forum - you might want to check a "home entertainment and PC's" forum instead. Buck Woody ...Show All

• Jon_DEV Storing Null values

  I am creating a UDT which is not a Native but UserDefined Format. I use the IBinarySerialize and should implement Read en Write methods. When i have a null value should i always write some null flag to the database storage Or is there another way to deal with null values like writing nothing Hope somebody can give me some more details about this. I don't really understand how reading/writing is working. Because when i store a UDT with a null v ...Show All

• Glenn Wellington Problems connecting to "(LOCAL)" from SSIS

  I've recently moved from June CTP to RTM.  I'm now having a problem connecting to the (LOCAL) server in SSIS via a Native OLE DB\Microsoft OLE DB Provider for SQL Server connection.  The error is: Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.  I'm connecting with Windows Authentication, and I can connect to (LOCAL) with Window ...Show All

• Sérgio Vasquez Can we use cubes of MSAS2000 in MSAS2005

  hi, i am currently using a foodmart database i.e. MSAS2000 and i have installed newely MSAS2005. now i wanted to use the cubes of MSAS2000 i.e.Foodmart cube in MSAS2005. is it possible to move the cubes or migrate the cubes to MSAS2005. if yes then how if not then why and is anything done to do the upgradation or the migration. thanks in advance for the answer This Project REAL paper should give you som ...Show All

• Dahlman SSRS 2005 XML datasource & report subscription question

  I'm working to enable subscriptions on some reports that have an active directory web service as a datasource as well as a standard datasource to a SQL server db. I'm admittedly new to reporting services '05, but some research tells me I can't do the job with the current configuration. As the AD web service is an XML datasource, I'm not sure if I can pass an expression...and the reporting service manager won't let me store the credentials on ...Show All

• el_richard SQL Server 2005 mobile edition free?

  Hello I have a question: is the SQL Server 2005 mobile edition free or is it necessary to buy a licence when i use it combinated with a comercial program which i have delevoped by myself and i sell it greetings stefan lederer Hello Stefan, You can freely distribute SQL Mobile so long as they operate in "stand-alone" mode. For more information you might want to check out the followng link (it has ...Show All

• MarkL1976 Query Designer in SQL 2005 is total %#%!@

  What happened to the Query Designer   It's a modal window that doesn't allow you to drag tables from other databases into the query.  SQL 2000's verion of Query Designer was so much better than 2005.  What happened   Are the developers at Microsoft completely retarded   Also, why do I have to log into my database servers everytime I open "Server Management Studio"   Who thought up that nice feature   Probabl ...Show All

• Piyush Jain SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• Al_Robson Starting to use SQL Server 200 Exp

  Hi I want to start to use SQL Server 200 Express but have no idea where to enter the SQL queries and view the results. I installed SQL Express and under Start > Programs > SQL Server 2005 I only have Configuration Tools which has Configuration Manager, Error and Usage Reporting and Surface Area Configuration. SQL Server and SQL Server Browser Services are running but I have no clue of from to start creating my database, tables, etc etc. I ...Show All

• K. Rose Dynamically changing the value of ToggleItem/visibility of ToggleImage

  I am using Reporting Services to produce column-oriented, printable. reports from Analysis Services OLAP cubes. The dataset rows for a Table contains leaf-members, measures, as well as fields containg values of the leaf members parent member names up to the top level. I then group the rows in the Table on each Dimension Level and makes the sub-groups invisible. The visibility of each sub-group is also toggled by a report item in the parent group ...Show All

• Buddy transfer access DB to SQL 2005 PRO

  Dear, i have a huge msaccess 2003 DB i want to transfer it to SQL 2005 , i found tool to imigrant oracle (and i used it) but i can't find solution to imugrant msaccess thanks avner on your MSAccess tools menu in you should find Database Utilities -> Upsizing Wizard. If you don't see it, it needs to be added via Add Remove Programs. Modify Office/Access to add the "Additional Wiza ...Show All

• Erik_VB! Load time of packages? Turn off validation while loading?

  Nitesh, Loading packages can be a looong process in September CTP too, unfortunately. Andrew Watt MVP - InfoPath wrote in message news:b795f68f-0c7c-4263-a698-e572902def57@discussions.microsoft.com... > My solution contains 28-30 packages in one solution. > Each time I try to open a package (which was closed earlier), it takes a > loooooooooong time to load. Is it only june CTP or thats typical. > > Is there a way I can disab ...Show All

• asqui Answer: Shared Datasource

  Hey ladies and gentlemen,    I am trying to create a shared data source and am getting the following error -     An error has occurred during report processing. (rsProcessingAborted)     Cannot create a connection to data source 'Best_Data_Corp'.    (rsErrorOpeningConnection)   Login failed for user 'XvTVTVTVXOP. Background information: - I have a sql se ...Show All