nextpaco's Q&A profile

• SQL Server SQLAGENT CAN't START

  SQLAGENT CAN't START this log: SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role). I am receiving the same error. For some odd reason my sqlserveragent will not start. I am using a domain accoutn that does have access to sysadmin on sql server 2005. were you able to get this running. ...Show All

• SQL Server Disable excel rendering from export button

  I have around 7 subreports in one main report. The data displays fine as required but when I try to export it to excell format it gives me an error saying that "Subreports within table/martix cells are ignored" . I know this is a known error and Microsoft would be releasing a fix for it in future releases(I hope in SP2 :-)). As per our requirement we have to store each report in excell format in our DB. Because of this problem we came to a conclusion to hide the excell format from the export button so that the user can select PDF insted of Excel. My question is : How do I disable the Excel format on the export button. Thanks Jarret for the reply. My concern is , if I do either one of the two options provided t ...Show All

• Windows Forms Form 1 being updated by form 2

  Hi, VB question, using SQL Express and VS Express. My Form1 examines some data (SQL DB) and displays summary information on the screen. Form 2 (called from form 1) allows editing of the data. Each time the database is updated in Form2, I call a public method in Form 1 to refresh the screen data. This method seems to execute properly - variables behave as expected but no changes are reflected on the screen. Labels and combobox contents are unchanged. If I execute the same method again, with Form2 closed, everything works fine. I have tried a me.refresh() to no avail. Rich ...Show All

• Community Chat I lost My Pictures

  Hi there, I wonder if anyone is kind enough to lend me a hand. When I was rearranging My Documents, I carelessly deleted the My Pictures folder. Since then the My Documents folder has no more the My Pictures folder. I wonder how can I do to regain the My Pictures folder in the My Documents folder. Many thanks Michael Yeah, do as little as possible on the machine, get a copy of something like norton and see if you can recover the files. The more stuff you've done on your machine since deleting them from recycle - the less likely you are to be able to recover them. Either way this is not a support forum for your Windows issues. I would advise reading the details on what the intended pur ...Show All

• Visual C# C# and Preprocessor macro

  hello, i'm a newbie with C# and i'd like to Preprocessor macro like I do with my C compiler how can I do that is it possible example #define STEP1 0x01 #define STEP2 0x02 void Function(int Choice) { switch(Choice) { case STEP1 : break; case STEP2: break; } } you can't use C# preprocessor directive as the ones in C++, you can use it to include or exclude codes from compilation on a certain codition example #if debug // Some code #elif release //Some other code #else //some other code #endif ...Show All

• SharePoint Products and Technologies Why take long time to open WSS site?

  Hi, When first time to open WSS site, it always takes long time to open, Why Any way could improve this issue and how Thanks for any advice! Angi Henry, Thanks so much! I've implemented this issue and work very well! Also, I implement this function on Reporting Services to "Warm Up" Report Manager! It's so cool! Thanks so much! :) Angi ...Show All

• .NET Development Deserialize XML that uses "False" instead of "false"

  I need to deserialize a XML file generated by a third-party software. However, this software uses Boolean "False" instead of "false" and I get an exception when i deserialize it. "The string 'False' is not a valid Boolean value." How can i get the deserializer to recongise "False" as boolean Can someone point me in the right direction Thanks ...Show All

• Visual C++ OnShutdown() method does not work !

  Hi all experts, I am using VS Pro 2005 and Win XP Pro. I have developed a C++ Window Service to detect the shutdown event and perform some tasks before desktop shutdown. I have followed the MSDN instruction and assigned CanShutdown to TRUE. However, I found that OnShutdown() method is not being called. Could anyone please help me Many Thanks The following sample codes are attached for your reference: =============================== virtual void ABCWS::ABCWSWinService::OnShutdown() override { ServiceStatusLog->WriteEntry("ABC Shutdown"); } void InitializeComponent(void) { .. this->CanShutdown = true; .. } =============================== ...Show All

• Visual Studio Express Editions How to permenantly delete all data in my .mdb database?

  Hi, How to permenantly delete all data in my .mdb database through a button click event Thanks.   Ans For: How to permenantly delete all data in my .mdb database through a button click event OleDbCommand theCommand = new OleDbCommand("DELETE FROM tableName ", new OleDbConnection( connectionString )); theCommand.Connection.Open(); int theRowsAffected = theCommand.ExecuteNonQuery(); theCommand.Connection.Close(); MessageBox.Show(theRowsAffected.ToString()); By ahmedilyas ---------------------------------------------------------------------------------------------------- Ans For: Can the primary key of my table be reset to 0 when all data are deleted & How come the reset of the autonumber is ...Show All

• SQL Server Index usage statistics report

  Has any body else had this problem. In SQL Server Management Studio in the report tab when I choose Index Usage Statistics all I get is just these messages and no info at all. Is this a bug. It does tell me the name of the database. Index Usage Statistics Shows how the users and system use the indexes. Index Operational Statistics shows details of the no. of operations performed on the indexes You might try a DMV query, such as this to get useful index info -- Possible bad Indexes (writes > reads) DECLARE @dbid int SELECT @dbid = db_id() SELECT 'Table Name' = object_name(s.object_id), 'Index Name' =i.name, i.index_id, 'Total Writes' = user_updates, 'Total Reads' = user_seeks + user_ ...Show All

• Visual Studio Problem with sandcastle config file

  hii there.. i just installed the new version of sandcastle (november) and right now it won't work anymore even when i try it from the command line.. there is an error message when im using the buildassembler program, it said that it can't find the syntaxgenerators.dll and looking at the sandcastle directory there no such file. Can someone give me an example of the config file for the new version.. thanks hi, the syntaxgenerator.dll was renamed to SyntaxComponents.dll. Kind regards, Stephan Smetsers ...Show All

• .NET Development Increasing Memory Usage in .NET 1.1 (Very Urgent)

  Hi, I've developed a dummy WinForm application (named GCTest) with the following functionality in .NET 1.1 (VS2003): 1. In Button1 click, a text is assigned to a Label. 2. In Button2 click, i've called GC.Collect(). While running this app, without doing anything, the memory usage is increasing from 10KB to 100KB. If i'm moving mouse, resizing, minimizing or maximizing the window, the memory usage is increasing consistently 60KB. If i click Button2, then memory usage increased upto 100KB. My machine config: PIV 3.2GHz, 1GB RAM .NET Version: 1.1.4322.2032 (i.e with service pack 1) OS: XP SP2 How can i stop the increase memory usage problem Regards, Udooz ...Show All

• Visual Studio Team System <ALLOWEXISTINGVALUE> not valid for System.Reason

  Can anyone explain why <ALLOWEXISTINGVALUE> is not allowed for System.Reason. I would think this is just an ordinary string field. Thanks. Here is the section of one of my WorkItem types that has the new field and the WorkFlow. I also use GlobalLists alot so I included these also. Hope this helps. < FIELD name = " DashReason " refname = " Nowcom.Dash.Reason " type = " String " > < WHEN field = " System.State " value = " Active " > < DEFAULT from = " value " value = " New " /> < REQUIRED /> < ALLOWEDVALUES > < GLOBALLIST name = " Bug.Rea ...Show All

• Software Development for Windows Vista Problem with ICredentialProviderSamples

  Hi I got the ICredentialProvider samples from MSDN and I having a strange problem. I modified the sampleCredentialProvider example, to request username and password If there is no user loged on, the CPUS_LOGON scenario, I'm able to login. If the scenario is CPUS_UNLOCK_WORKSTATION I'm unable to logon, I'm using the same account, and the procedures for both scenarios are the same. The error I get is "Username or password invalid" I was able to check the values of the strings via a MessageBox and are OK. The non modified by me version also haves the same problem What could be wrong Thanks in advance It looks like you're using the Beta2 version of the samples. Here's the link to ...Show All

• SQL Server Excel destination fails

  Hi All! I am trying to create a table destination to excel which fails with the following error that " Table cannot be created " System Error in Field definition" where as the same works in the Falt File Destination. What could be the problem Thanks jas It maybe due to the fact that excel has in built data types and column sizes attached to the columns whereas a flat file does not have that. Try creating a table first and then map the excel columns to it to extract the records from the excel spreadsheet. When you import into a staging table, it is best to just keep the columns as varchar(255). If you have fields like remarks field that could be even bigger, you might w ...Show All