Pra_na_b's Q&A profile

• SQL Server Full-text catalog '' has been lost

  Hi there, A while back I moved my sharepoint services content database from one Windows 2003 server to another. (SQL server 2000.) the move went fine, except the full-text catalog was lost as part of the move. As part of my investigation i figured I'd remove the catalog entry from sysfulltextcatalogs. Now, whenever I try and create a new catalog i get the error message "full text catalog '' has been lost. use sp_fulltext_catalog to rebuild and repopulate this fulltext catalog." I've tried sp_fulltext_catalog, but that won't run as there's no real catalog name; in any case it complains that the database isn't enabled for full text catalog. - sp_fulltext_catalog '','drop' Full-Text Search is not enabled for the cu ...Show All

• Visual Studio Express Editions Tell Us Your Express Story and Win $100!

  Want a chance to show off a cool way you’re using Visual Studio Express or SQL Server Express We’re looking for your stories! Tell us about something that makes your life easier or is just plain fun and if we like it enough to include in a feature article, we’ll give you a $100 gift certificate to Amazon.com! This includes Visual C++ Express. http://msdn.microsoft.com/vstudio/express/support/hero_promotion/default.aspx enable vc++ express to compile: samples, and win32 applications. vip info first: in vc++ express console (IDE)>tools>options>expand: projects and solutions>vc++ directories three correct paths: $(ProgramFiles)\Microsoft Platform SDK for Windows Server 2003 R2\Lib ...Show All

• Smart Device Development Windows Mobile 5.0 USB driver development

  For my master thesis, I need to develop software that controls a medical implant over a USB link. This USB link requires 1 control transfer (the standard one required by the USB standard) and bulk transfer. In order to do this I need to develop a USB driver to communicate with the implant. Up until now my experience developing for windows mobile: NUL, my experience for developing drivers: NUL. Ofcourse I've already done alot of reading, and on the msdn website I only find some information about developing a USB driver, and there it states I need the platform builder.. which is not free. After what I read about the platform builder, it just configures a whole new windows Mobile, but that's not really needed is it I have a certain PD ...Show All

• SQL Server Can you unpivot on multiple keys with the unpivot transform

  Hi all, I have more than 1 set of columns I'm trying to normalize, can an unpivot transform handle 2 unpivots around DIFFERENT keys in the same transform If not, would the suggestion be unpivot into temp tables for whatever needs normalizing, than run an update query to generate the row that is desired Thanks in advance. Mark Mark Frank wrote: Hi all, I have more than 1 set of columns I'm trying to normalize, can an unpivot transform handle 2 unpivots around DIFFERENT keys in the same transform If not, would the suggestion be unpivot into temp tables for whatever needs normalizing, than run an update query to generate the row that is desired Thanks in advance. Mark ...Show All

• SQL Server sql connection

  I set up a user called "user1" on sqlexpress" I ran an app I wrote that connects to sqlexpress. From one machine I enter...("computername\sqlexpress"). I then enter user1 and password and the connection connections works fine to the server hosting sqlexpress, but on another machine, when I try to login the same whay I get an error "Login failed for user 'computername\Guest'". I can't understand why this is happening. I never set anything up as "Guest". I entered 'computername\sqlexpress' not computername\Guest". Any ideas out there as to what may going on. thanks I have the sqlexpress set as Mixed Mode and the connection string i'm using is ...Show All

• Windows Live Developer Forums Image Overlays

  I working on a project and want to overlay an image on my VE map. Ideally I'd like to just insert the image onto the map as a layer, and implement a callback or event to re-render the image when the map changes, however this doesn't seem to be supported like it is in Google maps. My image is generated at runtime based on the size in pixels of the entire map window, so I cannot statically create a set of perfectly sized tiles. When I tried the tile solution example as shown in the Interactive as "Use custom tile layers", my image was tiled across the entire screen many times (because I had just pointed the TileSource to my Image generator URL without the use of any of the given parameters such as %4. I didn't even see doc ...Show All

• Visual Studio Team System Pre & Post Deployment Scripts in CLR (Database) Project

  Is there a way to include Pre & Post deployment scripts into CLR Project The reason why I am looking for this is that when deploying CLR assembly/methods (more precisely upgrading), VS2005 can't delete/recreate database objects which depend on these CLR functions. Thus I need to delete them manually first and then create after deployment is finished anew... Is there a workaround for this problem No SQL Server does not allow that. -GertD ...Show All

• Visual Basic My file read function will not work???

  It will return The file could not be read: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: startIndex Function read( ByVal file As String ) Dim i As Integer = 0 Try ' Create an instance of StreamReader to read from a file. Using sr As StreamReader = New StreamReader(file) Dim line As String ' Read and display the lines from the file until the end ' of the file is reached. Do i = i + 1 line = sr.ReadLine() password.Text.Insert(i, line) Console.WriteLine(line) Loop Until line Is Nothing sr.Close() End Using Catch E As Exception ' Let the user know what went wrong. Console.Wri ...Show All

• Visual FoxPro Cetin Basoz - The Universal Thread Personality of the Year 2006

  Cetin Basoz has been selected has The Universal Thread Personality of the Year 2006 for Visual FoxPro & .NET VFP (2004,2005,2006) & .NET (2005,2006) http://www.universalthread.com/Personality.asp Congratulations Dr. Cetin Basoz (He is a licensed Medical Doctor) ...Show All

• SQL Server How to avoid cursors and loops

  hi, My problem is basically i need to call a stored proc for each entry in a table, i.e, basically a for loop calling stored procs with parameter coming from the table. I know two ways of doing this .. using cursor and using while loop with temp table. I dont like both approaches. Is there any good practice for this situation.. declare mycur cursor fast_forward for select ID from sometable open mycur FETCH NEXT FROM mycur INTO @AID WHILE @@FETCH_STATUS = 0 begin exec dbo.storedproc @AID FETCH NEXT FROM mycur INTO @AID end CLOSE mycur DEALLOCATE mycur You are seeing it how I have also experienced it -- you can't call stored procedures from functions. You can call e ...Show All

• Visual Studio Team System Unable to get the latest from Team Foundation Server

  Hi, I have a team foundation server to which I added some code (Web projects, sln etc). Now when I try to go to File->Open from Source control and select a particular project some of the .cs files are not downloaded to my workspace. (Note: Workspace is already setup) I get a warning -"Unable to get because a directory already exists". and my project is not complete without those. I have to do a manual "Force Get Latest" to get those missing files. Any ideas what could I be doing wrong Thanks Ashish SP1 did not work for me either, but ... I've added my domain account to TFS Admins group and ... problem solved :( ... Also note that I could not access project po ...Show All

• Windows Forms DataGridView Vs ListView

  I'm writing a WinForms app which need to display a list of data in columns and rows format. The data are sourced from TCP/IP messages (i.e. not from a SQL database). Could I still use DataGridView for presentation If so, how do I convert data into DataSet, which is used by DataGridView If not, am I forced to use ListView for presentation One thing you try is creating a DataTable and binding it to the DataGridView You can bind a DataTable to the DataGridView like this DataGridView dgv = new DataGridView(); BindingSource bs = new BindingSource(); DataTable dt = GetDataTable() // Gets the DataTable bs.DataSource = dt; dgv.DataSource = bs; The function ...Show All

• SQL Server Trying to connect to SharePoint database

  I am having trouble connecting to the SharePoint database on my web server. Our company intranet is accessed by http://webservername/ and the SharePoint site is accessed by http://webservername:2020/ (I wanted to put it on a different port to not interfere with our old intranet). Anyway, I need to connect to the DOCS table on the content database, but I can't seem to connect with SQL Server 2005. When I connect to webservername I see our company database but I don't see anything that has to do with our SharePoint stuff. I've tried connecting to webservername, webservername:2020 and webservername\SharePoint and webservername:2020\SharePoint with no results. If this isn't the right MSDN forum for this I apologize, but any advice would ...Show All

• Visual Studio Team System Tfs 31001

  Hi when trying to connect to a running TFS i get the TF31001 http 404 error the server worked fine for month What's the full error you get back You may also have a version mismatch http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=255799&SiteID=1 Also try hitting the ServerStatus page as per Bill's instructions here http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=560390&SiteID=1 ...Show All

• SQL Server SQL Query

  Hello All, I am using SQL 2000. I have a table as following Table1 Entity name DayNo Percentage Weekday EntityRate 100 ABC 2 11.20 2 200 100 ABC 3 11.00 3 120 100 ABC 2 10.00 2 95 100 ABC 2 12.30 2 80 100 ABC 3 15.00 3 70 The Entity is looked up by DayNo(2 ,3 etc). 2 is for Monday….so on. The dayNo and Weekday will be identical data and may change for the same entity as shown in the tab ...Show All