S Hussain's Q&A profile

• SQL Server SQLCLR 32-bit Vs 64-bit

  Is anyone here aware of any explicit/definite differences between running sqlclr on 32-bit and 64-bit. Note: These must be documented, well defined differences. If you're looking for documented differences, perhaps you should check the documentation   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     <Derek Comingore - RSC@discussions.microsoft.com > wrote in message news:51202de3-4fee-4bee-9af1-1e73ad447093@discussions.microsoft.com ... Is anyone here aware of any explicit/definite differences between running sqlclr on 32-bit and 64-bit. Note: These must be doc ...Show All

• SQL Server Duplicate columns in a select clause plus order by statment

  Hi All, I am working on a Java project that uses SQL server. The database is accessed through a ORM tool, so I do not have direct access to the generated SQL. My problem is that on SQL Server 2000 the following clause worked : SELECT stock_item_code, supplier_cost_number, amended_by, amended_date, lead_time, pack_cost_currency, pack_size, stock_item_code, supplier_number, supplier_reference FROM supplier_cost WHERE stock_item_code = 1000010001 and supplier_number = 1 ORDER BY stock_item_code, supplier_cost_number However on SQL Server 2005 I get the following error: Msg 209, Level 16, State 1, Line 1 Ambiguous column name 'stock_item_code'. Is this a bug in SQL Server 2005, or is this the way ...Show All

• Visual Basic Software Publish Question

  Alright, I have a program that I'm working on and i have noticed that whenever I run the Publish in the Programs Properties, that it makes a .exe . Now whenever I run the .exe , I noticed that it puts it under Start - All Programs but I don't see it anywhere in the C:\Program Files\ . Why is that Also, I have a .mdf in the application. Will it create the .mdf upon install for me or do i have to encode that into the program ClickOnce is designed to be very light weight and non-intrusive to the machine. That's why it installs per user (don't need to be an admin to install). If you want to be more specific about where you install to then you're going to have to use MSI or an MSI like technology. Gi ...Show All

• SQL Server DBCC MemoryStatus dump and help 'Insufficient memory'

  Hey guys. Today morning at about 9:58am I had an insufficient memory exception in SQL. I've reserved 12gb memory for my SQL server. I've pasted below the dbcc MemoryStatus dump gotten from SQL log. It also gave me a BPool::Map: No remappable address found My SQL Server version is 8.00.2148. Enterprise Ed. Can you see any problems in the below pasted log 2006-08-09 09:58:11.63 spid175 BPool::Map: no remappable address found. 2006-08-09 09:58:11.69 spid101 Buffer Distribution: Stolen=156843 Free=1634 Procedures=17623 Inram=0 Dirty=108669 Kept=0 I/O=0, Latched=1220, Other=1286875 2006-08-09 09:58:11.69 spid101 Buffer Counts: Commited=1572864 Target=1572864 Hashed=1396751 InternalReservation=510 ExternalReservation=130 Min Free=15 ...Show All

• Software Development for Windows Vista How to handle instance state of old version workflow?

  Hi, every one. We are trying to use state workflow to handle our sales order process. We create a new instance of the workflow for each new order as the new order is created.  As order is approved/shipping/closed, workflow instance handle it’s state. This works perfect. But when user changes the workflow definition, the old instance cannot load! Firstly we consider about keeping all version of workflow class in one assembly  But this will lead the workflow definition assembly growing large forever. Because usually a sales order need several month to be processed and user need change the workflow frequently. So there will be a lots of old version instance stay in our database. ...Show All

• Visual Studio Express Editions Using Windows Platform SDK and VC++ Express to compile

  Hi, there I have a ISAPI filter project which can be compiled under VC++ 2005. I 'd like to try it with VC++ Express at home. But have following problems. 1. String.h comes with SDK seems have no those "_s" functions, like strcpy_s, strcat_s etc. It gives error when compiling, how can I use those functions 2. When the project links, there is an error saying couldn't find mfc80d.lib, I guess it does not come with VC++ Express. But SDK has mfc42d.dll. I am wondering which options or setting can let me use that instead Thanks for your help! Do not use the CRT/MFC files with the Platform SDK. They were an addon for Visual Studio .net 2003 to give it 64 bit compiler support. For the CR ...Show All

• SQL Server Merge Replication with SQL Mobile 2005

  We are using SQL 2005 (SP1) and mobile agents with SQL Mobile. We are seeing an excessive number of updates after a device's database is reinitialized. My understanding was that if I generate a new snapshot or reinitialize all subscriptions (from the server), the devices would only get what the database looks like right now (inserts only) after syncing and/or reinitializing, but they are actually getting the right number of inserts and a huge number of updates in Replication Monitor. Any ideas Thanks! Mike Thanks for the update. do you generate a new snapshot prior reinitializing the subscriptions if the snapshot is old one and the subscription was reinitizlied. it will apply the snapshot and ...Show All

• Visual Studio Express Editions How do I put an inputbox inside of a messagebox?

  Hey, 1st time poster on here and I was curious if you could help a newbie out here. I'm trying to work on a project and part of it involves clicking a button to bring up a message box, and then within that message box there needs to be an input box where a number needs to be inputed 4 times. Currently I have the code for the message box setup: MessageBox.Show("Please enter your project grade:", "Enter Project Grades", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) And what I want to know is where should I input the InputBox code and loop code Thanks in advance! That's perfect! So then, once both boxes have run their course and it's time to display the total value of all the numb ...Show All

• SQL Server Getting List of Databases From Server

  Is there a way I can query the database server (SQL 2000) to get a list of all the available databases As a threshold problem I am not clear how I would connect to the server. I am using VB.Net and presently connect to one database at a time. The connection string is in an XML file, such as: < xml version="1.0" encoding="utf-8" > <Connection>workstation id=ASUS;packet size=4096;user id=sa;data source="5.15.183.222\KWMSDE2"; persist security info=True;initial catalog=tsLocal;password=pass </Connection> Is there some special way that you connect to the server without specifying the database Is there a certain query I must use once I am connected Can the information be return ...Show All

• Software Development for Windows Vista Interacting with different users based on roles

  Hello, I've designed a document validation workflow but still with no roles on it, so anyone can introduce a document and anyone can validate it. I've been searching info about roles and what I've seen is that you can say which roles can or cannot do an activity. But my application is a bit different: There are 4 different roles (ranks of the employees). Role 5 (the less "important") can post a document, that same user can modify it as many times as he wants and then send it to validate, and it has to be shown in the list of pending documents of role 4. But role 4 can as well post a document that has to be validated by role 3, and role 3 need validation from role 2 etc. I suppose there has to be a way of designing a sing ...Show All

• SQL Server SSIS Database Login

  Is there a reason why SQL 2005 SSIS always allows selects windows authentication instead of getting the login details from the current connection like SQL 2000 eXcalibur.lk wrote: Is there a reason why SQL 2005 SSIS always allows selects windows authentication instead of getting the login details from the current connection like SQL 2000 I guess the thinking is that you won't be running your packages in a produciton environment under the developer's UserID. I think that's a pretty safe assumption to make. Is it a problem -Jamie ...Show All

• SQL Server Insert/Update sql commands not saving to DB

  Here is my problem : I issue an insert statement to the db. While I am getting a return value of 1 (1 row was affected) the values never show up into the db when I open the DB in access. However, I can see the data when it does an SQL select inside the program. So for instance, I do an insert into ORDER values (1, 12, 5.99). (1 = item ID, 12 = quantity, 5.99 = price). I then do a select * from Order, and I get those values back. When I open the DB in access, in between doing the insert and the select, I dont see the values there either. It is like it is making a temporary copy of the DB in memory during the execution only. When I close the program and re-F5, the data is no longer there. Maybe we need some kind of commit transa ...Show All

• Visual C# Font size in debug windows

  Is there any way to change the font size in the various debug windows (call stack, locals, etc.) Even increasing the font size in the Appearance tab of the Display Properties had no effect. Thanks, Gregg You should be able to change that by opening the Tools/Options dialog, selecting "Fonts and Colors", and selecting the window you want to change from the "Show settings for" dropdown. -Josh Stevens VS Core IDE team ...Show All

• SQL Server Questions about memory based bulk copy operation(InsertRow count,array insert directly,set memory based bulk copy option)

  Hi~, I have 3 questions about memory based bulk copy. 1. What is the limitation count of IRowsetFastLoad::InsertRow() method before IRowsetFastLoad::Commit(true) For example, how much insert row at below sample (the max value of nCount ) for(i=0 ; i< nCount ; i++) { pIFastLoad->InsertRow(hAccessor, (void*)(&BulkData )); } 2. In above code sample, isn't there method of inserting prepared array at once directly(BulkData array, not for loop) 3. In OLE DB memory based bulk copy, what is the equivalent of below's T-SQL bulk copy option BULK INSERT database_name.schema_name.table_name FROM 'data_file' WITH (ROWS_PER_BATCH = rows_per_batch, TABLOCK); ------------------------------------------------------- My solution is lik ...Show All

• Visual Basic How to set a control's visible property.

  I have a form that has a combo box with 7 items and also has 7 group boxes. Basically, I would like the user to click an item in the combo box and have the corresponding group box appear. If the user clicks a different item in the combo box, then I want the visible groupbox to become invisible, and the new corresponding groupbox to become visible. Could someone help me out with the code Sorry guys, this has been covered in another thread. Yes, the Groupboxes do get put inside one another so you need to keep them separate in the designer and set the location programatically. This works fine but is a real pain when you're designing a busy screen! Rich ...Show All