AAG's Q&A profile

• SQL Server EXECUTE AS Permissions ???

  HI There I need a little help. I have created a stored procedure that executes when a service broker message is received, this sp then exec's sp_send_dbmail. But i keep getting the error that execute permission is denied on sp_send_dbmail. Fair enough but i have no idea who to grant the execute permissions to The sp is called by the endpoint service of the service broker queue, the sp is owned by dbo who is 'sa', i have tried altering the sp to execute as 'dbo' or as caller, but is still get the same error. I have tried to exec sp_send_dbmail as 'sa' and it works. I do not know under what user this sp executes when the service calls the sp, i also cannot get it to work with an execute as dbo statement even though dbo is ' ...Show All

• SQL Server Problem with Updatable Subscriptions

  Hi all, I have a problem with "Updatable Subscriptions" under concurrent transactions on both pub and sub effecting same data. At high level of concurrency it Subscriber starts giving error msg " Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the Subscriber.".Please tell me any way arround for this. There was also a recent QFE fixed to address a similar issue, but like Gary said, it depends on how frequently you're updating the same data at both ends. The QFE fix will make it into SP2, but if you need the fix immediately, you can call CSS. ...Show All

• Windows Forms How to use the UseWaitCursor Property.

  Hi, I have a process that takes some time and I like to use the UseWaitCursor Property. I enable it in the button click event to show the user a wait cursor till the end of the process. I write it like this : private void Button1_Click(....) { this.UseWaitCursor = true ; ........ } I don't know why but I don't get any wait cursor while the event process. Thanks, David The cursor doesn't change until you move the mouse pointer. At that time, the form must be processing Windows messages to actually turn the cursor into an hourglass. That makes it less than useful, to put it midly. This works without a problem: private void button1_Click(object sender, EventArgs e) { ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. For Admin, Can I Share My New Experience With The Other Users?

  Dear Admin, Can I Share My New Experience With The Other Users In Developing Using XNA GSE By Lessons, "How To" Topics, And Other Experience I Will Gain While Reading And Developing Using XNA Thx http://search.live.com/results.aspx mkt=en-us&q=xna&FORM=TOOLBR ...Show All

• Visual Studio Express Editions Awady Software EasyTrial.dll

  Hey guys I was wondering if any of you have had any luck with the awady software trial.dll that he sells I purchased the thing myself after trying out the demo of it and the demo seemed to work fine but after adding a reference to the actual .dll file I get the following error. Could not find a part of the path 'C:\Documents and Settings\W@RREN\Local Settings\Application Data\Temporary Projects\WindowsApplication1\bin\Debug\Windows\Set{15}'. I contacted the author and I am awaiting his reply but as of now he thinks it is a windows error and not his .dll file I'm confused myself at the moment on this part of the erorr \Windows\Set{15}'. that part of the directory isn't there I dont know why its even looking for it. ...Show All

• Visual Studio Express Editions Why does this give a linkerror

  The following code num1 = GetOperand(); num2 = GetOperand(); result = num1 + num2; Addoperand(result); Gives me this error evaluate.obj : error LNK2019: unresolved external symbol _GetOperand referenced in function _Evaluate Both GetOperand() and Addoperand() is defined in the same file. Why does GetOperand() trigger this link error when Addoperand don't do it Here is the content of the other file static float num[20]; static int pos = 0; int Addoperand( float numarg) { if (pos < 21) { num[pos++] = numarg; return TRUE; } else return FALSE; } float Getoperand() { if (pos > 0) return num[--pos]; else return num[pos]; } ...Show All

• Software Development for Windows Vista Help on wsdcodegen.exe

  I am currently working on Web Services for Device. Can anyone please tell me where I can find this WSD Code Generation tool Thanks ...Show All

• SQL Server RS Install Issue

  Hi, I have looked in numerous places to see if I can find an answer to the issue I am having installing SQL2k5, Reporting Services. My system is Windows 2003 SP1, 64 Bit. The entire 2k5 install proceeds just fine up until RS install. It starts out okay, and gets to a part 'Creating Web Application', and then it fails. I have aspnet 2.07.527 installed. When I press the OK button, the install rolls back the RS pievce and proceeds on through the install. I've uninstalled and reinstalled 10 times thus far, trying different things along the way, gethered from forums. Here's the message I get. Any thoughts would be greatly appreciated. I'm sure I'll eventuially resolve it, I just need to hear some different ideas. Thanks, BPH - ...Show All

• Visual Studio How to add seperator to group menuitems in VSPackage ?

  Hi everyone, Does anyone know how to include a seperator as a sub menu item in VS.NET I tried to change the text to hyphen but it just didn't work. Thank you very much, Pi hi, you can use "-" (hyphen) to add a separator to a sub menu. Just put one hyphen alone, thats all. Regards, Perumal.R ...Show All

• SQL Server Problems Storing Dates

  Hi, I am having problems when storing dates in Sql 2005 from vb.net, I use a SqlCommand like this: Dim xSQL As New SqlCommand(strSave, Conn) xSQL.ExecuteNonQuery() Inside the strSave string there is a DateTime value, all values are stored ok, but the saved date in the SQL server is always 1900-01-01 00:00:00.000 The SQL data type in database is datetime. Any help would be eternally appreciated. Thanks in advance. you probably forgot quotes around your dates take a looks at these two examples, run hem in a query window As you see the first example will be the 1900 date that's because the 9/31/2006 becomes 9 divided by 31 divided by 2006 and the result =0, 0 is the same as a 1900 date Al ...Show All

• SQL Server COLUMN GRAND TOTALS ARE INCORRECT FOR CALCULATED FIELDS IN VIRTUAL CUBE

  Hello, We have migrated some cubes from sqlserver 2000 to 2005 with success. The applicaticon contains one virtual cube made up from 6 other cubes. On the virtual cube level we specified calculated fields. The calculation contains elements from different cubes which shares dimensions. while browsing the cube from within sql server management studio or from excel using OLEDb 9.0 Provider we discovered that the column grand totals for these calculated fields are incorrect. The row grand totals are fine. Searching the internet (google) i have found a hotfix describing the problem SQL MSAS 2005 ( http://support.microsoft.com/kb/918251 ). We have installed this hotfix on top of SP1 but without results. Is somebody familiar with this ...Show All

• Windows Live Developer Forums Localised Versions of VE

  In the online documentation of VE it mentions that it is available in 13 languages. How can you switch so that the maps are showing in another language This means the map place names and not any dashboard text. E.g London will appear as Londres if choosing a French locale etc etc.. (I've notice that google maps just use the local spelling) The VE control is not available in any language other than en-us. Can you point me to the link that says otherwise ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. standalone content pipeline

  Hellow guys! I need to create a ContentPipeline object away from xna framework class Game. Do you know a way to make this thanks! Shinji Microsoft Student Partner There is no coupling between the Game class and the ContentManager: it is totally possible to create one without the other (for instance most of our unit tests for the framework code do exactly that). To use a ContentManager, you have to implement the IGraphicsDeviceService interface, and provide an IServiceProvider implementation that can be used to look up the IGraphicsDeviceService. The link that Joel posted has code that does exactly this. If you're having trouble understanding how that works, maybe you could be a bit more specific about which par ...Show All

• Visual Studio 2008 (Pre-release) One connection and several models

  Hi, I would like to create several models in my application: - People (with all the people related classes/tables) - Orders (with all the orders related classes/tables) - Administration (with all the administrative related classes/tables) - ... Also, I would like to be able to link some objects of People with orders ... It is a question of organization, because in my previous jobs we have build up to 12.000 Business objects and have all in the same model is impossible to manage. Also I would like to have only one "connection" object related to everything. Is it possible Thanks for your help Following up on Cdemez question regarding linking objects from seperate models. How can I create a relationship between ...Show All

• Visual Studio 2008 (Pre-release) Differences between IQueryable and IEnumerable

  Hey guys, how would you describe, what is different and what is similar between IEnumerable<T> and IQueryable<T> interfaces in LINQ context Hello, I have a blog post that covers some of the differences between the two. Please let me know if you need more information or details. http://blogs.msdn.com/erickt/archive/2006/10/23/iqueryable-t-vs-ienumerable-t.aspx Thanks, Erick ...Show All