nmirhan's Q&A profile

• SQL Server WIndows Authenticated linked server

  How do you create a linked server to use windows authentication We want to be able to use user level authentication with Windows Active directory. In other words, we would create a link using 'be made with login's security context', but all logins would be under NT user groups. I've been told that this works in theory, but in practice is very flaky. Why You can define this through sp_addlinkedsrvlogin. e.g. exec sp_addlinkedsrvlogin 'linkedsrv','true' This will require the connected user to use their own credential to access linkedsrv. If you need double hopping, you will have to implement kerberos. http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx ...Show All

• SQL Server The given key was not present in the dictionary

  Hi, When I try to preview a SSRS report in VS 2005 I get the following error: "The given key was not present in the dictionary", however when I deploy the report and view it in the Report Manager all is fine. I have not been able to find any usefull info in MSDN, any one have an idea what I can try Dear , What login did u used while installation of Reporting services and what login used to configure or starting the services. from mohd sufian ...Show All

• Visual Studio Express Editions Filter to form2

  I am brand new to VB Express 2005 and only just getting starting to understand it. Here is my problem. I have two forms connected to a SQL Express database within the project. Table 1 and Form 1 lists the customers Table 2 and Form 2 Lists the email addresses and passwords for each account 1 customer could have up to 30 email addresses. I can get the customers to show on Form1 and all the emails and passwords to show on Form2 with no problem. I can even add a button that opens Form2. What I am trying to do is open form2 and only shows the data that relates to the selected customer. It’s probably very simple but I am a beginner after all ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. ModelProcessor transforming verticies?

  Okay, let me start off by describing what I'm trying to do: For my collision detection, I want to be able to access the verticies of my meshes to store them in octrees. Later on I will use these verticies to make simplified collision geometry (like planes, bounding spheres, bounding boxes, etc). I've created a custom ContentProcessor for my model that sticks the ModelMeshContent.VertexData and indexBuffer into the ModelMeshContent.Tag; then at runtime (loadTime) I step through the VertexData stream and pull out the Verticies and work with them to create my octree. When I use the verticies that I pull from the VertexData to draw simple bounding cubes in the same world space as my original Model is in, the don't line up. The bounding geo ...Show All

• SQL Server Reporting Services - Analysis Services - Displaying Dimension Members as Columns

  I think I've seen a similar post on a blog or on the forums - but it seems like this should be possible - I have an MDX query - that works fine in SQL Enterprise Manager, and has my dimension members on columns, and my measures on the rows. When I try the same query in Reporting Services, I get the error: "The query cannot be prepared: The query must have at least one axis. The first axis of the query should not have multiple hierarchies, nor should it reference any dimension other than the Measures dimension.. Parameter name: mdx (MDXQueryGenerator)" Although it works when you pivot the view, I really need my data presented with the members on the columns and the measures on the rows. Another forum post mentioned using the SQL 9 ...Show All

• Visual Studio Express Editions selecting all items of listview

  is there an easy way to highlight all the items of a listview. thanks for any help. Public Class Form1 Private Sub ToolStripMenuItem1_Click( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles ToolStripMenuItem1.Click ' A pseudo-copy test from a menu item belonging ' to a context menu, assigned to the listview control Dim sel As String = "" For x As Integer = 0 To ListView1.SelectedItems.Count - 1 sel += ListView1.SelectedItems.Item(x).Text & vbCrLf Next ' 'Copyed' items shown in msgbox MsgBox(sel) End Sub ' Use CTRL-A to select all items Priv ...Show All

• SQL Server Check the finish time of data driven subscription using Sql

  How can I check using sql that a data driven subscription has run and the time it had finished Thanks Elias Hello Elias, Run this from the server with the Reporting Services database: select c . name , el . TimeStart , el . TimeEnd , el . TimeDataRetrieval , el . TimeProcessing , el . TimeRendering from ReportServer.dbo.executionlog el inner join ReportServer.dbo. catalog c on el . reportid = c . itemid where c . name = 'ReportName' order by timestart desc Hope this helps. Jarret ...Show All

• Visual Studio running a series of SQL script files

  I would like to know if there's a way to reduce this kind of duplication: <Target Name="RunScripts"> <Execute ConnectionString="$(ConnectionString)" Path="$(DatabaseSourceDirectory)\ScriptOne.sql"/> <Execute ConnectionString="$(ConnectionString)" Path="$(DatabaseSourceDirectory)\ScriptTwo.sql"/> <Execute ConnectionString="$(ConnectionString)" Path="$(DatabaseSourceDirectory)\ScriptThree.sql"/> etc., etc. In other words, I'd like to be able to put JUST the part that changes into a list, and have msbuild iterate over the list, filling out the boilerplate (the repeated part) each time. Is there a clean, simple way to get msbuild to do ...Show All

• Visual Studio Debugger looking for CRT0.C

  Hey guys, When I'm running my debugger, I am getting a strange problem that keeps occuring. If I click run, the debugger follow throughs the whole source code and gives me an access violation of 0xC0000005. If I do a run to cursor, then I am forced by the debugger to provide the location of CRT0.C. The program runs fine without the debugger, just doesnt output the correct results. Would anyone know the reason for that Thanks Robbie It sounds like you have an access violation somewhere in your code. I believe crt0.c is the source for winmain. It's probably where the access violation is being caught. Did you try handling exceptions as they are thrown (Under Debug | Exceptions ... and then pick access violation under Win32 Exc ...Show All

• SQL Server change save settings directory on SSMS 2005

  when i exit sql server management studio i get the following error: The automatically saved settings file '\\SERVER\DATA\Sql Server Management Studio\Settings\CurrentSettings-2006-09-21.vssettings' is not available for write. You can change this file on the 'Import and Export Settings' Tools Options page. i'm guessing this might be because of the corporate policy of pointing everyone's "My Documents" at a read-only folder. i'd like to follow the advice on the dialog but unfortunately my Tools, Options dialog does not have an 'Import and Export Settings' page. any ideas bug raised as https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=208955 ...Show All

• .NET Development WebException: The underlying connection was closed

  Hi After upgrading our win client app to run on version 2.0 of the .net framework (prev. v1.1) on of our customers reports the following error when calling a web service on our server: System.Net.WebException: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. The customer is using a proxy-server, but it worked fine before the upgrade, and other customers who are behind proxy-servers has no problems. The error does not occur when the customer accesses the web service using Internet Explorer. The customer is behind a firewall. /Daniel This has nothing to do with your ISP. Again I also don't have a solution, but w ...Show All

• Visual Basic Where does .NET 2005 store the current Configuration setting?

  I need to know where the IDE stores a solutions current configuration setting, i.e. Debug or Release. It appears to be a solution wide setting, but I could not find anything in the .sln file. A little push in the right direction would be greatly appreciated. Thanks, Josh Hi, There is a My Project folder within your solution. Open this up and click on the Compile tab, this has Configurations in there. You can also click on Build on the menu and Configuration manager. Hope this helps. ...Show All

• Visual Basic Rich Text Box Cursor location

  Hi Guru's, I have a rich text box that i am appending text to all the time, and it ends up turning into a scrolling rich text box which is just great. However i would like it instead of just adding the text to the bottom, also add the cursor position to be with this new added text, so that the user doesnt have to scroll the box down to see the new text that has been added, is this possible Leads me to my second question, i have two functions which add text to this rich text box, Functions A and B is there a way to colour the text from function A to say Red and the text which gets added from Function B to say Blue Thanks in advance for your assistance. Dim MyCursorPosition As Integer ...Show All

• .NET Development diffrence b/w .net 2.0 and .net 3.0?

  what is .net 3.0 frame work hw it is diffrent from .net 2.0 can we install it on windows xp service pack 2 can i install windows work flow foundation on .Net frame Work 2.0 , if yes, where cani download that WF add in.. ...Show All

• SQL Server Problem With the Output of Time Series model

  Hi, I have built a Time Series model to forecast Sales Value. I have used data form Jan 2005 to Sep2006 to train the model. When I write a DMX query to forecast the sales value for next 5 months, it is throwing me the output in the following format. $TIME Sales Value 200610 2874 200611 2875 200612 2874 200613 2874 200614 2874 whereas the output i expected was. $TIME Sales Value 200610 2874 200611 2875 200612 2874 200701 2874 200702 2874 What changes should i make in the model to get the output in the above format. ...Show All