sheidee21's Q&A profile

• SQL Server upgrade from 2000 MSDE to 2005 Express - Enable TCP/IP by default & Current Version of SQL running?

  i am working on upgrading the clients and server computers from 2000 MSDE to 2005 SQL Express Adv. Plan to upgrade using the template.ini. i can find the version of sql server running on th server by @@version but how do i find the version of client connctivity components the computer has installed in order to ugrade 1. somehow i need to know whether to upgrade a client computer CONNECTIVITY COMPONENTS from 2000 to 2005 2. is there a way to enable tcp/ip in installation script of SQL Express THANKS Thanks for your reply Once I upgrade the Server computer, do I need to upgrade the Client computers with the connectivity components If yes, how do I do it ...Show All

• .NET Development HOT FIX K921883

  Hi All,   After implementing the HOT FIX K921883 released by microsoft , My application start giving error while executing DML statement on SQL server 2000. The underlying framework used is .NET 1.0. The hot fixed target .NET 2.0 framework.   Please help me to sort resolved this problem.   Thanks, Thx for ur reponse.... but i can't remove the hotfix....company is asking me to make the application compliant to this hotfix..as other applicationa r running fine ...Show All

• Visual Studio 2008 (Pre-release) Listener won't accept new channel after first one is finished

  Hey, I posted regarding my custom transport, and the including of security the other day. I solved that problem but it seems like the adding of security caused some more trouble. This is on the server side, where a ServiceHost is used. Without security this was what usually happened (using reliable messaging though): In the Listener, OnBeginAcceptChannel() is called, and an async setup of communication is done. When ready OnEndAccept() is called, and a ReplyChannel is returned. On this channel ReceiveRequest() is called and a RequestContext is returned. Using the RequestContext.Reply() a reply is sent. Back to (1), where a new channel is created for the next message... Now, with security, BeginReceiveRequest ...Show All

• SQL Server Partitioning Strategery

  Hi all, I've got several large fact tables that I want to partition by time. What's the best way to strategy to manage this I have a C# app that uses AMO to manage the re-processing currently, but right now I'm fairly naive and just re-process every measure group. What I'd like is a way to automatically partition by month / day [depending on measure group], and then enhance my re-process app to only process the latest partition. My current idea is to establish a naming structure for the existing MGs/partitions, [i.e. "Foo 12-2006"], parse the date, adjust the named query, create a new partition if needed, and re-process if appropriate. Though it's quite doable, it seems a bit complex for something that should be a more ...Show All

• Visual Studio Team System Location to post small TFS Build gig?

  Hi, I am not sure of the best location to post this. Please advise for the future, or move it to the correct forum. My company is looking for someone to setup an automated build using TFS Build to build/deploy a smart client application to both a staging and production server. The TFS server is already installed and the smart client application is finished and is currently being built from a developers local machine. Remote work is possible for the project. Thanks, Christian Hi Christian We might be able to help you out. Plesae email your contact details to tfs@3vium.com , and we will contact you for additional information. Matan Holtzer ...Show All

• SQL Server Sql Server Mobile error 25123 - missing dll

  Hi, in my app I connect to and read from a Sql Mobile database numerous times. Eventually and inconsistently my app will no longer be able to access the database and a SqlCeException is returned with native error 25123. This error translates to: "A SQL Mobile DLL could not be loaded. Reinstall SQL Mobile. [ DLL Name = sqlceqp30.dll ]". I've seen similar (and unsolved) problems involving RDA/replication, but I am not using any of that in my program. It simply connects to database, queries and retrieves data, then closes the connection. I am properly disposing of all SqlCE objects. I'm not sure what the error really means. Once the program gets this error it is never able to access the database again until the program is restarted ...Show All

• SQL Server Copying database using "Copy Database"

  I am struggling with the "Copy Database Wizard" in SQL Server 2005. I am used to working with DTS to copy data from one server to another, but with the new tools, I am having serious problems (in fact, it's unusable) 1. When copying a database using the "SQL Management Object" method, I always get errors concerning logins. If I select not to copy logins, I get errors "sp_grantdbaccess failed". If I do select to copy logins, the logins can't be created because the machine names are different (one the source machine, the login is called MACHINE1/mylogin, but on the destination machine, such a login cannot be created) 2. For small databases, I ALWAYS get the error "CREATE DATABASE failed. Primary file must be at least 3 MB to accommodat ...Show All

• Visual Studio 2008 (Pre-release) VS 2005 Extensions for .NET 3.0 RC1

  When can we expect to see this I think its a little upsetting that we've had now the July CTP and now the RC1 and not a single re-release of the VS 2005 extensions. Not all of my machines still have the extensions from the June CTP on them and quite frankly the act of removing everything I've got, re-installing the June CTP, adding the June CTP extensions, removing the June CTP, and then installing the newest bits is a real pain and often destabilizes the test machine. So, when will we be able to download the VS 2005 extensions for .NET 3.0 RC1 See this thread for your answer ...Show All

• .NET Development How to: register a .Net assembly by remote

  Hi guys, Could someone please suggest the best way to register a .Net assembly (using Regsvcs.exe) from remote That is I want to call the regsvcs on a machine from another machine. Tanks in advance! Thanks Sean, Remote Desktop and VPN are not a good solution for me, for I need to trigger the registration automatically. Could you (or someone else) please tell me something more about login script Thanks a lot! ...Show All

• SQL Server metadata services for analysis services

  Hi, I was wondering if anyone can tell me what options do I have to browse metadata for a cube built on Analysis services 2005. We would not like to buy a new thrid aprty tool for this. Does sql server 2005/ analysis services 2005 have a inbuilt option to view the metadata Thanks in advance. thank you so much for the information. But i dont see any place at microsoft where I download the amoBrowser. Can you point me where I can find the amoBrowser and its installation files thanks again. ...Show All

• Windows Live Developer Forums SubmitOrderForApproval

  What if something doesn't pass editorial process How can i get that error Also does this happen in realtime or is this a human process Some of the editorial verification processes are automated, some depend on human review. It doesn't happen in real time, so you will have to call GetKeywordAdAssociationByXXXX and for every association that you get back, query its Status field: Approved, Pending or Rejected. Thanks, Shai ...Show All

• SQL Server cpu quota / resource management

  Hello *, Is there a way to restrict resource consumption by user or connection If I execute some long running reports my complete server slowes down. I'd like to assign this reports only limited resources. Thanks, Michael You can configure database mirroring for the target database in your production SQL instance and create snapshot on the mirror server (your backup SQL instnace) on different machine. The principle system can be considered as your normal OLTP business system and the mirror server can be used to support your reporting system. Since the reporting system will be run on differet SQL Server instance on different machine, it will not hurt your normal business onthe principle server. ...Show All

• Smart Device Development Progress bar for Remote Data Access Push Pulls.

  Hi all, i'm trying to make a progress bar for the push pull's progress. is there anyway to do it So far i only know how to use timer to make the progress bar move.. but i don't know how to make the progress bar move with push or pull. Anyone know hi , you mean it'll be like 5 pulls = Max = 5 so 1 pull = +1 Value hmm i was more thinking of realtime thing like as each pull goes the bar increases. But this might work well :) ...Show All

• Windows Search Technologies WDS 3.0 Beta 2- Rebuilding index by itself and more

  Hey Guys, Brandon pointed this as the right place to post some concerns/issues with the WDS 3.0 beta 2 Few issues with WDS 3.0 beta 2: - When adding a new file extension to be indexed, WDS prompts to full rebuild of the index. This is a very bad behaviour especially, like me that has more than 100,000 indexable items. (anyway to avoid that ) - The WDS is rebuilding the index itself without any user intervention - The current pdf I-filter are not capable to index within the pfd files. - The configuration GUI interface still very rough, clearly need some refining. That's it for now. Thanks, Marcus   If you click cancel when you get that prompt for a rebuild after modifying a file extension, the file ...Show All

• .NET Development Need Help On HttpWebRequest

    I am using below code to test HttpWebRequest. If you put this URL and use given userid and password its taking me to the invalid user screen. This site is a third party site and I don't have any other info. Below is my code =============My Code-----===================== ========== HttpWebRequest webRequest = (HttpWebRequest)WebRequest .Create(" https:// website"); string postData = "txtLogin=ABC"; postData += "&txtPassword=def"; postData += "&__VIEWSTATE=dDwtNzE3NDAxOTg4O ztsPGJ0bmxvZzs+PvynWXke2BHF7+n +YmeE08t7FGuU"; postData += "&btnlog="; webRequest.CookieContainer = new CookieContainer(); webRequest.Method = "POST"; webRequest.ContentType = "application/x-www-form -urlencode ...Show All