spcboog's Q&A profile

• SQL Server Created database in Visual Studio 2005; How do I add it to SQL Server?

  I have created a database in Visual Studio 2005 by adding a new "SQL Database" item to my project, and then designing the tables with Server Explorer. How can I add this database to my local instance of SQL Server Express, and to my SQL Server 2000 database engine I do not know of any real best practices, But I do not stor e the Database files in Source Safe I use a seperate database project and only store the Data Definition Language for the database (SQL Scripts). I can then add the project to the solution and then to the VSS Project. I have had Problems in the past adding the MDF Files used by SQl Express in VSS so have chossen to follow the above procedures. Hope this helps ...Show All

• Visual FoxPro Tables Relation

  Dear reader, I hope you can help me. I dont know how to relate two dbf free tables files. Table Sub (submenus Items belongs to) ID OWNERID USERNUMBER SHORTNAME LONGNAME EXCEPTIONS ITEM01 ITEM02 ITEM03 ITEM04 1000 0 1000 Entradas Entradas 0 1001 1002 1003 1004 1100 0 1100 Ensaladas Ensaladas 0 1101 1102 1103 1104 1200 0 1200 Sopas Sopas 0 1201 1202 1203 0 1300 0 1300 Cremas Cremas 0 1301 1302 1303 0 1400 0 1400 Ex tico Ex tico 0 1401 1402 1403 1404 1500 0 1500 Aviant\nCuisine Aviant Cuis ...Show All

• SQL Server Architecture question

  I am a newbie to Notification service and I need your help to determine what's the best way to handle my situation. First of all, I need to determine if Notification service is the right approach. We have a ASP.NET application that creates purchase orders to various suppliers. Few suppliers are fine with just "Email notifications". But few of them need the PO XML sent to their FTP site. We might have future suppliers and they may want a different mode of communication. Here's my solution to this problem and I need your expert advice Step 1: Create an event schema that captures all the item details in a PO. Question: What is the best way to implement hierarchies [PO Header, PO Line item] I am thinking of adding all the ...Show All

• SQL Server Slicer and axes interaction in MDX Part 1 - coordinate overwrites

  A question regarding this Blog post by Mosha. I have tried the MDX examples with SP2 CTP 1 (November) and still get the wrong results. Is this fixed in a later release of SP2 Regards Thomas Ivarsson Thank you Mosha. I should be able to see this in CTP1 What version of the Adventure Works cube are you using(Standard or Enterprise) Have there been any changes in this cube since the RTM of SSAS2005 one year ago I will check again with a never version of Adventure Works. Regards Thomas Ivarsson ...Show All

• Smart Device Development Hiding the taskbar...?

  Hello, I want my program to run as a fullscreen program.I mean the user shouldn't be able to access the task bar.I have a sample to hide it,but it uses user32.dll but CF.NET complaint about this .dll. so what's the way to do this I want the user to only use my application.he/she mustn't be able to switch another application.I thought hiding the taskbar is the solution for this.is there another way Thanks in advance there's a bit more to it than that! e.g. you enable the SIP, from there you can change the SIP options, going in to this makes the start button visible, from here the user can do what they want! the method I use was to have a list of allowed windows (e.g. 'Phone') and then use a 2sec timer to check the ti ...Show All

• Software Development for Windows Vista MS Office with vista rc1

  I got windows vista rc1 (build 5600) that I downloaded freely from microsoft website.. now the question is: "What version of Office - and how can I get it - that works with this copy of windows " I downloaded Office Technical Refresh but it didn't work. It gave a message which didn't look like an error one, but after then nothing else happend, but anyway it didn't install the programs of office suite is there a beta release that is available in the present time and compatible I can't tell you how much I need to install the Office applications.. please help yea, that's it, apparently.. things never been so clear, why didn't they just make it a bit more clear TR is an update and not an inde ...Show All

• .NET Development .Net DB2 provider

  hi folks i am facing a problem here, i want to use override my data reader class and i am getting data from db2 database thru .net provider for db2, is there any suggestion that i can do this action regards ...Show All

• Visual Studio Express Editions Array

  Hi. I need some help with Arrays. I have been using a non Microsoft Visual Basic. I have been using it for about 12 Years. I can't seem to find a way to print arrays in Visual Basic.NET V 2005 Express. In my old Visual Basic I was doing this. Type File1 RecF1(20) As Long RecF2(20) As Integer RecF3(20) As String * 1 ' ... ' ... ' ... End Type Now comes the hard part, that is creating the Form to show how the columns and rows are arranged. Below are two Arrays of 5 TextBoxes. For a simple Form demo. _C1_C2_ ........ C1 = Col. 1 - ...... C2 = Col. 2 | | | | | | | | | | | | | | | """""""""""" Sample code to display data in the TextBox. For I = 0 to 4 ' For the abov ...Show All

• .NET Development How to change file privilege programatically

  I want to use my VB.Net windows application to change the file privilege, so that local ASP.NET user would be able to access and modify the file. Can anyone tell me how to do that Thanks! Alex Maybe this helps you: http://msdn2.microsoft.com/en-us/library/system.security.accesscontrol.filesecurity.aspx []'s ...Show All

• Windows Forms Customize Toolbar...

  Hi all, On most windows applications, when you right-click on the top menu/toolbar, you will see a context menu that has the item labelled 'Customize...'. How can I add this to my Windows Forms application Thank you, Stephen. Hi, you can add custom context menu strip to your toolbar through toolstrip's ContextMenuStrip property. Framework's toolstrips don't support this functionality out of the box. Andrej ...Show All

• .NET Development Sorting of datasource

  I have a datalistview which is bind to a datasource. May I know which is a better mechanism in order for user to click on the header to sort the display..using the bind source sort property or the data list view Regards Alu I can't speak to whether one method is "better" in terms of performance or not, but I personally have standardised all our projects on using the BindingSource methods for everything, simply because they seem to work more often with less fuss, and because they're the same regardless of the underlying data source, be it a DataTable or a strongly-typed collection of business objects (which doesn't provide a DataView). ...Show All

• SQL Server Full-Text Search over mutiple tables

  Hi, I'm just wondering if someone could help me with figuring out how to perform a search over mutiple full text indexed tables in the same database Here's my query on one table that works, I need to expand it to over multiple tables. sqlComm.CommandText = "SELECT RANK, intID, chTitle, txtBody, chLink, intProfID " + "FROM FREETEXTTABLE ( tblPortfolio, *, 'ISABOUT(" + strSearchText + " WEIGHT(1.0))') a " + "JOIN tblPortfolio b on a.[KEY] = b.intID " + "ORDER BY RANK DESC; "; Without table schema, sample data, and expected output, it's hard to know what you're looking for. Depending on how/what you want with the da ...Show All

• SQL Server SQL2005 Backup/Restore space requirements

  I have a backup file from a SQL 2005 database on machine A - size 4.3Gb. When I try a restore to machine B I get an error stating that it needs 21Gb to restore but there is only 15Gb free space on the machine. Why does SQL server need 21Gb space to restore a 4Gb backup Greg. Use RESTORE FILELISTONLY to check on the sizes of the files. Although the backup may only be 4G, it does not include any interally unallocated space. At restore time, we still require the full size of the original file. Hope that helps. ...Show All

• SharePoint Products and Technologies Displaying Workbook using external data with periodic refresh in EWA

  Hello. I have a very simple workbook containing a Pivot Table that is populated by an external data source (SQL Server 2005 database). The connection properties of the external data source are configured to Enable background refresh, Refresh every 1 minute, and Refresh data when opening the file. The connection is configured to use Windows Authentication. The workbook resides in a Trusted File location. When I open the workbook in Excel 2007, the refresh works fine. No problems. When the workbook is opened in EWA, it appears to load a cached (old) version of the workbook, then the first time a refresh occurs, the Data Refresh Failed message is displayed. I have closely followed the "instructions" provided at http://technet2 ...Show All

• Smart Device Development How to connect to GPRS network from code?

  When Internet Explorer is ran on my mobile phone it automatically connects to Orange GPRS network and I see a popup/hint on top of the screen saying "Connecting to GPRS...". I want to do the same in my application. Detect somehow that the network if available and just connect to it. I've looked in settings and iI think this is somehow connnected to modem connections but still I dont know how to start them from code. Any help/link will be appreciated. When Internet Explorer is ran on my mobile phone it automatically connects to Orange GPRS network and I see a popup/hint on top of the screen saying "Connecting to GPRS..." ...Show All