LukeParker's Q&A profile

• SQL Server create XML Schema Collection Using UTF-8 in SQL Server 2005

  How can I create XML Schema Collection using UTF-8 encoding I have an xml schema using UTF-8 encoding. When I using it in the "CREATE XML SCHEMA COLLECTION" statement, I got the following error message: .Net SqlClient Data Provider: Msg 9402, Level 16, State 1, Line 1 XML parsing: line 1, character 38, unable to switch the encoding I understand the SQL Server 2005 us UTF-16 for xml data. Does it mean I need to convert the schema to use UTF-16 manually thanks! for a 98% BLL programmer who sometimes work at the db layer... this wasn't obvious first. ...Show All

• SQL Server 'Incorrect Syntax near' Error in Create Type in 2005

  This is getting really frustrating. I've searched and tried about everything I can think of. I have an assembly added to my database by using Sql Management Console. The assembly is called TestUDT. I have defined 4 structs within that assembly, Person, Transaction, Payment, and Seller. The assembly was added to SqlServer 2005 with dbo as the owner, the permission set is SAFE, and the assembly is signed. The structs are within the Test namespace. When ever I type the following in a Query window, just checking the syntax fails, let alone trying to execute it. CREATE TYPE dbo . Seller EXTERNAL NAME TestUDT . [Test.Seller] Th ...Show All

• Visual Studio Team System CI and Team systems

  I have realized that MS has for some reason decided not to make Team Services support CI. This is for me a very strange decition. Especially when the other tools that are now coming bundled with VS are supporting true Agile processes so well. I have seen a lot of "workaround" suggestions to this problem. But they seem mostly to be made by people who really don't understand the CI workflow. So to help out I have decided to post this little list of requirements of what a CI server needs to do. -Periodically check for changes ( as in every 5 minutes compare current changelist with latest successfull or failed changelist.) -Check if a build is ...Show All

• Visual Studio Team System VSS Migration Error

  Unable to write to SQL Server: .\SQLEXPRESS due to Error: The size (4969) given to the parameter 'Mappings' exceeds the maximum allowed (4000). This popped up twice and prevented my migration from going through. You'll notice the link goes no where. So, any clues/suggestions on what to do next Thanks, Drew Well, here's an interesting twist. My project mapping file has 55 mappings in it. If I break the file down into chunks, the conversion succeeds for all projects without error. For example, I initially commented everthing out to 11 logically related projects, ran it and had no errors. Ran the next s ...Show All

• SQL Server how to populate foreign key in normalizing import?

  I am copying data from one denormalized table to a COUPLE of normalized ones. I am using multicast, following advices from the forum. The problem I have is that the two destination tables (A and B) are sharing a foreign key relationship.Filling in A is no problem, but when I want to fill in B, I don't know how to populate its foreign key, since the multicast doesn't know the corresponding primary key in table A. Does this help http://blogs.conchango.com/jamiethomson/archive/2006/05/22/3974.aspx -Jamie ...Show All

• Visual Studio 2008 (Pre-release) WS-Management

  Does WCF support WS-Managerement Tom, there are three possible ways I can take your question. Question 1) Can I talk to WS-Management enabled services using WCF Answer: Yes, you can use WCF to write client applications that talk to systems, devices, etc. that implement the WS-Management specification. Question 2) Can I use WS-Management to manage WCF applications Answer: Yes, depending on what OS you're running. WCF exposes its management functionality via WMI, which is exposed over WS-Management on Windows Server 2003 R2 and above. See [1] for more information. Question 3) Can I write an im ...Show All

• Visual C++ Like to know correct API to get screen resolution on monitor?????

  Hello, I like to know the API that can give me the screen resolution set on the screen display (monitor). Anyone know that API Pls name it for me. Thanks. http://windowssdk.msdn.microsoft.com/library/default.asp url=/library/en-us/gdi/devcons_88s3.asp GetDeviceCaps ...Show All

• Visual C++ VC stops executing

  Its vc++ 6.0 Enterprise edition running on windows xp. And specifically happens when i do this: CMyDocument::OpenAVI(CString FileName) {     AVIFileInit();     PAVIFILE pAviFile;     AVIFileOpen(&pAviFile, FileName, OF_READ, NULL);     AVIFILEINFO fileInfo;     AVIFileInfo(pAviFile, &fileInfo, sizeof(fileInfo));     PAVISTREAM pVideo;     int nNumAudioStreams=0, nNumVideoStreams=0;     AVIFileGetStream(pAviFile, &pVideo, streamtypeVIDEO, 0);         AVISTREAMINFO streamInfo ...Show All

• SQL Server SSAS 2005 with Kerberos/Delegation

  I tried posting this to the MS OLAP newsgroup, but didn't get much response, so I'll try here. I've been trying (and failing) to get Kerberos delegation to an SSAS 2005 server working. I've followed all of the steps on: http://www.mosha.com/msolap/articles/kerberos_delegation.htm But still no luck. Delegation is working fine with SQL Server, but not Analysis Services. I've verified the SPN, connection string, enabled delegation, configured with web site (typical IE to IIS to SSAS setup), etc, but no luck - the connection to the server always shows up in Profiler as "anonymous", and the connection fails. Are there any tools or tricks ...Show All

• Visual Studio Team System Restore-move but re-create Sharepoint

  I need to move my TFS installation to another machine, typically this would be a simple "Restore based move", but there's a complication: my sharepoint content database is messed up and can't be backed up (SSMS gripes about the full text index being offline- indeed, it seems to be missing completely). Rather than mess with Sharepoint, what I'd rather do is simply create new portal sites for my projects - I can re-upload all the documents, and I haven't done any sharepoint (or reporting services) customization. So, here's what I'm thinking of trying - please point out where this won't work! 1. Install a fresh new Windows/WS ...Show All

• SQL Server Dynamic Login & User Creation

  Hello. I'm trying to create a new login and username inside a trigger using variables. This code works: create login testUserName with password = 'testPassword' The problem comes when I try to use variables for the username and password like this. create login @username with password = @password Does anybody know how to get around this problem BTW, the error message it gives is this, but I really doubt that semicolons have anything to do with it. If I literally type my data in the create login call it works fine, but when I use variables it doesn't. Msg 102, Level 15, State 1, Line 14 Incorrect syntax n ...Show All

• Visual Basic include DLL widthout make reference....

  Hi everyone. I use an external DLL and I want inlay the DLL into my exe program. (I don't want copy the exe program and the dll file, just 1 file!) How can I do that and I can call the dll file in the code Can someone give me an example in vb I'm trying convert the code from http://objecthead.blogspot.com/ to VB but still not working. Thanks ...Show All

• Windows Forms ClickOnce installation error

  Below is the error messages many of my users are encountering when attempting to install a ClickOnce application. This error only occurs for some users. Some users do not experience any issues with the installation. LATFORM VERSION INFO Windows : 5.1.2600.65536 (Win32NT) Common Language Runtime : 2.0.50727.42 System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200) mscorwks.dll : 2.0.50727.42 (RTM.050727-4200) dfdll.dll : 2.0.50727.42 (RTM.050727-4200) dfshim.dll : 2.0.50727.42 (RTM.050727-4200) SOURCES ...Show All

• Visual C# Uploading a text file to a server

  Hello, when running the code below, it returns the error message: "The requested URI is invalid for this FTP command.". I have confirmed the FTP URI is correct and working through a standalone FTP client as well as windows explorer, the domain\username and password are also valid auths. I've also downloaded two seperate classes similiar to the code below, from MSDN, and I'm getting this same error message whatever I do. Any ideas -- Thanks. protected void Upload(string fileName) { Stream requestStream = null; FileStream fileStream = null; FtpWebResponse uploadResponse = null; try { FtpWebRequest uploadRequest ...Show All

• Visual Studio Team System which setup directory?

  in the install help file, single server install, team server install, I do not see this specific folder on the DVD download from MSDN: \vs\atdt downloaded  this image, en_vs_2005_team_suite_dvd_beta2 and extracted ISO files to hard drive folder using \VS\setup.exe returns error: "setup was unable to copy file   ....\vs\deletetemp.exe to your temporary directory..." deletetemp.exe is not in \vs directory Help file snippet... 5.  On the autorun page that appears after inserting the installation media, click Install Team Foundation Server , and then click Single-Server Installation . If the autorun page does not appear, ...Show All