DonMartin's Q&A profile

• SQL Server Trying to Enforce Delete Casade on FK

  Hello, I'm having a little bit of a problem. I've been using MSSQL 2000 right along, now i'm using MSSQL 2005. Something I've been doing right along in MSSQL 2000 isn't working in 2005. I'm just try to get a column in one table to have a relationship with a column from another table whereby when you delete a row from the first table, it will delete all the rows in the second that have a FK value the same as the table I deleted PK. So tblUserTypes has a list of all the different User Types Table: tblUserTypes +--- pkUserTypeID --- typeTitle ----- blocked + | 1 Administrators 0 | | 2 Managers 0 | +-----------------------------------------------+ Table: tblUsers +--- pkUserID ----- username ----- fkUserType ---- + ...Show All

• SQL Server Duplicate Values on Top Level of Dimension

  Hey there community, I have a problem, and i am lost as to how i can fix it.. I would be over joyed if someone can give me a hand in identiffy it.. I will try to explain below:: I have a cube for sales, that displays sales by a Market heiracy of Market->Division->Family->Item.  When i drill down, sales numbers look fine..  I added in a budget file, which only specifys budgets down the the Division Level.. I have added the Budget Figure as a Measure Group.  In the dimension usage tab, i specify the Division as the Granuality for the Budget Measure Group on the Market Dimension.. Measure Groups Dimensions Standard Measure Bu ...Show All

• Software Development for Windows Vista Statemashine workflow - handleExternalEventActivity

  is that the  HandleExternalEventActivity must have to handle a different event in a Statemashine workflow why Can't  they  hand the same event  like "approval"  it is impossible to define a lot of events. Have you been able to resolve this issue yet If not, which build are you using You should be able to have multiple HandleExternalEvent activities that subscribe to the same event in a StateMachineWorkflow. Take a look at this sample on my blog. ...Show All

• .NET Development Syntax Error

  I'm trying to write a database application in Visual Studio 2005 that inserts data into a database from a VB form, the connect and insert code are below: conBooking = New OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=booking.mdb" ) Dim SQL As String SQL = "INSERT INTO tblBooking (Cust_Name, Telephone_No, Going_From, Going_To, Additional_Requirements, Booking_Date, Booking_Time, No_of_Passengers) VALUES" SQL = SQL & "(" & strName & ", " & strPhone & ", " & strFrom & ", " & strTo & ", " & strRequirements & ", " & strDate & ", " & strTime & ...Show All

• SQL Server Time Series Periodicity

  I'm trying to learn about time series algorithm but I can't set the time periodicity right. I have information stored 2 times a year (semester) so I'll should set up a PERIODICITY_HINT = {2}, right but it does not change anything. Here is a screenshot that might help understand the problem: The hint is being used, but the algorithm isn't finding relevant patterns. It is considering those periodicities, but in the end it didn't find anything interesting with the "2" hint. What my main point was is that by default the algorithm will consider the last 8 time slices at inputs, so "t-2" is already considered. By adding "2" as a hint, what you are actually doing is telling the a ...Show All

• SQL Server How to install sql server 2005?

  Hi all, I dont know whether it is right place or not I am using .Net 1.1 and Sql server 2000.Now i have installed .Net 2.0 andthis time i did a small project with .Net 2.0 with Sql server 2000. But my client needs .Net 2.0 with Sql server 2005 regular version. Now i uninstall Sql server 2000. But when i insert Sql serevr 2005 cd it shows 1.Prepare a.Review hardware ....... b.Read the relaese notes c.Install Sql server Upgrades advisor 2.Install a.Server Components ,Tools,Books Online.... b.Run The sql Native Clients Installation Wizard 3.Other Information .... Which one i hav eto click to install a fresh new copy of regular version of Sql server 2005 Thanks Ujjwal ...Show All

• SQL Server Extracting a specific amount of data from a field

  I am working with a particular field in my SQL database that has the addresses of all our customers. Each part of the address is seperated with a Carriage return but is shown in the database as just a single line of text. I need to show this in my report as a seperate field for each part of the address (A1, A2, A3 etc..) however I am unsure as to how to extract the data up to each carriage return and then from that one to the next one. I can use the following which obviously just extracts the data up to the first specified character length but this doesnt really help very much. SELECT LEFT(ADDRESS, X) AS A1 FROM GTW_BUSINESS_PARTNER Has anybody got any ideas how this can be done. Many thanks The SQL character (ascii) for carria ...Show All

• Visual Basic [ RESEOLVED!! ] Newbie Question about Windows Service (first timer)?

  First off let me apologize for what I'm sure will be a somewhat long post. I'm totally new to Windows services so I want to be as clear as possible in terms of what I've done. OK. I think that I'm about halfway there with what I am trying to accomplish. I have a program which is written in VB 6. When it is launched, it calls 3 additional programs (all written in VB 6). This works fine but the problem is that I've got the first program in the StartUp folder but it only starts when somebody logs onto the system. I want to write a program in VB 2005 that will run as a service and that will in turn call this program (so it'll always run when the server restarts whether anyone logs onto the system or not). I've never even look ...Show All

• Visual Studio Specifying output path for CHM documents

  I have integrated msbuild with sandcastle to generate chm documentation. I need specify the output path for these chm files. What is the parameter to specify the output path Thanks, Srikanth Srikanth, Did you resolve your issue The msBuild scripts at http://codeplex.com/Project/ProjectDirectory.aspx ProjectSearchText=sandcastle should help you. Anand.. ...Show All

• .NET Development Neither XmlReader nor XmlTextReader are able to process my XML file

  Hi, I am not able to use the XmlTextReader class in C#, as it is not able to read DTD entity codes, and I can't use the XmlReader because it returns bogus AttributeCount/HasAttributes values. In other words, I'm stuck. I started by using the XmlTextReader, which works nicely until I get to XML that uses DTD entity codes. I needed to use the XmlReader.Create() method and pass an XmlReaderSettings object into the constructor - with ProhibitDtd set to false. This worked, but now I get plainly incorrect results for the HasAttributes and AttributeCount method/properties. AttributeCount is returning 1 when reading the following element: "<gloss>readability</gloss>". Not only that, but the 'HasAttributes ' property returns true while ...Show All

• Visual Studio Team System Create Assembly--I know...I know

  In CTP 5, I believe, when building the project, the CREATE ASSEMBLY FROM 'x.dll' autmatically built the required binary code to build the project WITHOUT having to do the manual create/script and then put in the project. Why was this dropped from--not only 6 and 7--the RTM This seems like a step backward not forward. Any changes to the dll require performing an ALTER ASSEMBLY, script, and paste all over again. Hi Kevin, The main reason this was removed is due to the fact that the pathing for the assembly can not be relative pathing based on a user enlistment to source control which makes the use of the file path in the CREATE ASSEMBLY statement problematic in a team working environment. We a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. spontaneously error

  Somtimes i get an excpetion whem I'm trying to render text using Font.DrawText. I'm getting a "Object reference not set to an instance of an object.", but everything is as it should be. I have no idea why I'm getting this exception, and i can never make it happen again. I'm preety lost here, guys. Help would be greatly appreciated. Thanks. You were right if this method will fail every time, but it dosen't fail every time. After a while it fails. when it fails I'm recreating tthe Font (calling CreateFont()), so There will be no doubt that the Font object is operative. some other idea ...Show All

• SQL Server Need to retrieve record count from CTE

  I have a common table expression and I need to retrive first 20 records as well as record count. select @first_name='m', @last_name='s' with my_cte as ( select row_num = row_number() over (order by prosp_id, contact_num) , first_name, last_name from piza.prosp_contact where first_name like @first_name + '%' and last_name like @last_name + '%' ) select row_num, first_name, last_name from my_cte where row_num between 1 and 20 Another alternative is to create CTE twice, first time for 20 records and 2nd time just for record count. But in this case it will perform all physical operations like index scans, joins, etc - twice. Yeah, ...Show All

• Visual Studio Express Editions How to search for strings in the listbox or sequential file access?

  Hello developers, I'm a first year student and I am doing a project regarding "Phone List Index and Searcher". By the name of it, you should already know that I'm supposed to create a program which is able to search for a substring of an entire string. My strings are kept using sequential file access and displayed using a checked listbox. Here are the few details you might want to know: Buttons Add - Add 2 string inputs, name and contact no. Remove - Deletes selected string from the listbox( I have a problem deleting multiple strings) Search - How do I code the search button and by using what method Refresh - Do a WriteAllText method to rewrite the entire sequential file and re-display. I ...Show All

• .NET Development How to write Client-Server Application in VB.NET/2005

  I am a VB6 prgmr learning VB.NET. In VB6 I implement server side apps as Active-Server project. I then reference the file in my VB6 project. I also use DCOM to remote the server side. How do I achieve similar structure in .NET Million thanks. Vie EGBE Thanks for the prompt assistance. However I believe the way I framed my question misled you. I already have been reading stuff about tcpClient and tcpListener. These work like Winsock in VB6. The TcpClient class provides simple methods for connecting, sending, and receiving stream data over a network in synchronous blocking mode. What I need is to development a server that implements the business layer of my project. It is to be remoted and has methods that can ...Show All