bslim's Q&A profile

• SQL Server DBMS VS RDBMS

  What makes the DBMS being differed from RDBMS. Hello, One referrs explicitly to a relational system (RDBMS), as opposed to perhaps OO etc. Cheers, Rob ...Show All

• SQL Server Select the Greatest/Least

  I have a table that lists information about employment terms for adjunct (class-at-a-time contract) professors. For every term that they teach, they have a record in the database. Two of the fields in these records are ExpectedStartDate and ExpectedEndDate which demark the dates of the term. For example, I might teach in the fall semester: ExpectedStartDate = 9/1/06, ExpectedEndDate = 12/31/06, or I might teach in the spring semester: ExpectedStartDate = 1/1/07, ExpectedEndDate=5/31/07 The report I am trying to create is based on the year, so all terms (amount of terms will vary from person to person) for the year need to be combined into one start and finish period. My report needs to show that my work period was from 9/1/06 to 5/31 ...Show All

• SQL Server manage Security On SSRS 2005

  Hi I asking any one have any good white paper taking about Security on Report manager and how can I manage it as a administrator And if can Impossible Subscription too thanks ...Show All

• SQL Server sp_change_users_login

  I am trying to write a code to check if the username exist in the table before I can use the sp_change_users_login how do I write the condition to check. I am using a cursor. here is the code. Declare @UserName SysName Declare Fix_Cursor Cursor For Select [name] From sysusers Where islogin = 1 and Name not in ( 'dbo' , 'guest' , 'INFORMATION_SCHEMA' ) Open Fix_Cursor Fetch Next From Fix_Cursor Into @UserName While @@Fetch_Status = 0 ----IF EXISTS Begin Print 'Fixing ' + @UserName Exec sp_change_users_login 'auto_fix' , @UserName , null Fetch Next From Fix_Cursor Into @UserName End Close Fix_Cursor Deallocate ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vectors

  Hello, I'm new to vectors and I need to find a way to have the Vector X/Y postions more like a pixel X/Y. Would anyone be able to help me or point me in the right direction The SpriteBatch.Draw method has seven overloads. Three of them require a rectangle (i.e. X,Y, width,height) the sprite to be fitted in, with possibly size scaling. The rest use the output  position as a Vector2 (i.e. X,Y), so the sprite is drawing in a full size. All you need is to declare Vector2 Position, then in your Update method calculate Position as needed and apply it to the overloaded Draw method using Vector2 as a parameter. ...Show All

• Visual Studio 2008 (Pre-release) Can't see System.ServiceModel in Add Reference

  Hi: I've just installed the July CTP of .Net 3.0 and its accompanying SDK. However, when I attempt to Add a reference to System.ServiceModel to a project in VS2005, I do not see System.ServiceModel listed on the .Net tab of the Add Reference dialog. However, the System.ServiceModel is in the GAC. This is happening on 2 machines. Anyone have any idea as to what may be going on here Thanks Lionel Even simpler, install Visual Studio 2005 Extension for WCF (or Orcas, new version of Visual Studio) cf http://www.microsoft.com/downloads/details.aspx familyid=F54F5537-CC86-4BF5-AE44-F5A1E805680D&displaylang=en Cheers. Louis ...Show All

• Visual Basic Task Scheduler COM Object

  Hello, I need to use the Task Scheduler API in a Visual Basic .NET program I am writing and I can't find the COM Library in the Add Reference dialog. What is the Component Name of the library that houses the Task Scheduler API Thanks in Advance. I don't think there is built-in support for that in the .net framework. However, Eduardo Morcillo has made something for that: http://www.mvps.org/emorcillo/en/code/shell/tasksched.shtml ...Show All

• Visual Studio Team System TSD7025: Unable to identify schema type contained in the .sql file.

  Hi, I keep getting these errors from the .sql files I have created in the project. Why is that and what can I do to fix them Example: TSD7025: Unable to identify schema type contained in the .sql file. A schema type of 'ApplicationRole' was expected, based on the name of the .sql file. Regards Fredrik What is the full file name and what is in the file We are using a double file extension system; for example objectname.table.sql indicates that this is a table object; if you would place a CREATE INDEX statement inside a objectname.table.sql; you will get the 7025 error. http://blogs.msdn.com/gertd/archive/2007/01/16/error-amp-warning-groups.aspx -GertD ...Show All

• SQL Server Format Masking for creating leading periods

  Is there an elegant way to fill the empty space leading a textbox in a table with periods, similar to a table of contents effect When I do not allow the textbox to grow and just append a long string of periods it looks fine in my report preview, but after I deploy everything appended after the primary field in that text box is missing My report has a lot of data to the right but it is collapsible so the fields to the left are a good distance away. This is why I am trying to include light visual aids that assist lining up data values. I am not stuck on the leading period idea but it seems the least cluttered. Aaron Hello Aaron, Can you try something like this in your field's expression: =St ...Show All

• Software Development for Windows Vista Side by Side Error

  When i run an application in Vista OS which was compiled in Visual Studio 2005 / WinXP , it is getting the following error: "The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail" What is a recommended procedure to fix it In WinXP or Win2000/ Visual Studio 6, we had VCRedist/ VBRedist which would fix this problem. is there anything available to make my app compatible with Vista OS so that proper files are copied to WinSXS folder in C:\Windows. Regards, RKM. Rosh, Are you using a manifest or embedded manifest in your app Example : < xml version="1.0" encoding="UTF- ...Show All

• Visual C++ Checking whether another instance of the application is running

  Hello, Does anybody know how I can check whether another instance of an application is running or not using VC++ and MFC Thanks. efarook wrote: Thanks for your response. What I was trying to say is that I developed an app using VC++ with MFC. I want to check whether another instance of my app is running or not. Actually I want to prevent running of multiple instance of my app. That's all. See the article linked by Nish, that will help you achieve just that. ...Show All

• Smart Device Development Freeze Columns DataGrid

  Hi, Please, how to freeze the first column DataGrid when moved scrollbar. My application for WinCE.Net 4.2. Thanks Only by using 3rd party data grid with this feature or by writing your own data grid, I'm afraid. ...Show All

• Visual Studio Team System Shouldn't Extraction Rules execute before Validation Rules???

  Somehow I have this nagging feeling I missed something simple somewhere and am asking a stupid question, but I will ask it anyway... I am setting up some tests creating custom extraction rules and custom validation rules. When I set them up for a given web test, they show up in the UI and execute in the order of Validation Rules, then Extraction Rules. It seems to me that it should be the other way around. FYI, I am primarily manually setting up Requests (not using the recording mechanism). Here's what I am doing and expecting: Create the web test. Add a Request to a URL (let's say http://localhost/test/default.aspx ) Add an Extraction Rule (happens to be Custom in my case) to pull out the data in XML format using XSLT and H ...Show All

• Visual Studio Catastrophic Failu Visual Studio Crashing like crazy!!! WHAT IS GOING ON!!!

  I reinstalled my whole damn operating system thinking that I had broken visual studio somehow... it turns out that was a collosal waste of time... I have a fresh clean windows xp pro sp2 install, and a clean Visual Studio Professional... and whenever I add a dataset to a project, and right-click the designer and hit "View Code", I get this horrifying error: Failed to view the validation code because of the following error: Catastrophic failure (Exception from HRESULT: 0x80000FFFF (E_UNEXPECTED) and it gives me a blank document. If I click the button to Save All open documents, the whole damn program just crashes!! I've submitted the error reports, but that's not going to help me fix the problem... what is goi ...Show All

• SQL Server USE MULTIPLE ROLES IN CUBE BROWSING

  Hi, I'm developing a cube browsing aspx application using the OWC11 controls, both Pivot and Chart, associated with Analysis Service on SQL2005. I did quite a bunch of that but now I'm having some troubles to solve the following problem. Using the SSAS IDE, I defined two Roles in a Cube and I defined a filtering function on the dimension in both of them. When I choose each one of them and I check the functionality they works because I can see what I expect to see, only one result from a dimension where the filter is acting in the role definition . But, if I choose both of the roles, and I can do that because it let me select the two checkbox instead of all (having more than two Roles), the filter doesn't work anymore, showing a ...Show All