Answer Questions

• M S Basha Visual Studio 2005 Profession Edition

  Hi, Can anyone tell me which SQL Server 2005 tools are meant to be installed with this edition Unfortunately it wasn't me who set up Visual Studio but one of the guys in IT, so I don't know which options were available/checked. In the Product Feature Comparisons at http://msdn.microsoft.com/vstudio/products/compare/default.aspx , it states that Visual Studio 2005 Profession Edition contains "SQL Server 2005 Developer Edition". ...Show All

• Talljames How To Execute an Oracle 10g Stored Proc thru ODBC using VS 2005, for Reporting Services

  Good day! :-) Anybody who knows the syntax for executing an Oracle Stored Proc thru ODBC connection using VS 2005 for Reporting Services I am having a problem about this. I am using the ODBC connection because VS 2005 does not support Oracle Database 10g in its Oracle Database Connection feature (only 7.3, 8i, and 9i), that's y. While using MS SQL Server 2000, I never encountered any problem. But using Oracle Database 10g, I find it har ...Show All

• GimGif Deployment

  Hello, I was reading some article which said, the reporting service (sql server 2005)does not have many capabilities and so, after initial development of reports you can deploy it to a custom website or an application and then use .net to enhance report functionalities... How to do this..Please help me.! Thanks, Shankar - do you have a specific question about deployment   Reporting services provides for many reporting capabilities ...Show All

• hYp3r Replication distribution cleanup error

  I used the SQL Server 2005 publication wizard to set up transactional replication. It scheduled a job called "Distribution clean up: distribution" that calls sp_MSdistribution_cleanup. The job fails every time it runs. The xp_cmdshell is enabled and SQL Server Agent runs under an account that has sufficient privileges to execute it. The account also has full rights to the repldata subdirectories. I have applied service pack 1. I loo ...Show All

• Karlo S quastion about triggers

  hi, I have a few quastions about triggers: 1) I want that to run a specific function or exe, after a row update. How can I run a function via the trigger 2) Is ther any trigger that for an updae of a culomn (not a row) thanks, moria first of all, thank you for the detailed answer. I am working with SQL 2000, and .NET 2005. >>"More information about that can be found in the BO ...Show All

• shirine "SQL Everywhere" is a Sybase trademark

  It's all well and good that Microsoft has finally entered the well-established mobile database market (the market that iAnywhere Solution's SQL Anywhere product current *owns* by a wide margin). However, it should be noted that "SQL Everywhere" is a Sybase trademark. For confirmation of this fact, see http://infocenter.sybase.com/help/index.jsp topic=/com.sybase.help.mro12.6.mro126ig/html/mro126ig/legal.htm For confirmation of th ...Show All

• Deepthi_Pinapala SVG in report?

  I'd like to create a report which contains SVG vector data. Right now, I have an ASP.NET application which displays this data in an EMBED block of the web page, and it requires Adobe's SVG Viewer plugin to be installed. Is it possible to display SVG in a report I feared as much. My solution to this problem is to use Batik, a Java-based application to render my SVG as PNG images, and display those instead. ...Show All

• Epsilone3 SSIS SQL Agent Schedule job problem

  Hi everyone, I have a log table that track my SSIS scheduled jobs. This SQL Agent job runs every 15 minutes for now. The problem is, when I check the status(log) table, I see it fails and succeed at random. I have checked the history and I can't figure out why it is doing this. Has anyone any idea what is going on At least for the fact that the package succeeds after it failed shows that nothing is wrong with it. Again when I query my deti ...Show All

• Johan Nyvaller Flags on a table

  Hi all Been thrown a bit in the deep end and need some advice..... new to db design. I have been emailed the lay out of the table which is not a problem, they then go on to talk about flags on columns if data is inserted , updated... ect. How do i set them up The data is going to be imported in via DTS from a excel spread sheet Thanks in advance Rich Richie_C wrote: What is happening ...Show All

• Bikaram saving DTS package to sql server

  hi, I have a "Transfer sql server object task" in SSIS that transfers few tables from one database to another. The task works fine and the project is saved on my c: drive. I was trying to save the project on the SQL server and don't know if i am doing somehting wrong I have the following selections made: Package Location: SQL server Server: ServerName Authentication Type: Windows Package path: /TransferTables ...Show All

• PinkFloyd11 Implementing message queue in SQL Server 2000

  I am implementing a message queue system in SQL Server 2000. My queue table looks something like this: [MessageId] [uniqueidentifier] NOT NULL, [MessageType] [uniqueidentifier] NOT NULL, [Status] [tinyint] NOT NULL, [SubmittedTime] [datetime] NOT NULL, [StartTime] [datetime] NOT NULL, [DispatchedTime] [datetime] NULL, [CompletedTime] [datetime] NULL, [MessageData] [image] NULL This is how I retrieve the next message for processing: SELE ...Show All

• margaret lenins carter Report Distribution

  Through report manager I am trying to see if it is possible to set up a data-driven subscription, that will save the file on a file share AND notifiy user via email based on values stored in sql table. I can get each to work as independent jobs but I want this to be run as one. Can this be done   How Thanks. Not out of the box.  Each subscription has only one delivery extension it uses.  ...Show All

• hjy Dataset Filtering Not Working

  I am trying to filter data at the dataset level after it is returned. However, the filters tab on in the Dataset window does not appear to work correctly. I have tried the following expressions: Expression Operator Value =(Fields!IdLog.Value = Parameters!Id_Log.Value) = =True =Fields!IdLog.Value = =Parameters!Id_Log.Value When I rerun my dataset query, the en ...Show All

• Bill Tutt Using IDTSEvents interface when running a Package

  I am running a package from a C# application. I would like to use the IDTSEvents interface to capture events from the package such as OnPreExecute, OnWarning, OnError, etc. I created a class (PackageEvents) that implements the IDTSEvents interface. I pass a PackageEvents object into the Application.LoadPackage call that creates the package. The package runs successfully as usual, but nothing happens in my PackageEvents class. None of the brea ...Show All

• lavrinenkoe Error Viewing the Execution option of a Report

  I select the option execution from a report (it's in properties option) and then raise an error which says An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'. I have full privileges in the DB and I think the report server is well configured. This is happening since I ...Show All