Answer Questions

• Jane Stop This Crazy Thing SQL server memory leak

  I was doing a quick test with SQL Server Express and noticed that there is memory leak Here is the pseudo code do loop //1000 times { 1. Open connection to the database 2. Build SQL statement 3. Construct SQLDataAdapter 4. Fill DataSet using ( adaptor.Fill(dataSet); ) 5. Close connection to the database 6. Dispose whatever is disposable } When I ran this test I saw that SQLServer service memory usage is going up ...Show All

• Yanick management studio how to change where my projects resides

  file -> open -> file when the open file dialog comes up. I don’t want my projects to reside in \My Documents\SQL Server Management Studio\Projects How do I change where the my projects folder resides Or at least change where it defaults to open a file from let me answer my own question. hack this thing and do whatever you want HKEY_CURRENT_USER\Software\Microsoft\M ...Show All

• Jim_SE How to invoke C# code from SSIS? Can we script in C# for Script Task?

  How to invoke C# code from SSIS Can we script in C# for Script Task thanks There is no big problem "developing some code in VB.net" on the surface, but since the the original poster wanted to use C# over VB.Net, as the title and posts indicates. So this is a problem for them in so much as the answer for them is no, as you can only use VB.Net which is not what they wanted. Doug, Agreed that it is not an SSIS issue. And ex ...Show All

• fcp How do I know where my message come from

  I have a service broker service and there are multiple clients that can put messages in the queue of that service. How do I check which message comes from which client There is no field in the queue like message_senderId or something like that. If all you need is to send back replies, then is not necesary too know the sender of the message. Simply send back replies on the conversation_handle received and they'll reach the sender. If y ...Show All

• AsbjornRygg Installation SQL Server 2005 Express Edition

  My Installation failed for the SQL Server. Is it true  that the SQL Server is running only in Windows XP Prof with Service Pack 2. Thanks!  Hi, That is correct. The software requirements have been explicitly mentioned as Windows XP Service Pack 2 on the download page here . Regards, Vikram ...Show All

• Vallari Kamble MSFT Maintenance plan job unable to send Mail Alert

  Our configuration : SQL Server 2005 June CTP Enterprise Edition version : 9.00.1187.07 OS : Windows 2003   The Problem: After configuring Database Mail account and profile, maintenance plan or job generated with the maintenance plan Wizard is unable to send mail.   The SQL Agent error log contains those messages pointing on a bad profile name.   Error Messages [264] An attempt was made to send an email when no email session has be ...Show All

• doyoucy is it possible to have variant condition clause in procedure?

  i want to use OLEDB to build a COM for my app in the case, i want to execute a select statement which the where-clause is variant. ex, select * from db1 where code='abc' select * from db1 where name='mike' As it's very difficult to change sql-command in oledb, i want to build a procedure like this, create procedure viewDB @filter CHAR(20) as select * from db1 where @filter go but failed! i tried EXEC( select ), ...Show All

• TO where to place articles

  I have a design that includes articles that will be searched. Obviously its too slow to put them into fields, and impossible because some have photos or are otherwise html documents. So I want to put pointers to their location. Two questions. For each deployment, both desktop and web, where is the best place to put the articles. In any folder, or only in an iis virtual folder dennist685 Glenn, thanks loads, bu ...Show All

• Krispi Synchronizing Very Large Database from PDA to SQL Server 2005.

  What is the best way to synch with a very large database (e.g. 40,000 products in Inventory Master) in connection oriented way and also offline mode for remote synchronizing the Data from PDA to SQL Server 2005. Kindly provide us some of the best practices on this concept. Thanks SQL Server 2005 Mobile Edition is the one that suites for your scenario. Especially look out for Merge Replication and RDA.  SQL Server 2005 Mobile Edition ...Show All

• Michelle Gutzait CLR trigger in another schema

  Hi, I'm trying to write a clr trigger. I have created Myschema schema under schemas folder and Table1 under this schema (i.e.: Myschema.Table1).  I created a clr trigger and tagged it with the Sqltrigger attribute as shown here: [ SqlTrigger (Name = "Trigger1" , Target = " Myschema.Table1 " , Event = "FOR INSERT" )]  When I try to deploy my assembly from VS 2005 I got the following error: Cannot f ...Show All

• WebAppsSupport Moving reports and their histories from SQL2000-RS to SQL2005-RS

  I have SQL 2000 Reporting Server with 30+ reports scheduled to be generated periodically and their snapshots are maintained in respective report history. Few weeks ago; we got SQL 2005 Reporting Server and we started using it for all the new work. Now we want to retire the old SQL 2000 RS machine but wants to copy the reports along with their histories on to the new server. Can someone guide or give pointers where I can find information on th ...Show All

• Rajen Suchede Executing a SSIS Package from an ASP.NET page.

  I am using the following code to try and execute a package from a asp.net page.  The server has both SQL, SSIS, IIS and ASP.NET on it.  The package runs fine from the SQL Management Studio.  The Execute result from the web page is 'Failure'.  My questions are: 1.  How do I catch errors to see exactly what is failing and why 2.  Is there a better way to execute a package using SSIS from asp.net Thanks, Nathan Su ...Show All

• grissett Couldn't connect to MSDE

  Hi all, I'm developing smart device application in VB.NET. I couldn't make the connection with MSDE. MSDE is on the same machine where i'm developing my apps. & testing the result with emulator. (NOt using RDA or Replication).Simply using ADO.NET commands to select a table from MSDE engine. Connection strings that i've tried: In a stand alone System: 1)strconnection = "Server = 10.0.0.7;" & "Data Source =HOME\MYINS,1029 ...Show All

• Erhan Tamer SQL and Record Count and Web service

  I have a web form with radiobutton list and checkbox list criterias which calls a Web service to generate SQL's SELECT statement.  Then I use the "ExecuteScalar()" method to try and pass the one string value back to the web form that called the web service.   1)  How do I concatenate the checkbox list into the SELECT statement, ie., "SELECT * FROM Customers WHERE <radiobutton value> = 'A' + <checkbox value> = '1' ...Show All

• JussiA Order by clause in View doesn't order.

  I have created view by jaoining two table and have order by clause. The sql generated is as follows SELECT TOP (100) PERCENT dbo.UWYearDetail.*, dbo.UWYearGroup.* FROM dbo.UWYearDetail INNER JOIN dbo.UWYearGroup ON dbo.UWYearDetail.UWYearGroupId = dbo.UWYearGroup.UWYearGroupId ORDER BY dbo.UWYearDetail.PlanVersionId, dbo.UWYearGroup.UWFinancialPlanSegmentId, dbo.UWYearGroup.UWYear, dbo.UWYearGroup.MandDFlag, dbo ...Show All