Answer Questions

• hb2 using Activity Monitor to identify deadlocks

  i just had a deadlock, and using activity monitor i killed off one of the processes and that solved it, but, for future reference, how do you identify which processes are caught in deadlock in activity monitor i just see whats running, and on what database. i kill off one of the processes that i dont need if there is a deadlock. i think that is a bit general and i could be killing off processes unnecessarily. how do i make sure im only ki ...Show All

• paulballard Scripting in C#?

  Is it possible to script a script component in a dataflow task using C# or is only VB.NET supported If so, will support for C# be added in the future Regards, Henk   Henk v J. wrote: Is it possible to script a script component in a dataflow task using C# or is only VB.NET supported If so, will support for C# be added in the future Regards, Henk Currently only VB.Net is supported. C# will indee ...Show All

• Ramanakumar Printing

  Hi I created a report in MSRS and i am able to preview the same, but i dont have any options to print the same. Is there any line of code / buttons to add for enabling the same. Thanks Is there a redistributable for the activex control This is an option in the IE security setting. Your users must accept to install the Activex once , then it would be transparent to them. ...Show All

• JNadal Exec procedure on database create/rename/delete ?

  Hello, I need to execute certain procedures automatically when databases are create, renamed or deleted. I looked around in this forum and Internet but couldn't find anything. This is for SQL 2000. Thanks a lot Chad. This is very helpful. I didn't think about alerts. Well, in SQL 2000 it's not as easy as in SQL 2005 where you could use DDL triggers to achieve this. You ...Show All

• Beemer Email subscription failing when report is included in email.

  Hey All, I am using SQL Server RS 2000 and I am running an issue. I create a subscription to email a report to a list of users. Everything works fine if I just setup the subscription so that a link to the report is to be sent in the email. But if I tell the subscription to include the report in the email, the sending of the email fails. What am I doing wrong Is this a known issue If so, is there a patch for it Thanks, Jean ...Show All

• apdil Difference between Where and Join

  Hi all, i've a little question, I 've this 2 sentences select m.id from F, A, M where F.Id=A.Fa And F.IdE=A.IdE And M.IdItem=A.Id and M.IdE=A.IdE And F.IdE=7 AND F.Id=44387 Select m.idnumero from F Left Join ( A Left Join M ON (A.IdE=M.IdE) AND (A.Id=M.IdItem) )ON (F.IdE=A.IdE) AND (F.Id=A.Fa) Where F.IdE=7 AND F.Id=44387 F=50.000 Regs A=150.000 Regs M=1.100.000 Regs First sentence takes the data in 1 sec ...Show All

• Maik Wiege Can someone clarify why only a single-statement can be executed in a command?

  I'm evaluating SQL 2005 Everywhere Edition for use by our desktop application. I'm a traditional SQL Server developer and I rely heavily on stored-procedures to encapsulate basic data manipulations across multiple tables and inside multi-statement transactions. I was excited to see an in-process version of SQL released and my thought was "this is great... now I can ditch the tediousness of individual OLEDB/.NET commands, and write batche ...Show All

• M Sivakumar Access DB2 on AS/400 using IBM OLE DB Provider

  Hi, I am using the IBM OLE DB Provider (IBMDASQL) provided with Client Access (IBM) to access a DB2 database on an AS/400 (iSeries). Using an OLE DB Source in the data flow and Access Mode set to "OpenRowset" this works fine (even though I think it is quite slow). However, when I change the Access Mode to "SQL Command" my data flow fails at the OLE DB Source component - not giving me any meaningful error description (only the mysterious "... th ...Show All

• tflanman Where is the old Enterprise Manager :(

  Why is this new version of SQL Manager so difficult to use Tasks I was able to do in one step, now I have to do in several steps: 1) Genrate Drop Scripts for tables, views, stored procedures 2) Generate Create Scripts for tables, views, stored procedures 3) Import data to the server I used to be able to do all this in Enterprise Manager in one DTS package . Which I could automate to synchronize data beteween two databases. Is there s ...Show All

• Kent Ogden The SQL Network Interface library was unable to register SPN. Error: 0x490

  I recently installed SQLExpress Beta 2 on WinXP. After power up and logon there is a substantial delay - minutes - sometimes maybe forever. In the event viewer I see: "The SQL Network Interface library was unable to register SPN. Error: 0x490" This is on my home network with two computers one using WinXP the other Win2000 configured as a workgroup. I say maybe forever because if I tire of the wait and hit system reset - after ...Show All

• dfad44Kyle variables in sql command

  Hello I have an existing DTS package and I convert this to Integration Services but now I have a problem: i have in my dataflow an OLE DB SOURCE and an OLE DB DESTINATION In the source I have the following sql command: IF '<<FullLoad>>' = 'Y' BEGIN  SELECT *  FROM  Maintenance_Departments END ELSE BEGIN  SELECT *  FROM  Maintenance_Departments  WHERE Last_Updator_Date_Time BETWEEN '<<StartDate ...Show All

• Aleks K Dynamically change the DataFlow Queries

  Hi Guys, This is Ravi. I'm working on SSIS 2005 version. I have created the DTSX file from the SQL Server and executed it successfully from my .NET 2005 code. Now I have a requirement that I need to dynamically change the Source database query. ie., based on the user selection I need to get the data from different tables of SQL and put it into an Excel file. Can anyone help me in this.. Regards, Ravi K. Kalyan Mascon Global Limited. ...Show All

• techbuild MSSQLServerOLAPSerice will not start.

  I setup a MSSQL 2005 Cluster running on top of Virtual Server 2005. Everthing was running fine until this morning, when suddenly Analysis Services failed to start on the Cluster. When I looked in the Event Log I see the following: Source: MSSQLServerOLAPService Category: (289) Type: Error Event ID: 0 Description: The service cannot be started: The DOM parser failed to load and parse the stream. URL:'' Reason: 'A document must contain exac ...Show All

• Todd Kitta RS2005 Crashed After Editing and Restoring Config Files

  Dear Anyone, Here's what happened. We backed up the web.config and the rsreportserver.config. We messed around with it trying to make an assumption worked. When we finally gave up, we deleted these files and renamed back the web.config and the rsreportserver.config files. To our surprise when we tried to open our report manager, the error below showed up. We tried to reconfigure the report server using the reporting services configuration too ...Show All

• Waquas s rsInvalidDataSourceReference Error

  Hi, I have published the data source and the report on the report server programmatically. When i open the report either using URL redirection (programmatically) or from the Report Manager screen, the following error message is displayed. The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference) If I change the report properties manually using Report Manager s ...Show All