Answer Questions

• suresh from sryas software Limit in connections

  is there a limit in concurrent connection to SQL Server Express Edition thanks ~Walther No. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx http://www.aspfaq.com/sql2005/show.asp id=8 wrote in message news:bd308738-350c-4cd0-a99e-0e8690010eb3@discussions.microsoft.com... > is there a limit in concurrent connection to SQL Server Express Edition > > thanks > > ~Walther > ...Show All

• jkristia Information/ErrorCode from FireInformation/Error

  Hi, Very low priority this one... Is there a "free" number range that we should use for the InformationCode/ErrorCode parameter to the FireInformation/FireError methods Currently I just use 1 and -1 respectively. On a similar note...I remember someone from MS (might have been Matt) once saying that a list of all the rror codes would be published at some point. Is this still the plan and if so, where will it be Thanks Jamie It's my unders ...Show All

• Don Vilen Update statement

  Hi All I am having sometrouble with a update statement. The table is about 60 columns, apart from the first one all are NULL. insert into customer (id,sitename) values (newid(),'TEST') The error message I am getting is: Server: Msg 8152, Level 16, State 6, Line 1 String or binary data would be truncated. The statement has been terminated. The column I am inserting into is nvarchar (50) so I am a bit stuck as I dont understand t ...Show All

• RWendi "No Such Interface Supported" Exception 0x80004002 - HELP!

  AAAAARRRRRRRRRRRGGGGGGGGG! I finally figure out why I can't connect to the SQLEXPRESS on this computer (technically, I was a remote connection), get everything installed (Advanced edition), and then... It keeps telling me that "No Such Interface is Supported" and "Unable to cast COM object of type "System._ComObject" to Interface type..." I grabbed it in a screen capture and will try to get it to a server t ...Show All

• Wang chia yu From DataSet To SqlDataReader in a CLR Stored Procedure

  Hi all, I'm writing a CLR stored procedure that just execute a query using 2 parameters. SqlContext.Pipe.Send can send a SqlDataReader, but if I've got a DataSet How can I obtain a SqlDataReader from a DataSet Dim command As New SqlCommand(.......) ..... Dim ds As New DataSet() Dim adapter As New SqlDataAdapter(command) adapter.Fill(ds, "MyTable") ... 'manipulating the ds.Tables("MyTable") At this moment I have to s ...Show All

• CLR-GURU Trigger question

  I would like to know how many records there are in the INSERTED & DELETED tables at once when a trigger fires. I'm looking at a trigger that checks for COUNT(*) in both tables (INSERTED & DELETED) and will perform a different T-SQL statements base on COUNT(*) being 1 or greater than 1. I always thought that triggers fired for every record in a INSERT, UPDATE, DELETE transaction. If so, there should not be more than one record in neith ...Show All

• mynolix Securing the MS SQL Server 2005 database on client side

  Hello! I developed database driven .NET application and I need to deploy it. I faced a problem, which is "how to protect my database against direct access". I use MS SQL Server 2005 Express Edition as a DBMS and appropriate database. I want to make possible to manipulate with data in my database only through my client application. 1. How do I define SA password and instance name in silent mode of MS SQL 2005 EE installation with M ...Show All

• AjayShrivastava SP_help_revlogin

  Dear Folks, I am in the process of migrating side-by-side from 7 to 2005 and I am wondering if the same sp_help_revlogin will work from 7 to 2005. I want to keep the same pwd, sid etc or do I need to use SSIS (Integration Services). Thanks Hmm... I can't find any information on sp_help_revlogin (or sp_helprevlogin) in either 7.0 printed documentation or 2005 online. Is that really a Microsoft stored ...Show All

• Matholroyd TransactionOption Property Not Working - Feedback Needed

  I have a package which consists of 3 Execute SQL Tasks - 1) Drop old database & Restore a new one 2) Run DDL 3) Run DML My task was to put all of these in a transaction. I started using the "TransactionOption" property for this package to be "Required" and each child tasks also were set to the same transaction option property of "Required". However, after running the package, it errored out saying Task ...Show All

• dkfitzgerald-HST Why is sort so slow?

  I set up a sample sort data flow that is attempting to sort 11M records totalling about 3GB. It ran for four hours and then I killed it. How can it be so terrible Am I missing some hidden tuning parameter I rather expected it to use the disk for temporary storage rather than try to sort it in memory. And what columns are in the sort key What is the type of those columns -Jamie isn't 3 GB of data beyond the capacity o ...Show All

• faB_mx OPEN XML

  I have to insert one table by using the concept OPENXML But i want to insert a table lot of fields i require, in the open XML few fields fields are there , so i want to selet some fields from other table can u guide me for this scenario to INSERT some fields from one table and some in OPENXML as a single insert statement Awaiting for Reply PLease Thanx Consider using the openXml to create a te ...Show All

• lori1171963 Miscellaneous option???

  Does anyone knows what is it for Miscellaneous option on Package Explorer It seems totally useless I've used it to distribute raw files in very rare circumstances where that is required (usually DelayValidation means yu don't have to do this but sometimes not). There are probably many other types of files that you may want to distribute. -Jamie Thanks a lot to both for the info provided. Sorry, it was Solution ...Show All

• Binnerup sql-express install fails

  the latest sql-e install fails on one pc for me. It looks like some previous sql-e beta components are still installed. I'm not sure what the correct procedure is for removing them. I tried using msiexec /x but i get an error for each of the 3 components. I'm pasting the error log below. If someone could tell me the correct way to remove them i'd appreciate it, thanks. Microsoft SQL Server 2005 CTP Setup beginning at Thu Sep 29 21:00:51 2005 Pro ...Show All

• happy we tod MDX Query Tool

  I have been searching and looking for days for a tool that will allow you to build mdx queries in a GUID (Alot like the browser) and then view the actualy mdx query. I tried to profile the AS 2005 database while using the browser but it profiles some strange stuff.. SELECT NON EMPTY [{51E097E0-68D7-48E7-9847-B7D931EA6E0B}Pivot70Axis0Set1] DIMENSION PROPERTIES MEMBER_NAME, PARENT_UNIQUE_NAME ON COLUMNS, NON EMPTY [{51E097E0-68D7-48E7-9847-B ...Show All

• Jason Rieger Disk Quorum Full

  Dear All, I've the quorum disk of my cluster on win2003 full and I cannot use The cluster administrator because the Service Cluster cannot going up. Obviously the shared disk (included Quorum) and MSDTC are not visible and I'm wondering if is possible to solve the problem without rebuild the cluster. Thank you to everybody Information thanks to Elden Christensen: You need to start ...Show All