Answer Questions

• AlEvan Report Builder - unable to open report sample

  I have deployed the AdventureWorks report model to the report server and published the sample reports (RDLs - Customer Purchases, Product Sales by Year, and Sales by Territory).  When I attempt to open the RDL in Report Builder, I unable to open the report and the following error is reported "This report cannot be opened in Report Builder."  Any ideas Clay B Only reports that were authored in Report ...Show All

• Nicolas D How do I enable 2005's taskpad ?

  I created a new SQL 2005 DB with reporting server installed. I can run reports for any DB on this server only. I have some 5 others servers(SQL 2000) connected via Microsoft SQL server management studio. How can I enable the reporting services to report on functions(similar to taskpad on 2000) on these servers too The report buttons are grayed out when I expand those servers trees under the mgt studio. I'm a SQL 2K user just learning SQL 20 ...Show All

• jmk Cannot get the Service Broker work

  Some months ago I was playing with Service Broker and everything was ok. But now I just can't get it work. I opened a sample "helloworld" project and still cannot get a message in a target queue. No errors, just empty queues. We have two SQL servers sept CTP on different computers and both give the same issue. It looks like it should have a very simple solution that I cannot come up with. The following script initializes service brok ...Show All

• TimurKiykioglu NEWSEQUENTIALID behavior changed from Apr CTP to June CTP

  There may be a bug in the June CTP version of NEWSEQUENTIALID. NEWSEQUENTIALID had very predictable behavior in the Apr CTP build. It incremented in obvious, clear, consistent amounts. Doing inserts right after another or having widely range time intervals between inserts made no difference. With the June CTP build, things are not as predictable and do not appear to be sequential. The following output shows the guids that were created. The tes ...Show All

• Sultan Shaikh Event ID: 107 MSSQLSERVER cannot connect to the report server database

  I only receive this error message when I reboot my server. I was wandering if there was a time limit I could set for SQL before it connects to the report server database. Event Viewer Log Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Windows Help and Support provided no further information o ...Show All

• denis morozov Doing away with like '%%'

  Here's the setup @searchcondition varchar(50) --is a parameter passed into a stored procedure IF(@searchconditions is null) BEGIN SET @searchcondition = '%' END ELSE BEGIN SET @searchcondtion = '%' + @searchcondition + '%' END select * from sometable where somecolumn like @searchcondition Now the procedure is fine if the user passes a string, but if it's null, it seems really inefficient to search for '%'. ...Show All

• RayinSpain How to Convert SSIS DTS Package TO EXE Applcation

  Hi Does any one know how to conver SSIS DTS package to EXE Format... or is there any tool apart from SSIS Executable Utility Package. Regards Deepu M.I Deepu.MI wrote: Hi Does any one know how to conver SSIS DTS package to EXE Format... or is there any tool apart from SSIS Executable Utility Package. Regards Deepu M.I Could you describe why would you want to do t ...Show All

• Dinesh Reddy N Y Vista and SS Management Studio Install Problems

  Hi, I'm running the Vista Beta 2 (x64) and am trying to install SSMS. This is more or less a clean Vista install (had VS Web Express and SQL Server Express installed but those have been uninstalled). The SSMS install comes up ok and I can enter my name and company. It chugs along for a while and then fails. This is what is in the event log: Product: Microsoft SQL Server Management Studio Express -- The installer has encountered an unexpect ...Show All

• SageLT Microsoft Atlas in Reports?

  Can Atlas popups be used in reporting services Currently I have a javascript pop-up link that opens a new window. What I would like to do is change this to open an Atlas popup. Thanks can this be done ...Show All

• Erez Mor How do I update multiple base table view?

  I got a view from multiple tables. All tables have a primary key column which are linked in a diagram as relationship. So I have no problem to update this view from a direct editing environment such as 'Enterprise Manager' or 'MS Access'.  I wrote a stored procedure for UPDATE to use it from a client application (Visual Basic .NET) but when I executed this stored procedure from Query Analyzer I get error message :   ...Show All

• BauerK Insert or Update null if the value is zero using Trigger on table

  Hi , I have 2 tables (Dept and Emp) The columns in table Dept are Deptno and Deptname. Deptno is bigint and it is primary key. In Emp table, columns are Empno(PK) ,EmpName and Deptno(foreign key referring to Dept) To Insert or Update record in Emp through application, value of Deptno is coming as 0(Zero). I want the value of Deptno to be inserted or updated as null if the value is Zero (0). How to do this in sql server 2005 by using t ...Show All

• dnnguru SSIS will not start after SQL Server 2005 SP1 upgrade

  Hi guys, I have experienced a problem with a SQL Server 2005 SP1 upgrade, where hotfix.exe reported an error during the SSIS component upgrade, and then the SSIS service would not start back up. I have since attempted an additional SP1 upgrade on the server, which completed successfully, however the SSIS service still will not start. The server is running Windows Server 2003 Standard Edition SP1 with SQL Server 2005 Standard Edition (x86), wh ...Show All

• Paul Steele Problem to install MSDE 2000 SP4...

  Hi All I've tried to install MSDE 2000 SP4 onto my machine running XP SP2 but encountered the following problem: Setup failed to configure the server. Refer to the server error logs and setup error logs for more information. The "cnfgsvr.out" file shows the following: Starting Service ... Latin1_General_CI_AS -m -Q -T4022 -T3659 Connecting to Server ... driver={sql server};server=DE-PC26761-4;UID=sa;PWD=;database=master [Microsoft][ODBC Dri ...Show All

• highgrade Catch Error message in Variable?

  Greetings all, When an error occurs it is written to a log file (Assuming you have loggin on). Anyone know of a way to catch the error in a variable When an error occurs I send an email explaining where there error happened and to view the logfile. I would like to include the last error in the email. Saves having to go view the log... Thanks Hi Jamie, Thanks for your info. Actually I am also looking for this variable. In my case, ins ...Show All

• dhaval_shah Is this a silly way to use SSIS?

  I have typically done any ETL style manipulations I needed to do to data stored in SQL Server in VB.NET. I would use the IMPORT EXPORT DTS wizard to import flat files, or mabe something from ACCESS every now and then. I am looking at a situation in my current contract where I will be pulling flat files from a mainframe and quasi relational stuff from a DB2 instance via an ODBC connection. I will be using this stuff to build a datawarehouse f ...Show All