Answer Questions

• donss SMO to Modify Server Protocol

  Hello, I am trying to Enable TCP/IP server protocol on SQL 2005. Under SMO I see Microsoft.SqlServer.Management.Smo.Wmi.ServerProtocol But I am not sure how to get to that information. Anyone have any ideas on how to do this Thanks in advanced This is because you've change only local protocol object state, not actual service protocol setting. To do this, you should call Alter method of ServerProtocol class after prop ...Show All

• Nilesh Gambhava Sum of a Sum (expression)

  Product Category Product Sub Category Product Name Units Sold Bonus   Units Accessory     62051   Bike Racks   3166 2000     Hitch rack - 4 bike 3166     Bike Stand   249 249     All-purpose bike stand 249     Bottles & Cages   10552 2000   &nbs ...Show All

• khalil_yassine SQL Express Family CTP Now Available

  I’m happy to announce the release to public CTP of the following SQL Express Family products: SQL Server 2005 Express Editions SP1 SQL Server 2005 Express Edition with Advanced Services SQL Server 2005 Express Edition Toolkit SQL Server 2005 Management Studio Express (included as part of Express Advanced & Express Toolkit) You can download and install these CTPs from the CTP download page . Here is a brief description of each p ...Show All

• Ramraj Balasubramanian - MSFT Insert or Update null if the value is zero using Trigger on table

  Hi , I have 2 tables (Dept and Emp) The columns in table Dept are Deptno and Deptname. Deptno is bigint and it is primary key. In Emp table, columns are Empno(PK) ,EmpName and Deptno(foreign key referring to Dept) To Insert or Update record in Emp through application, value of Deptno is coming as 0(Zero). I want the value of Deptno to be inserted or updated as null if the value is Zero (0). How to do this in sql server 2005 by using t ...Show All

• frozenfreak How to extend existing FTP task ?

  Is it possible to extend existing tasks (specifically FTP task) Or I will have to develop one from scratch I want to extend the functionality of FTP task for ftp via a proxy server. Is it possible Any ideas Suggestions thanks, Nitesh You will have to implement your own, the FTP task is a sealed class. ...Show All

• MS Tobin Titus How to achieve rowid of Oracle in SQL Server?

  Any suggessions If you have a suitable single column primary key in a table then you can use it instead of rowid. Otherwise consider adding a column to the table with the IDENTITY property. This is from Books Online IDENTITY Indicates that the new column is an identity column. When a new row is added to the table, the Database Engine provides a unique, incremental value for the column. Identity columns are typically used with ...Show All

• mitr_ar Regular Expressions in SQL Server 2005

  Hi- Someone posted on a thread that you can use VB (or C#) to write Regular Expressions for SQL Server 2005. I know how to write RegEx in VB, so can someone point me to a reference which explains how to use them in / with SQL2005 Or, can someone explain how Thanks, -David Yes with CLR intergration in SQL Server 2005, you can write CLR Stored procedures in VB or C#. By referring to System.Text.Regula ...Show All

• Micror "Package failed validation from the ExecutePackage task" error

  I have an SSIS package which calls two other SSIS packages as part of it's control flow (using the Execute Package task). Both packages are stored in the same parent folder on the same server. The first child package runs successfully, the second does not. It ran fine for days until yesterday. Not sure what I might have done. I have tried to delay validation and recreate the connection. No go. Has anyone else run into this. I am running SQL 2005 ...Show All

• Shane Harris Report/query parameter default values

  I am using a SQL stored procedure for a report. The sproc has a variable in it (@itemnumber) to be supplied by the user at run time. In the report parameters within Visual Studio Designer, I am trying to set a default value for the parameter of % so that all items will be returned unless the user enters a specific item number. In the Visual Studio preview this works but once the report is deployed to the web server, the default value does NOT sh ...Show All

• Ranjesh how can i query the date one week back from now?

  for example today is May,2 2006: my query should return all data where date = April 24, 2006. Try this RDL expression for calculating the previous week: =Today.AddDays(-7) If you want to do this directly in the query, you will need to look for date related functions for the particular database you are working with. For SQL Server queries you would use the DateAdd function: http://msdn.microsoft.com/library/default.asp url=/library/en-u ...Show All

• scrptman How do I install SQL Enterprise Manager?

  Hi All, I'm pretty new to SQL anything... I'm wondering if there is a way to install just Enterprise Manager on my local workstation so I can open it up and manage or at least look at all of the SQL db's that are spread out on various servers - all in one place 1. How can I install just Enterprise Manager (if possible). I ran setup on SQL2000 Personal Addition and it didn't look like it was going to get to a 'custom setup' screen so I canc ...Show All

• DaveOnSEN Report error

  Hi all, I just setup SQL 2005 Report Service, and then I used the browser to view the "folder.aspx" Nothing showed up but I received an error page with the message like the following: "The request failed with HTTP status 400: Bad Request." So, what did I do wrong Thanks, Frank System Engineer Start debugging with your http://localhost/reportserver . How ...Show All

• Greg Brady Broker:Corrupted message

  Hello, Has anyone seen this in profiler I have two brokers on different servers with one of them being the initiator. All messages end up sitting in the initiator's transmission queue. Profiler on the target broker's machine displays this for every attempt to send by the initiator: A corrupt message has been received. The End of Conversation and Error flags may not be set in the first sequenced message. This occorred in the message with Co ...Show All

• Gavin RTE Size of Deployment

  We deliver proposal automation systems that that use the msde database for the Lan version. We are contemplating supplying this to a client that might have 250 users eventually, yet our database size is not likely to ever exceed 4GB. Is the express version a suitable database backend for delivering this MSDE has a build in speed limiter. Is that the case for SQL Server Express, or is it fully functional until you hit the 4GB limit ...Show All

• LFDIII FixedHeader JavaScript Bug?

  Hi I have a report with a table containing 26 columns, the tableheader is fixed when scrolling (nice) and I have set the leftmost column to FixedHeader. It is possible via paramters for the user to select which columns that should be visible. But when some columns not are visible then I get a script exception after rendering, 'children.0.style' is null or not an object, resulting in no fixed headers at all. If I remove som columns so that the ...Show All