Answer Questions

• snaill SQL Express Exceptional error

  Hi, I have this exceptional error when I am accessing SQL Express using MS SQL Server Management Studio Express. Below are the versions I am using. Microsoft SQL Server Management Studio Express 9.00.1399.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5. ...Show All

• 123666 Error locating server/instance specified

  I am trying to connect to the AdventureWorks database while using Visual Basic 2005 Express. I am currently using the SQL Server 2005 trial version. Here is the error message: An error has occurred while establishing a connection to the server. When connecting to SQL server 2005 this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, Er ...Show All

• Laurent Chesnais Join tables Count problems

  Help,   I have 2 tables one called ProjectHeader and the other called ProjectSuppliers.   There is a one to many relationships. I’m trying to get a count of the total number of projects for a certain supplier where the Date Entered is less then 5/1/2206 with the Bid Date greater than 3/31/2206.   When I run the query below the count comes back wrong.   I know it’s because the ProjectSupplier table can have multip ...Show All

• Kammy Storing bulk data from dataset to sql mobile 2005 using c#

  hi, I have developed an application in c#.net 2.0 for Pocket PC. And even i developed a webservice to communicate between sql server 2005 and sql mobile 2005. Webservice returns the data in a dataset format from sql server 2005, but while inserting the data row by row from dataset, it is taking a huge amount of time. I would like to know, is there any way where i can copy the bulk data from dataset into the sql mobile 2005 using c#.And how th ...Show All

• RAnderson14 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

• Simonth How to create a torn page.

  I want to write a magazine article about torn pages. Is there an easy way to create a torn page Or does anybody have a backup of a sample database such as AdventureWorks that has a torn page To simulate a torn page, you'll have to "corrupt" a database page on disk. This can be done with a hex editor, or other tool. Our pages are 8K in size, so 16 sectors of 512bytes. We have 2 kinds of validation: che ...Show All

• pkaranth SQL Server Reporting Services - data extension 'XML'

  The reports based on XML is perfectly displayed in development Environment. But than uploaded to Server, the following occurs: An error has occurred during report processing. An attempt has been made to use a data extension 'XML' that is not registered for this report server. Help needed, thank you. Thank you for the answer! Is there are any way to revoke this limitation ...Show All

• Bart1 Cannot connect to MSSAS 2005 Standard on local machine

  I have installed SQL2005 completely, including Service Pack 1. Using Mgt Studio, I can connect to the relational db. I am not able to connect to analysis services though! The error message I receive is :"A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient". The additional information says: "Unable to read data from the transport connection: An existing connection was forcibly clo ...Show All

• Stuckagain override print button in report manager?

  Ok, i've been wrestling with some print layout options. Problem is, i'm figuring out, that the Explorer control doesn't deal with precise layout details or pagination very well. So i'm going to come at it from a different angle : is it possible to override the default functionality of the print button in Report Manager    That is, replace the Javascript call that currently invokes the print dialog to something that invokes ...Show All

• Jack Suddards Reporting services

  Hi all, I have three data sets to populate a report. and after this I have to use these datasets in an expression but they cause these error s which says that the report item needs to be in the same scope as the dataset and that it cannot be used in an aggregate function. Can we use multiple dataset in an expression inside the a report if so how (p.s one of the datasets is a stored proc) what this sproc does is that it give a header name for my ...Show All

• dvj81 Using SMO to backup / restore a SqlExpress database

  Hi all, I have seen several threads on using SMOto backup & restore sqlexpress databases but am having trouble getting my code working. Does anyone have a snippet available Current problem is connecting to the sqlexpress database file Thanks, Nick How about, How do you back up a file that is part of a User Instance. What would you use for the connection string. Does this thread address ...Show All

• PhilWilson Missing image in PDF Export version

  I have an ASP.NET application that passes stored procedure params and generates a dynamic report with one or more Image controls. The image paths are created with absolute references to their locations in a separate web directory, the one that the .NET app calls the report from. So the stored proc returns a string similar to http://mysite.com/myimage.jpg , and with an expression I wrote in the report designer, I assign this to the Image contr ...Show All

• craig kelly-soens XpectWorld Welcome to the Notification Services Discussion Forum!

  I don't think that's possible.  However the Forums are available through RSS.  This should provide you some of the same abilities as a news reader.  RSS is a great benefit, but it doesn't really compare to being able to browse via a NewsReader.  With a good NewsReader I can:     - Browse and compose offline    - archive postings to my local machine for future reference   & ...Show All

• Rich MSFT Restore Master Key

  Do we need to know the database master key password inorder to restore the same from a Master Key backup What if the scenario is like, I have Master Key backup file but do not have the password specified at the time of creation Any help is appreciated. satya Works like a charm !! Thanks. Only concern, I have is that we need to remember little more things for recover process to work perfectly :) Is there any white paper y ...Show All

• BlackSwan data miner, i think?

  hi not sure if i'm in right forum or not! but i have been getting a 'cannot find server' message for about 2 months now. i run AVG software and Ad-Aware SE and Spybot to try and combat viruses and adaware and spyware. usually what happens is i am using the internet and then this 'cannot find server' message, although the internet connection is still there. then i run all my software, find no viruses but Ad-Aware finds tracking cookies, data mine ...Show All