Answer Questions

• tushars SQL Reporting Services Subscription Does Not Work

  We have two SQL Reporting Services Servers (Test and Production).  In the Test environment I have set up some subscriptions to email reports to me, it works great. I have tried to set up reports in the Production environment, but the Report Manager never even attempts to email a report to me.  For example, this morning at 8:30 I set up a subscription to email a report to me at 8:45.  It is now 9:15.  I have not received the r ...Show All

• dsdsds MSMQ Connection Manager and input into a data flow

  Firstly the disclaimer: im a total SSIS bunny. Ok, with that out of the way... What i want to do is have data read from an MSMQ message (which will be a simple XML message) and have it transformed and inserted into a simple table. Sound simple, but i cant work out how to do it. I started a new Integration Services Project and dropped a Data Flow task on the Control flow tab, then double-click it to go to the data flow tab. I have added a MSMQ co ...Show All

• Harpreet Singh Khandiyal Msg 6573 - method in assembly is not static - how do I make it static ?

  I'm using Delphi 2006 to create a DLL which will be integrated into SQL 2005. It's been a long road and I've made a lot of headway, however I am currently having the following problem creating the stored procedure: My dll name is 'Crystal_Reports_Test_01' In the DLL, my class is named 'Class01'. In the DLL, my procedure is named 'TestMe' I've managed to integrate the DLL into SQL using the following statement: CREATE ASSEMBLY TEST_ERIC_01 AU ...Show All

• Jazza68 Loading Large .dtsx Files in BIDS

  I have developed a series of very large SSIS packages for loading wide fact tables within a DW design.  While the packages are not that complex (a single data flow that contains a source query that pipes data through a series of lookup/derived column/union all transforms to handle each dimension key lookup), the have gotten rather large (2+ MB). When I try to open these packages in BIDS, it takes an extremely long time (in some cases, over ...Show All

• Jason Prickett-MSFT query duration using parameters vrs no parameters

  Hi, I have an app in C# that executes a query using SQLCommand and parameters and is taking too much time to execute. I open a SQLProfiler and this is what I have : exec sp_executesql N' SELECT TranDateTime ... WHERE CustomerId = @CustomerId', N'@CustomerId nvarchar(4000)', @CustomerId = N'11111 I ran the same query directly from Query Analyzer and take the same amount of time to execute (about 8 seconds) I decided to take the parameters ...Show All

• Angela Zhou SQL Server Toolbox & Designer

  I just had a clean install of Sept 2005 CTP SQL Server. I am new to the software and trying to grasp a few handles to start development quickly. In particular I am looking for a (form) designer associated with the Toolbox which I populated with tools I need successfully. The only thing that bothers me a bit is that the tool bars appear to be very dimmed, kind of barely visible but they react to the cursor when it is passed over them. I do not un ...Show All

• Raja Ram Singh SqlServer SMO StoredProcedureParameter Bug?

  I'm creating a Windows Forms application which auto-generates my stored procedures for me. Based upon a column's DataType property I'm creating instances of StoredProcedureParameter as below: if (column.InPrimaryKey) { StringBuilder parameterBuilder = new StringBuilder ( "@" ); parameterBuilder.Append(column.Name); sp.Parameters.Add( new StoredProcedureParameter (sp, parameterBuilder.ToString(), column.DataType)); ...Show All

• phlox Framework 2.0 changes - TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.

  If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our VB.NET app as well for clients with Wireless conn ...Show All

• JonasHei Access to SQLServer Database from Visual C# app and ASP.NET app

  I've created a visual C# GUI that logs data over a LAN.  The GUI is for Admin purposes only so it logs data and stores it (plus some admin stuff).  The data that is logged is supposed to be served up to anyone on the network as a web app.  I've got an instance of SQLServer running and the GUI works great but I can't seem to get the web app to connect to the database to read and display the data for general users I'm new to ASP ...Show All

• LittleNew SQL Job execute access

  Hi, I have a DTS package in an instance of SQL Server 2000. The DTS package has been scheduled to run on a particular time. Also this may be need to execute by a user explicitly. Which role i have to assign to the login of the user to execute the particular job . Currently the job is not listed the 'Job' tree when i view through EM by using the login. But it is coming for 'SA'. Kindly help on this. Thanks No the additional roles for Sql A ...Show All

• holthaus SQL Authentication issue

  I have a SQL 2005 Developer Edition server which was configured to accept connections using both SQL and Windows Integrated authentication and this has worked great for some time now.  Recently, however, it has started generating an error 18452 "The user is not assoicated wit ha trusted SQL Server connection," error message whenever I attempt to connect using SQL Server authentication.  When I check the server to see if it is still con ...Show All

• Spenceee Non-clustered indexes on 1 separate fileGroup?

  Hi Guys, I am reviewing the storage structure of my growing db. I am going to create multiple FileGroups and db files. Most of the filegroups will be used to allow table partitioning and put the heavily used partitions on different storage than the read-only archives. TempDB will also have its own filegroup/storage. For Indexes, I have a doubt. I am sure I can have all my non-clustered indexes on a separate fileGroup and storage but wha ...Show All

• January Named Sets

  Hi, I defined 2 Named Sets, so as to filter my calculated members: NamedSet1: {([Dimension1].[MyLevel1].&[X]),([Dimension1].[MyLevel1].&[Y']),([Dimension1].[MyLevel1].&[Z'])} NamedSet2: {([Dimension2].[MyLevel2].&[A']),([Dimension2].[MyLevel2].&[B']),([Dimension2].[MyLevel2].&[C'])} It works well, but I didn't manage to use them in the same expression like Sum(Crossjoin([NamedSet1],[NamedSet2], [Me ...Show All

• Nikola Dudar reportviewer control

  How do i Refresh a reportviewer control to have it reflect the changed RDL file in SQL Reporting services It sounds like the report is cached (maybe by your web browser) Try to clear the chache manually after the first output and then render it again... Hi, I tried that..but did'nt work out.In my app i have 3 dropdowns and acc'g to the selection s made in the DD's a RDL fi ...Show All

• Andrew Kidd snap shot agent refuses to snap new articles.

  Hi There This refers to SS2000. I have the following problem. I added 3 new articles to a publication, then i normally start the snapshot agent which snaps over the 3 new articles. I did this on 2 other servers before this one with identical publications , distributors etc, everything exactly the same and it all worked 100%. After the snapshot agent copies them over they replicate as per normal. With the 3rd server it refuses to create a snap ...Show All