Answer Questions

• CnoEvil How to create a assembly

  Hi, I have one ClassLibrary three member functions.I have the dll for this...Can some one please tell me how to create a Assembly in .NET. I need to create a simple private assembly with the dll that i have. Thanks I am guessing that this is for SQL Server. create assembly AssemblyName from '<path>\AssemblyName.dll' go --Then you can declare the objects within using syntax like: CREATE FUNCTION [dbo].[DeployName](@ParameterName [nvarchar](4000)) RETURNS [nvarchar](4000) WITH EXECUTE AS CALLER AS EXTERNAL NAME [AssemblyName].[RootNamespace.ClassName].[FunctionName] GO Or do you mean what you have to do to build the code to make the assembly ready for SQL Server Did you check out the CLR programmabi ...Show All

• mkfl END CONVERSATION WITH CLEANUP, Is this bad? Records pile up in queues without it.

  I have read from a variety of sources that using the "WITH CLEANUP" option on a "END CONVERSATION" statement is bad and unnecessary. (Question #1) Is this true My code does not work properly if I don't use the "WITH CLEANUP" option. My code leaves closed conversation records in the queues if I leave out the "WITH CLEANUP" option. The "END CONVERSATION" statement is executing properly and flagging the conversation record as closed but the records don't get deleted. All the messages are going back and forth properly too. My code is based on the HelloWorld ServiceBroker sample which does not use "WITH CLEANUP". When I run the sample scripts everything works great ...Show All

• William Wong Help with cube measures

  I'm relatively new to AS but have managed to get a data mart, dimensions and cubes up and running in AS 2005 (SP1). I'm having difficulty trying to do something seemingly easy with respect to measures. One of my dimensions is Accounts. I have about 7 additional dimensions including Time. I have 5 measures. One of these measures is heavily used most all of the time. I need to filter this measure by the Account dimension to include only measures >= <defined_number>. The other measures should reflect this change also, but I also need to analyze other dimensions with or without the Accounts dimension in the crosstab. I need this to be put in the aggregations, not a temporary dynamic calculation. Aside from doing this at the database l ...Show All

• mamo SQL Server Licences in Visual Studio developments

  - In my company we bought Visual Studio 2005 Standard Edition AND Sql Server 2005 Standard edition (includes 10 Cal licences to SQL Server 2005) - We'll develop a new (exe file) program that will use a SQL SERVER database to store information. - This new program will be available to 20 employees or our company. - They will write and read information in that SQL SERVER database but, through the exe application developed with Visual Basic .NET (Visual Studio 2005). - They will use all the same connection and the same login name to connect to database. - They will not have access to database tables directly. My question is: - We have 10 CAL Licences. Must we have as many CAL licences as users we have Thank in adve ...Show All

• Octopus384 XML transactions under snapshot isolation

  Hello MS SQL Server experts, I use XML data type facilities in my applications and concurrency control issues are very important for me. So I use Snapsot Isolation for transactions (long transactions) which are mostly read data, but updates are also possible. It was a suprise for me that I obtained a great number of aborts for such transactions (run under snapshot isolation) when an update is issued. I investigated that the conflict is detected on the level of the whole XML document. So how can I cope with this problem The second question concerns nested transactions. Let's suppose that I run my transaction under Snapshot isolation and inside the transaction I want to begin new nested transaction run under another Isolation Level (l ...Show All

• Todd A Herman Subreport prints on new page.

  Anyone figure out a workaround for this issue in RS 2000 I'm getting half blank pages on a report because the subreport is starting on a new page. ...Show All

• Vitaliy Kochubiy error for sending(saving) data to database

  Hi, I’m using VS2005 and I’m trying to link the C# windows form to MSSQL. I used BindingNavigator Control to read the data. After that I add sqlcommand and sqldataadapter to send the data to the database. My code is this sqlDataAdapter1.InsertCommand.CommandText = "INSERT INTO SUDENT (" + "S_ID, S_NAME, S_ADDRESS, S_PHONE" + ") VALUES ('" + S_IDComboBox.Text + "', '" + S_NAMETextBox.Text + "', '" + S_ADDRESSTextBox.Text + "', '" + S_PHONETextBox.Text + "')" ; sqlDataAdapter1.InsertCommand.ExecuteNonQuery(); It gave me this error “ NulleferenceException was Unhandled ”and “ O ...Show All

• cybertaz69 SQL Server Everywhere Edition gets a new name

  After a huge customer feedback, we are rebranding SQL Server Everywhere Edition to SQL Server Compact Edition. More about it @ http://blogs.msdn.com/stevelasker/archive/2006/10/31/sql-server-everywhere-gets-yet-another-name.aspx Thanks, Laxmi ... and when you open sql server tools it comes up as SQL Server Mobile .... ... perhaps SQL Server Lite :-) OMG, is it too hard to figure out that MS SQL Server Everywhere is different from Sybase SQL Anywhere Can we figure out some more name changes along the way so that all documentation is out of sync and two people who want to talk about the technology can have a contest to see which one knows the latest 'correct' name to use ...Show All

• Pat. Problem exporting data using Excel destination (wrong format)

  Hi there, I have designed a package that works perfectly well, exporting data to an excel file from an ole db source. The problem is that in the excel destination file, columns of data that originally were numbers, are formatted as text. It would be just annoying if it weren't because I use those figures in a pivot table that operates with them. Any idea on how to tell Excel that those columns are numbers Thx in advance I'm having the same problem using Excel 2003 in SSIS 2005 and wonder if you discovered the solution. I'd appreciate any tips you may have. Thanks. Dan What is the original data type in the OLE DB source of those columns If they are ...Show All

• TCSC Selecting columns for indexing.

  Hi All, Is there any specific way to determine the columns on which index should be created for an application May be a template which can be used for analysing the column usage and proposing indexes. I know there wont have any Generic tool for this purpose. Some tools or templates to ease the analysis would help. Thanks, DBAnalyst In any version of SQL server you can use PROFILER to see the query load and process and capture the results to a trace file and then if you are using SQL 2005 you can use Database Tuning Advisor or if its SQL 2000 then Index Tuning Wizard to suggest relevant indexes on the tables. http://www.sql-server-performance.com/nb_index_intersection.asp http:/ ...Show All

• akaRickShaw Multiple SQL Server Native Client Versions

  One of the big problems with the old MDAC was different versions on different client machines. You would test your app with the latest version say, but when you deployed it, it might fail as the client has a different version. My company develops software for Municipal Government clients. These clients use other SQL Server applications as well as ours, but they can only use one version of the client software (MDAC) on a given desktop. That means if we require a particular MDAC version, but the clients other applications from other vendors don't officially support that MDAC version, the client is in a real jam. Our software also supports Oracle, which allows our software to specify a particular Oracle Home which points to a directory ...Show All

• StealthyC Using Sum with a SubQuery to Sum each Distinct Value

  I'm having some trouble getting the results I need. I am trying to Sum a Value based upon the result set of a subquery. What I'm getting is a Sum for all of the rows. For Example: Select Sum(OwnerName2.CELL_TABLE.HOURS) FROM OwnerName2.CELL_TABLE WHERE EXISTS (SELECT DISTINCT OwnerName2.LINE_TABLE.YEAR, OwnerName2.LINE_TABLE.PERIOD, OwnerName2.LINE_TABLE.CHARGE, OwnerName2.CELL_TABLE.HOURS FROM OwnerName2.LINE_TABLE, OwnerName2.CELL_TABLE, dbo.temp_table WHERE OwnerName2.LINE_TABLE.EMPL_ID = OwnerName2.CELL_TABLE.EMPL_ID AND OwnerName2.LINE_TABLE.SCHEDULE = OwnerName2.CELL_TABLE.SCHEDULE AND OwnerName2.LINE_TABLE.YEAR = OwnerName2.CELL_TABLE.YEAR AND OwnerName2.LINE_TABLE.PERIOD = OwnerName2.CELL_TABLE.PERIOD AND O ...Show All

• Stephen Crabb Registry to store configuration values ?

  I try to store a SSIS-configuration value in the registry. But it's failed. I get a warning, that the registry-key is not found. What is the syntax I have searched in BO,MSDN and  Google/Internet ==> nothing. There is no example.     Nah, don't think so.  I couldn't find it anywhere... It sounds to me as though you have done everything that you need to do. What error are you getting when you try and usee it   -Jamie   Hey Jamie, there is no example: Configuration Type Option = Registry Entry Specify configuration settings directly Use to specify settings directly. Value  Description  Registry entry  Ty ...Show All

• Deus23 for loop expression

  I'm trying to run a data flow task inside of a for loop container. First I was attempting to set the forloop expressions using variables that I was setting by running execute sql tasks. I ran into so many problems there, I decide to try this an easier way. So I've created 3 variables, all Int32. One is called counter, one is called inc, and one is called max. The values are set to: counter=1, inc=2, max=100. I then need to set the Expressions for the for loop. SO I open the properties window, and click on Expressions on the left hand side. I've set the following: AssignExpression : @counter = @counter + @inc EvalExpression : @counter < @max InitExpression : @counter = 1 To prove to myself that the counter variable was not incrementin ...Show All

• St&amp;#233;phane Beauchemin Get 'DB Error 10083' with SQL Server 2000

  Setup: SQL Server 2000 sp3 on a Windows 2000 machine, transactions running through an ODBC connection running SQLSRV32.dll version 2000.86.1830.00 Transactions: Being generated via a Citrix server (MetaFrame Presentation Server, Enterprise Edition 4.0(Build 2198), Service Pack 2005.04.... This sits on top of an install of Windows 2003 terminal server installaion. Error: Appears to only be happening on a ADD(Insert) .... Any thoughts on this would be a big help. Dave This's profiler from another computer with same form. Begin Transaction go sp_tables @table_name = 'emside' go sp_special_columns @table_name = 'emside' go select emside.SideID FROM emside where 0 = 1 go select timestamp from e ...Show All