Sideout's Q&A profile

• SQL Server Full text search with MSQL 2005

  Does MSQL 2005 Full-Text-Search engine make use of Microsoft Search Service like the previous version (MSQL2000) If yes, where there any improvements in performance Is MSQL 2005 Full-Text-Search recommended AND ready for large scale / enterprise systems with lots of traffic If yes, how is the performance I've been doing some research, but I can't find any good articles on it... if you know of any please add them to the thread! :) Thank you very much! Although this is for SQL Server 2000, the information still holds: http://support.microsoft.com/ scid=http%3a%2f%2fsupport.microsoft.com%2fsupport%2fsql%2fcontent%2f2000papers%2ffts_white+paper.asp Buck Woody ...Show All

• SQL Server Why is database so large?

  Hello! I have a database with one table inside. The table has six columns with the following datatypes: col1 -->smallint (2byte) col2 -->int (4byte) col3 -->smallint (2byte) col4 -->smallint (2byte) col5 -->smallint (2byte) col6 -->int (4byte) I have insert 1.359.320 rows with data and the size of the sdf file is 40.116.224 byte. According to my calculation: 1.359.320 * 2byte + 1.359.320 * 4byte + 1.359.320 * 2byte + 1.359.320 * 2byte +1.359.320 * 2byte + 1.359.320 * 4byte = 21.749.120 byte I hope somebody can explain me, why the database is so large. Thank you Sascha I don't think there is any other way to bring it down. If you have some indexes on the table, you might consider ...Show All

• SQL Server trying to digitally sign a clr sproc for external_access permissions

    i have written  clr sproc in c#, for use in sql server 2005. the sproc takes a file path and returns file data( size, date modified etc).to do this the sproc needs the permission_set = external_access. to get this i have to sign the dll with a certificate. i created my own root certificate using this command : makecert -sv GetFileInfo SignRoot.pvk -cy authority -r GetFileInfoSignroot.cer -n "CN=GetFileInfoCert" I then added this certificate as a trusted root cert. then using this command i created the signing cert for the dll: makecert -m 360 -n "CN=FileInfoSigningCert" -iv GetFileInfoSignRoot.pvk -ic GetFileInfoSignRoot.cer -cy end -sv GetFileInfoSigningCert.pvk GetFileInfoSigningCert.cer when i test though using : sign ...Show All

• Visual C# wanting to right click within FileListBox and change Form title text to selected file.

  how do I access the title bar of the frmTest below thx. -greg namespace TestExplorer { public class frmTest : System.Windows.Forms. Form private void fileListBox1_MouseClick( object sender, MouseEventArgs e) { frmTest . = this .fileListBox1.SelectedItem.ToString; } The Text property gives you access to the window caption on a Windows form. ...Show All

• Visual Studio 2008 (Pre-release) SandDock in WPF

  Hi all, in my application I've been trying to add dockable windows using SandDock. I have this in my XAML-file: <Page xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:wfi="clr-namespace:System.Windows.Forms.Integration;assembly=WindowsFormsIntegration" xmlns:wf="clr-namespace:System.Windows.Forms;assembly=System.Windows.Forms" xmlns:sd="clr-namespace:TD.SandDock;assembly=SandDock" > <Grid> <wfi:WindowsFormsHost Height="100" Width="200"> <sd:DockableWindow x:Name="sdWindow" /> </wfi:WindowsFormsHost> </Grid> </Page> a ...Show All

• Visual Basic Need help using the "NEW" Keyword in Visual Basic Express

  I am new to Visual Basic and I would really appreciate it if I could get an example of code using the "New" Keyword as in creating a new object. Thanks http://msdn.microsoft.com/library/default.asp url=/library/en-us/vblr7/html/vakeyNew.asp The New keyword introduces a New clause, which creates a new object instance. The New clause must specify a defined class from which the instance can be created. You can use New in a declaration statement or an assignment statement. When the statement is executed, it calls the constructor of the specified class, passing any arguments you have supplied: Dim Obj As Object Obj = New SomeClass("String required by constructor") ...Show All

• SQL Server Importing Data from access 2000 in SQL

  Hi All, At the moment i have a piece of software that uses Access to store the data into a number of tables. I am developing a new piece of software that has been built around SQL express and need to upgrade users that are using access. I have managed to write the installation to install etc and also the start of a script to insert all of the tables. I cant work out how to get the data into SQL express using a script. Basically the access db (CentralDb) will be stored a a given location C:\Program Files\CentralDB.mdb The tables within the SQL version are indentical to access but i need a way of pulling out the information stored and putting it into SQL, and as there is no DTS i am becoming stuck on how to automate the proce ...Show All

• Visual Basic printing a file (created in a procedure) in hebrew language

  in vb.net 2003, i have a project (for a store -in israel) in which I want to print a receipt. I write the receipt in a file for which i use the stream writer . The file contains hebrew headings and variables containing hebrew. when it prints it looks like gibberish. What can I do. Help! I am despairing.! Thanks for any help!!! GreatGrandma !! thanks again Geek Squad for your answer. You are right about my not be interrested in using on line. The file is indeed printed from a text box. I also tried to print with the graphic option (meant for pictures) but then it gave an error message that there not enough memory All the best ...Show All

• Internet Explorer Development So What do we do about the issue here?

  I still cannot browse ie 7. I reinstalled 7 and it does not even show in control panel to uninstall ...Show All

• SQL Server Data flows and unique columns.

  Perhaps one too many 2000 DTS packages have permanently damaged my ability to think clearly - however, I've find myself very frustrated attempting to create a SSIS Data Flow which replaces a very simple 2000 DTS package. Take data from table1 in database1, put it in table2 in database2. Table2 in Database2 has an additional column as part of the primary key - so I need to add an arbitrary unique value in each row as it's inserted. Previously, I did this in the transformation script through a variable I incremented. What's the recommend method to do this now - since row level processing of variables seem to be a no-no A script component in the data flow will do what you want. The following script a ...Show All

• .NET Development Application blocks with console applications.

  Can somebody tell me if I Can use Microsoft Logging Application Block with console applications. If yes, then how becoz I am new to console applications. Regards, Hi, Thanks a lot. It helped me a lot. Just want to know one more thing. I have an application and want to log the exception to the EventLog and display user friendly msg to the user. For that I have used both Exception Handling and Logging Application block. How should I use them through my code. Let say if I have 3 forms then how to handle it ...Show All

• .NET Development SSL session problem

  How can I establish an SSL session ! When I connect to a SSL site using my browser, the SSL session is established. But when i try to do the same using C# I don't seem to be succesfull. Another problem that I don't understand is the fact that when I use my browser to connect to the IP address for instance https://192.168.100.12/advanced_statusF.cgi the session is open and i can login. the problem arises when i copy the page to disk and try to access C:\Documents and Settings\Goran.Kostel\Desktop\Fantom Login.mht , which is just a save as copy of the page, I can't log in. My intention is to login using C# but it appeares I'm not able to do that. Thanks!   My code is as follows..   string p_aURL = "h ...Show All

• SQL Server Web Sync Wizard On XP Box

  I have (finally) successfully gotten through the maze and 'published' my database to a folder: Physical path: I:\SqlReplication unc: Warrenassoc\SQLReplication Since I'm running XP pro, I don't have the options of assigning specific read/write permissions to a folder. However it appears the problem is with accessing the snapshot and the logon's there. When I run the IIS Web Configure wizard I error out at the snapshot share permissions step (see report below) Wizard Settings: Click Finish to perform the following actions: Modify a virtual directory immediately. Copy the ISAPI dll 'sqlcesa30.dll" to 'I:\SqlReplication" immediately. Set NTFS permissions immediately. The virtual directo ...Show All

• Windows Forms datagrid (GetChanges) - Extracting Data **Cols/Rows**

  Hi,   I have a datagrid [Winforms, C++] and what I want to do is when a user has finished updating any data they can click a button.   On the button press I want to call the (DataSet) GetChanges function which checks whether any rows in the datagrid have been modified.   If there has been changes, I would like to loop through the changes to see if the data entered is valid.   When it loops through the rows I want to get the value of the first column of the current row, I then would like to get the value of the second column in the current row which I can parse.   I have written a little code [C++] code, although I'm not sure how to get the row values. [See below]     DataSet *myDat ...Show All

• SQL Server SQL Question

  Hi there, I have these tables: Students student_id (PK) student_name Courses course_id (PK) course_name StudentCourse student_id (PK) course_id (PK) If I want to select a student that has 'course1' and 'course2', how do I write this statement This didn't work: SELECT DISTINCT Students.* FROM Courses INNER JOIN (Students INNER JOIN StudentCourse ON Students.student_id = StudentCourse .student_id) ON Courses.course_id = StudentCourse .course_id WHERE Courses.course_name LIKE '%course1%' AND Courses.course_name LIKE '%course2%' The problem is 'AND'. it concate the two course_name(s) to be like this condition: WHERE Courses.course_name LIKE '%course1course2%' Any idea Thanks Hi ShEi, Yes I meant ...Show All