Answer Questions

• Waseem Sadiq Unique Session ID

  In order to replace an Oracle DB with SQL-Server 2005 i need a unique session ID. The number Obtained by @@SPID is for reuse and does not meet my requirements. I'm looking for something like v$session.audsid in ORACLE. Thanks Raimund hi raimund Auditing in sql server is done by running the sql profiler and then storing the trace to a table or a file. using the SQL Profiler you can use ...Show All

• Jean-Luc Brouillet Management Studio all databases . . .

  I see that Management Studio lists all databases, even ones that the user doesn't have access to.  I thought this was going to be fixed so I've been watching it from CTP to CTP throughout the year.  But I can see view a list of all databases on a server even if I'm simply a db_owner on one database.  I've tested this on the September CTP build. Microsoft posted a KB article to resolve this for Enterprise Manager (SQL 2000) just l ...Show All

• beechum1 diploying reports on browser with custom assembly

  Hi friends, We are using SQL Server Reportin Services 2005 (SSRS) for development of our reports instead of Crystal Reports. As per our clients requirement we want to make all reports dynamic eg. whatever background color user select should appear for that report etc etc. So for this we have written one function and created DLL for that. Now we are refering that DLL in all our reports as Assembly Name in Reports \ Report Properties \ Refe ...Show All

• Rami Awad Dynamic ad-hoc reports

  Is there a way to pass parameters into the Report Builder so that the available fields of an entity can vary depending on a parameter value (for instance, a group or user id) We have a situation where each group of users can have a variable set of custom properties to report on and we'd like to let them access these custom properties through the Report Builder. Any suggestions on how to go about it Thanks. ...Show All

• LINGCHEN VS 2005 - VB.NET - Connect to mobile SQL database from Desktop PC

  I want to physically move my .SDF file to my desktop and then access this file from VS 2005 VB.NET. Ideally, I would want to access this .SDF file from MS Access 2003 but I undersand this is not possible. Here are my VS 2005 VB.NET statements.... Dim ConnPPC As New System.Data.SqlClient.SqlConnection("Data Source = C:\Documents and Settings\G014436\My Documents\SQL Mobile\ActMgr6CE.sdf") Dim mySqlDataAdapter2 As New SqlD ...Show All

• SomeGuyInVA with new hard drive- Error 3: the system cannot find the specified path

  Installed SQL Server 2000 Enterprise trial a week ago on XP Pro. Installed new Seagate 80G HD; used Seagate's utility to copy old C: to new drive as new boot drive. All seems to work fine, except, when booting up, SQL server doesn't start. When I try to start it manually I get the following: Could not start SQLSERVER service on the local computer. Error 3: the system cannot find the specified path. 1. What could be wrong 2. How do I fix ...Show All

• sylvainmarechal Packages not executing right on production server?

  Hi, I have developed about 20 to 30 packages that are executed on a specific order by a parent package that iterates a foreach cycle... Has in development server all packages run just fine... when deployed to the production server and executed the first child package to run gives error and says that the logging text file was unable to find the file It was supposed for the log to create and send information to the file right So i think thi ...Show All

• Adel M. error creating a new pull subscription

  Hi Using RMO, VB.net 2005 and SQL 2005 Trying to create a new pull subscription programatically - merge HTTPS ovfr the internet Works fine when within out internal network - but when externally there is a problem.... I'm using the code from BOL - using their values - but pretty much cut and pasted. ' Define the Publisher, publication, and databases. Dim publicationName As String = "AdvWorksSalesOrdersMerge" Dim publisherName As String = instance ...Show All

• Mark Stutzbach SQL Express and Reporting Services not available until June 2006?

  I am currently developing an application for distribution and am looking into using SQL Express and Reporting Services for the low end product.  Is it true that Reporting Services will not be released for SQL Express until June 2006 If that is the case then would I be required to use local reports in my Winform for SQL Express installations and use the Report Server functionality for full SQL Server installations Thanks, Adam ...Show All

• Mike Dimmick COMException when creating SSIS Package / DataSource

  I'm running sql2000 and 2005 (RTM) side by side (and vs2003 and 2005 RTM). I want to create a IntegrationServices project. When i want to create a DataSource, i can specify  the connection, but when i click on finish the screen is not closed whatever info/name/etc. i fill in. I can only cancel the dialog box. When i add a new SSIS package i get this exception: =================================== Error creating package (Microsoft Visual S ...Show All

• davidhills how to know status of previous control flow

  Hi, I have a package which has 3 data flows and a script component to write log file. Those 3 data flows are in sequence (mean upon success, next will run). If the first 2 data flows fails, control will go to script and upon completion of 3rd, control will go to script to create log file. Now, my question is, within my script component, is there any way to find out what was the last ran data flow and its status What I know is, adding a 'ac ...Show All

• Fred Nie SQL Server 2005 Express JDBC Driver???

  Hi All, I have no previous experience with servers, but I have to install SQL Server 2005 Express in order to run another application. My question is: which JDBC Driver do I need to install in order to access that Java application Could I hear from you Thanks! Hoffmann Has anyone tried using Merlia.jar provided by I-net thanks, Madhav Hi Hoffmann, Did the new driver ...Show All

• dhonda Output in Firefox

  When I run a report in firefox it only displays the report in half of the screen in a scrollable area, rather than using the whole sceen. In IE is works fine. Anyone have any ideas . Thanks. For what it's worth I was using Firefox for about 15 minutes at the beginning after moving from CTP version. Nothing was right. Then it ocurred to me - um, hello it's a microsoft product. It's designed for IE. Sorry, no answers as ...Show All

• Dawson Integration Services

  Hi all, Can someone explain to me why I am getting this kind of error though I am able to integrate all the data succeesfully to the next destination. Ronald SSIS package "Prescription.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 a ...Show All

• Akinja Problem with Database Processing Speed after Restore from Backup

  I am using AMO to deploy the structure of an analysis services database to multiple installations. I'm doing this by creating a backup of SSAS database A and restoring it as database B. I restore database B then change the data source of database B programmatically in C#, then process. Processing the original database A takes approx. 15 minutes, but it takes approx 2 1/2 hours to process database B. Each datasource SQL database contains a compar ...Show All