deklund's Q&A profile

• SQL Server date format change on US Server

  Hi, We have a server (SQL 2005) set up as US date format and have tried to change it to UK using syslanguage etc Anyone know how to do it at a global level so we dont have to change lots of SP Regards Stu Datetimes are stored language independent in SQL Server. Its the setting of the user which makes the datetime appear in the local format. if you Change the individual setting of the user, the datetime will be displayed in the appropiate format. If you want to set the default language for any new logins you can use the sp_configure with the default language option. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server SQL 2000 replicate to Oracle 10g R2

  Hi all, I have some questions about replicate data from MS SQL 2000 to Oracle 10g R2: 1. Is it only SQL 2000 Enterprise Edition support replication 2. Is it the Oracle DB must install on Intel-based Windows server Thanks! Regards, Edwin 1. No, standard edition has all the replication feature as well. For complete list, check the following link http://msdn2.microsoft.com/en-us/library/aa175266(SQL.80).aspx 2. No. As long as you have the correct ODBC or OLEDB driver for Oracle, then it does really matter if the Oracle DB is on Intel-based or not. http://msdn2.microsoft.com/en-us/library/aa237112(sql.80).aspx Regards, Gary ...Show All

• Visual Studio 2008 (Pre-release) XamlReader.Load is not finding named elements for loose XAML

  i've got an app which loads Loose XAML using XamlReader. the problem is that named elements cannot be found by triggered animations when loaded using XamlReader.Load(). but if i embed the exact same XAML into the app ... it works fine. so how is XamlReader not parsing it the same e.g. the loose XAML has a named element in the content like this (it's an excerpt from playing video on a 3d plane). the exception this will throw when it tries to render is "'mediaElement1' name cannot be found in the name scope of 'System.Windows.Controls.MediaElement'." <GeometryModel3D> <GeometryModel3D.Material> <EmissiveMaterial> <EmissiveMaterial.Brush> <VisualBrush> ...Show All

• Software Development for Windows Vista Technology used in windows vista

  Hi! Please help me out to know that what is the technology/ language used to develop windows vista This is urgwnt. Please do reply to this post. mainly C/C++ and a tad of .NET Development I believe and Assembly (machine code) different languages have been used to develop the Windows OS overall...not just 1 specific ...Show All

• SQL Server Interactive sorting of a list

  I have a list data region that has column headings outside the list. I would like to be able to click a column heading and sort the list. However I cannot do this because the scope of the header can't access the list. Has anyone sorted a list by clicking textbox column headings Please help. Hi Patrick- In general, when applying a user sort, you can sort items that are at the same scope, or are in a child scope. You might try setting the textbox to sort on the data set wihch the list is using, and then set the sort expression scope to details. If you are using RS 2005, I've included a sample RDL below. Just copy the text to a file, rename the extension to .rdl and open it in report designer. -Jon ...Show All

• SQL Server Selecting varchar(MAX)

  Hi, Hope I'm in the right forum. Is there some sort of trick to being able to see all the data in a varchar(MAX) column I'm inserting some lengthy data into varchar(MAX) columns. Running the profiler, I can see that long strings are being passed in. But, when I query (to grid, text or file), I only see the very first character. In addition, when I do a SELECT LEN(myVarcharMaxColumn), it returns 1. What am I missing here Thanks, Mike oh, I should say that I have four varchar(MAX) columns. They are defined as varchar(MAX) when I right click the table and chose Modify. When I do sp_help myTableName the length of the varchar(MAX) colums shows as -1. Mike ...Show All

• Visual Basic header files

  I want to use various API calls from VB2005. Many of them require certain parameters which have complicated names like MEVT_F_CALLBACK and MHDR_DONE. (These come from winmm.dll) The Microsoft SDK documentation decsribes all these parameters but omits to give their numerical values. I understand that the values of these constants are held in a header file which in this instance is be called winmm.h. My question is - where is winmm.h It is not on my computer (though winmm.dll is). I can find lots of references to winmm.h using a search engine but nobody says where it is! I am obviously missing something here. Is it inside winmm.dll If so, how do I extract it Or am I barking up the wrong tree completely Help!!! ...Show All

• Software Development for Windows Vista A new outlook on Windows Vista

  Hi! I am fascinated by the way in which Microsoft plans to change the nature of operating systems radically. Vista promises a better future -- lots of new data exchange solutions, better information organization and an easier GUI. It looks very exciting to me. However, there is still some doubt whether Vista will really be able to define the new wave of technology. I've been a user of Windows for the past 9 years, and have been accustomed to it (one reason I'll accept Vista quickly). I'd like to point out a few things that Microsoft should improve in order to gain more popularity (and market share ). Of course, I'm not a Microsoft employee so I don't know what's really going on. Just keep in mind that these are my personal opinions a ...Show All

• Visual Basic Looping

  How do I setup a for next loop array to open files if I don`t know how many files are in the folder davco wrote: Now I am getting"Index was outside the bounds of the array" Here are some array checks you can do before setting the image: If files.Length = 0 Then MessageBox.Show( "No pictures found" ) End If If selectedIndex < files.GetLowerBound(0) Or selectedIndex > files.GetUpperBound(0) Then MessageBox.Show( "Invalid selection" ) End If Andrej ...Show All

• Visual Studio Team System Already exisiting object

  If you drop an object from your project, e.g. a table, then import it as from a script, you won’t be able to build the database, because the project is mourning that the "Obejct already exists in the database" not matter what settings your use in the Build pane in the properties dialog. -Jens. --- http://www.slqserver2005.de --- This is a bug which I believe we have fixed. To get around the issue now does REFRESH help because in theory that should refresh our schema manager(cache) mairead PM TS Data ...Show All

• Visual Studio Team System Custom Check-In Policy: Time That Task

  I just created an interesting check-in policy and wanted to share it with you all. I'm interested in your feedback. Custom VSTS check-in policy that gathers hours worked on a task during each check-in. This policy requires check-in to be associated with only one task that is in an "Active" status. It also gathers the number of hours worked on the associated task incrementing the completed hours and decrementing the remaining hours. If the number of hours worked on code in check-in is greater than remaining work hours on the associated task, user will be asked to re-estimate the number or hours remaining for the task. http://www.gotdotnet.com/Workspaces/Workspace.aspx id=9375fae2-5104-4d46-8b3a-c0b170b08320 Reasons why I created th ...Show All

• .NET Development Web Services & Partial Encryption

  i am developing a set of web service methods which return reporting data. ideally i do not want to use HTTPS due to the extra performance hit. what would be ideal is to encrypt only that data which is sensitive. for example, 1 particular report has 12 columns of data. but only 1 column of data really needs to be encrypted over the wire (the client name). at the moment my web service method returns a dataset. although i can change this, if it is easier to implement partial encryption by returning a different type. please could anyone advise if it is possible to perform partial encryption in .NET2.0 like this if so i would be grateful for any advice, URLS, etc. to get me off on the right foot. thanks ...Show All

• Windows Forms DataGrids

  I was wondering.. If anyone can show me a really really simple example of datagrids with maybe just one row of a random information... I have a load of tuts.. but I cant find the right one to start with. i'm having a little problem, because the generic list that i'm trying to bind to the datagridview is a generic list of int, and when i show the grid it shows me the raws(the count of items in the list), but not the integer, it shows to me the raws in blank. why i'll really appreciate the help. excuse me for my english, i'm from spain. thnaks ...Show All

• Visual Basic Can not start the smtp service in Win xp sp2 .. pic inside..

  http://images.imagefap.com/images/full/19/199/1992309304.gif I wonder what seems to be the problem im afraid this is the wrong place to post the question. These forums are for .NET development. the best place would be over at the appropriate newsgroups: www.microsoft.com/communities To me, it seems as if IIS/SMTP is not installed from the control panel/add + remove programs. This is available in the XP PRO range of the XP OS's Thanks! ...Show All

• SQL Server Complex Self Join

  This is a very complex query and i have tried everything with no sucess. I'm having 3 Tables, Orders which is having fields like CustomerID, ManufactureID, MerchID :- These all ID Fields (around 6) are foreign key of Contacts and Address Tables. Address Table is having AddrID(Primary Key), ShortName Contacts is having ContID (Primary Key), AddrID (Foreign Key), PersonName I want to retreieve info in a single query which can return a single row with following columns :- OrderNo, CustomerName, ManufactureName, MerchName etc. (all 6 columns) by joining these 3 tables can anybody help in this. Could you use one IDE (for example, Design Query in Editor in SQL Server 2005) to do this Yo ...Show All