-fej-'s Q&A profile

• SQL Server How to send a report on data change?

  I have this report that uses one table. At some random times during the night this table will be updated. Is there a way to trigger the email report whenever the table changes its data The scenario is the following: This excel spreadsheet has some financial data constantly being updated. Whenever the user thinks the numbers are worth of generating a report (This may happen five or six times per night at completeley random hours) he will push a button on the spreadsheet. This button will pump all its data to a table in an SQL server (This is the table im talking about). I want a report to be sent to a fixed distribution list immediately after the table is updated EVERY single time. Any ideas Thank you, Ivan ...Show All

• SQL Server Users are unable to connect to SQL Server 2005 unless they are in the sysadmin group

  We are running SQL Server 2005 in a Windows 2003 domain and I have a situation where some of my users are unable to connect to the SQL Server unless they are a member of the sysadmin group. Any attempts by these users to login result in a login failed, Error: 18456, Severity: 14, State: 11 Which indicates that it is a valid user who does not have access to this SQL Server. I have been able to narrow the failures down to the following situation: Create a user, TestUser1, as a member of 1 domain local group TestGroup1 Give TestGroup1 access to SQL (standard public access to master) All good. Login succeeds. Add TestUser1 to another domain local group TestGroup2 Attempt to login to SQL Server -> login failed. Add ...Show All

• SQL Server Generate script of ALL database objects

  I need to be able to programatically generate the CREATE scripts for all objects for a given database. Basically, I need the same results as if I generated the script using SSMS and choosing to script all objects in the selected database. I'm hoping I could do this using the Scripter w/in the SMO Utility Classes. Can anyone help me out Thanks in advance! There is a property in the Transfer object named 'FileName'. When you supply this property with a file path the generated script is output to a text file and the 'GO' statements are in the text file. ...Show All

• Visual Studio Team System Upgrade script

  Hi All I am new to VSDBProf and currently assessing it for ourself. New project will be started soon and I am thinking to use DB edition for database source control. Databases for previous projects we were building using our own tool. We keep structure changes, source (st.proc, triggers etc) in VSS. When we need clean database it will create and populated with reference data. Database goes through its evolution: baseline (major version release) created then changes applied for minor releases, one by one. If I need an upgrade I can execute set of scripts from one minor version to another. In that way we have abilility to upgrades and clean installs using the very same scripts. Now I am looking at VSDBProf. It keeps database structure in Sou ...Show All

• Visual Basic SLOW saving record

  I used this below to update a record Me .Validate() Me .EDFBindingSource.EndEdit() Me .EDFTableAdapter.Update( Me .ST102ADataSet.EDF) Me .Button3.Focus() Me .Button4.Enabled = False If I am on my pc where the sql resides, why would it take roughly 6 seconds for the data to be update I know thats how long because the way I have my code, the button doenst become disabled until 6 seconds have elasped. Would I be better off to populate the controls and get ride of the bindingsource, then save changes using hard coding. Davids Learning Hi, how many changed records does your datatable have to update Can you confirm that the Update statement is causing this delay (and not, for ...Show All

• Visual Studio Express Editions Making VB recognize a Dance Dance Revolution dance pad

  Hi there, As a school project, my group has elected to do a version of the popular game Dance Dance Revolution in Visual Basic, since that is the language we are most familiar with. For those who do not know, basically, arrows like the arrow keys move up the screen. You have a dance mat set up similar to the arrow keys on your keyboard; when the moving arrow overlaps an outline at the top of the screen, the user presses the arrow to earn points. Moving on, we would like to attach a Gamecube dance pad to the computer and see if we can get Visual Basic 2005 Express to register it like a controller and react when the player presses buttons, e.g. when they press the "up" arrow the program will register this and react accordingly (this would be ...Show All

• SQL Server Nested IIF's

  I need to evalute two different fields in some text boxes. =IIF(Fields!BadAddressFlg.Value > Nothing , "Red" ,IIF(Fields!BadPhoneFlg.Value <> "G" OR Fields!BadPhoneFlg.Value <> Nothing , "Red" , "Black" )) If the valuefor bad address > nothing or Badphoneflg <> G or <>Nothing then the color needs to change to red, any of these can be true not all of them. I tried the switch, choose, all of them and if I take one of the fields out then I get it to work but I cant get them to work if they are both like this. Thanks Stokh Strange thing. Do you have the chance to send over the sample data (as it is not very much, only those 13). You ...Show All

• Visual Studio Team System How I can find what event subscriptions I have in the TFS?

  And which subscriptions I have to have in order to make TFS function properly I played with EventService.asmx and I believe that I could accidentaly unsubscribe from event with id=1. This Web Service is so poorly developed that it even doesn't let you know the results of operation - maybe nothing happened, but who knows OK. I progressed a little bit further. I found tbl_subscription table in TfsIntegration database which contains all the subscriptions. The subscription #1 is missing. Can somebody help me to restore it I need to find out following fields: event_type and address (the Web Service name - I don't need to know your server :) Help is greatly appreciated! ...Show All

• Windows Forms Displaying Database information in ListView

  I created an address like database with first and last names and include a photo location in the database. Now I want to use ListView to display the photo and name of each row(person) in my database, but I don't know how to retrieve a string from a single cell in my database. can anyone help This article gives you a link to download the northwind database and shows how to install it. ...Show All

• .NET Development Is the framework installed by default with SP2??

  Is the framework installed by default with SP2 Or I have to install it separately Are you sure I haven't found anything around the net telling that the SP2 installs the 1.1 redistributable and I have found several faqs stating that it's not installed with it (using a web download). Regards, Vicente ...Show All

• Visual Studio 2008 (Pre-release) Why does ClientBase Dispose need to throw on faulted state? (Or, what's the difference between close and abort?)

  Could someone enlighten me as to why calling Dispose on a faulted client proxy needs to throw an CommunicationObjectFaultedException instead of just aborting the client   Essentially we have to do this: Client c = new Client(); try {  c.Foo();  c.Close(); } catch (Exception) {  c.Abort();  throw; } Instead of: using(Client c = new Client()) {  c.Foo(); } Yes, I've read the justifications in the SDK and here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=627970&SiteID=1  but the "summary of internal discussion" seems to be "well, that's what we're doing, so deal with it." I still don't understand why Close must throw instead of just, well, closing I know I'm going to have to live with i ...Show All

• SQL Server error with scale-out web server: Invalid object name

  We are adding a second web server to our farm. Reporting Services is installed on one web server as Rpt01 instance and works just fine. We have installed the second web server also with an instance named Rpt01 and are now trying to configure to re-use the same database as the first server. When we restart services we get the error listed below. I was wondering if there was an issue with the same named instances on two different web servers accessing the same ReportServer01 database This is the error that we are getting. Any help would be appreciated. The curious thing is that our databases are named ReportServer01 and ReportServer01TempDB and not the name listed below. ReportingServicesService!schedule!4!1/23/2007-15:40:20:: Unhandle ...Show All

• Visual Studio 2008 (Pre-release) What is System.Windows.Documents.Glyphs?

  There is no information about this class in the documentation. Represents the set of glyphs that are used for rendering fixed text <Page xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" > <StackPanel Background="PowderBlue"> <Glyphs FontUri = "C:\WINDOWS\Fonts\TIMES.TTF" FontRenderingEmSize = "100" StyleSimulations = "BoldSimulation" UnicodeString = "Hello World!" Fill = "Black" OriginX = "100" OriginY = "200" /> </StackPanel> </Page& ...Show All

• Visual C++ memory pane?

  With Visual C++ 6.0, I could view memory via the Memory Pane (as I recall its name...). I'm not finding anything equivalent under Visual Studio 2005. Please tell me that this is still available; I know .NET wants to hide what's going on in real memory from me, but in this particular case, I need to watch a range of memory when debugging. Thanks. ...Show All

• Visual C# Object reference confusion.

  I have a simple function located in Class2.cs - an auxiliary file for Form1.cs (Console Application in VS2005). It take one parameter: string. This string is supposed to serve as a switch for selecting the right string to build. public string getConnStrings ( ref string switched ) In the calling function I call the function in question as: string switched = "1"; string str1 = Class2.getConnStrings (switched); // or (ref switched); I get this error: Error 1 An object reference is required for the nonstatic field, method, or property 'tapTCPports_1.Class2.getConnStrings(ref string)' D:\VCsharp_Projects\tapTCPports_1\Form1.cs 1231 21 tapTCPports_1 When I placed the function getConnStrings into the ...Show All