John Sobernheim's Q&A profile

• SQL Server Command line/utilities to clear cache

  Hi,Does Reporting services expose any command-line or utility tools to clear reports cache explicitly other than the caching configuration at certain interval Thanks,Jet You can find information about scripting here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/rsuiref/htm/cpu_rs_v1_5fxe.asp You should also look at this: http://msdn.microsoft.com/library/default.asp url=/library/en-us/rsprog/htm/rsp_prog_soapapi_script_3249.asp The flush cache method is here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_22i9.asp You script will look something like this (not sure this is 100% correct) Public Sub Main() Dim i ...Show All

• Software Development for Windows Vista Service logon password changed during upgrade from XP to Vista RC2

  While testing for compatibility scenarious, we found out that service logon password is modified during upgrade from XP to Vista RC2. Because of that service does not start after upgrade. If password retyped, service of course starts successfully. Installing directly to Vista RC2 does not have any problems. Password length is 15 symbols and it's a combination of upper and lower case letters, digits and underscore symbols. Do you have any comment on if this is a known bug and when it's going to be fixed There is no bug reported like this. What service is this Also what's the service logon Is the logon admin user, standard user Is UAC on or off after you re-enter the password and start service ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Help converting MDX1.1 Sample to XNA

  I'm trying to convert some of the samples in Tom Miller's book (Managed DirectX 9 - Graphics and Game PRogramming - Kick Start) to XNA. For the most part, it's been quite obvious what things have changed (mostly naming, and new naming is so much clearer than before!), but I'm stuck with a few bits. Can anyone help I've checked the migration guide, but it doesn't seem to mention any of these missing methods/properties :( Error 1: vb = new VertexBuffer (graphics.GraphicsDevice, typeof ( VertexPositionColor ), NumberItems, ResourceUsage .Dynamic | ResourceUsage .WriteOnly, ResourcePool .Default); vb.Created += new EventHandler ( this .OnVertexBufferCreate); VertexBuffer no longer has a Created event (nor anything ...Show All

• Visual Studio 2008 (Pre-release) O/R Frameworks and private vs. protected visibility - please use protected

  Hi there, I have a general request to the LINQ team as well as the Databinding Teams. As a VSIP Partner we are always extending the MS Frameworks - just like the company customers do. Therefore it would be helpful if private members could be changes to protected members. Thank you very much. I understand your desire to modify the framework. Unfortunately, exposing implementation details like this is difficult since it increases the testing cost and impares our ability to fix or modify the implementation in future releases. ...Show All

• Visual Studio Get Project Reference Sample Code

  Hello... I need a Sample Code for get a Project reference of a Web Service Project... Thanks CarlosMag Hi CarlosMag, Can you explain a bit more what you need Do you need automation code to get a handle of a web service project of an opened solution Please provide more details. Thanks, -Victor. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Circling an object

  hi, when i press the left arrow, i wish my camera to circle the camera-target. can someone please tell me how this is done You need to change the view transform. You can create a suitable one using lookatLH which allows you to pass in the camera position and the look at position. Look at position will be the location of the object you wish to circle. Camera position will be based on an angle (you will increment this angle as the arrow key is held down) and a distance from the object you are looking at. Its simple trig/dot products. If you can't do the math to work this out then I would suggest getting a simple trig book or spending some time on mathworld.com - the math only gets harder from this point on with 3d games. ...Show All

• Visual Studio Tools for Office Soap Context missing in custom SharePoint web service

  I have created a custom SharePoint web service. I want to attach a file to the SOAP response using DIME, but inside the web service both RequestSoapContext.Current and ResponseSoapContext.Current are null. Outside of SharePoint the SOAP context is there, but when I use it as a SharePoint service, the SOAP context is no longer available. I followed the MSDN example for creating a custom SharePoint service (e.g. creating the disco.aspx and wsdl.aspx, putting the files in the _vti_bin folder etc.) Has anyone experienced this issue Thanks! Christopher Bernholt Thanks! This was the only forum where any results with sharepoint in them were returned from my search. Christopher Bernholt ...Show All

• SQL Server working with decimals or real numbers

  I have a number 8.30 how can I break apart the 2 parts of this for more simplicity I need to take out 8 and 30 in 2 different variables, how can I do it Please advice Does this help create table test ( value varchar(20) ) insert into test select '8' union all select '9:30' union all select '8.45' select case when patindex('%[:.]%',value) = 0 then value else substring(value,0, (patindex('%[:.]%',value))) end, case when patindex('%[:.]%',value) = 0 then 0 else substring(value,(patindex('%[:.]%',value)+1),len(value)) end from test ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. VMX and SIMD support

  What kinds of mechanisms will be available to support the use of the VMX units on the 360 and SIMD in general Will the compiler be auto vectorising or will a number of pre -optimised libraries be supplied For our first release we were unable to get VMX 128 SIMD support into the runtime.  This is something that we are proactively investigating for our next release.   aL ...Show All

• Visual Studio 2008 (Pre-release) Serialization issues with XmlElement and DataContrac

  Hello all , I just sorted out my inheritance issues and now have an issue where an Xml element when serialized has xmlns="" inserted . ie <CommsMessage xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:q1=" http://tempuri.org/ " xsi:type="q1:AckMessage"> <q1:MessagesToAck><q1:string>urn:uuid:11a072c0-4b78-44b1-b2ec-9ea6cda90b07</q1:string></q1:MessagesToAck> </CommsMessage> the proxy changes it to <CommsMessage xsi:type="q1:AckMessage" xmlns="" xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd=" http://www.w3.org/2001/XMLSchema & ...Show All

• SQL Server Can't uninstall or reinstall nonfunctioning sql server

  In previous post in the Getting Started section, I discussed problems trying to run queries on multiple databases: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=299240#299240&SiteID=1 Nobody could help with the problem. I eventually got a query to run after several attempts at deleting and recreating databases. Then, I was hit with the following error message: Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration) Nobody could help with that either but based on posts with the same message, I tried uninstalling sql server. It wouldn't uninstall nor can I repair or reinstall. Uninstalling thru Add or Remove ...Show All

• SQL Server SSIS Tutorials: Lesson 1 - missing Customers.xls file

  I can not seem to locate this file any where on my computer let alone in the specified directory. With out this file, it would be very difficult if not impossible to go through rest of the SSIS tutorials. Could I ftp this file from some locations so I could get started on the tutorials. I would very much appreciate any help. Thanks So what of the following path do you have C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\Creating a Basic Package\Sample Data Have you installed the Samples at all The Wizard tutorial seems to have been updated, try - Download details: SQL Server 2005 Samples and Sample Databases (July 2006) ( http://www.microsoft.com/downloads/deta ...Show All

• SQL Server SQL Agent failu "Unable to retrieve steps for job"

  All my Agent jobs suddenly started failing with the error "[000] Unable to retrieve steps for job xxx". There are no other errors in the SQL or Windows logs. I can view the steps in each job using SSMS, even when logged in as the account Agent runs under. The jobs fail whether running as scheduled or if I start the job manually, but the procedures in the jobs still run without errors. The last job ran 2AM Wednesday morning, the next job at 4AM and all subsequent jobs have failed. I have no idea what may have changed on the server especially at that time of the morning. Any ideas A server reboot seems to have cleared up the problem, but I would still be interested in the cause of the prob ...Show All

• Visual Basic IDE Gridlines..

  Hi guys, Just wanna know if its possible to place gridlines on the VS2005 IDE Can you please teach me how Thanks in advance.. Joseph If you are talking about the grid for the IDE Designer. Tools -> Options -> Windows Forms Design -> General Then set the GridSize and ShowGrid properties and restart the IDE. This will show you a grid when in the designer but these will not show on the form at runtime. ...Show All

• .NET Development Time zone conversion problems

  Hi, I'm trying to parse a date time string that is always in ET time zone. The resulting time should be converted to local time. I could do that by backadjusting the ET time and converting to UTC. However, the issue is that I don't know if ET is currently in DST or not, so that I don't know how many hours I have to backadjust. Is there a framework built in way to get the UTC offset for any time zone Thanks, Tom The problem that I'm facing here is that the time I get is in ET. To convert it to local time I need to get the timezone offset from ET to UTC at a specific data (as the offset changes during the course of the year). However, I don't know how I can find out if ET is currently in DST or not ...Show All