swathi_challa's Q&A profile

• SQL Server How to recover from dropped tempdb?

  I am testing sql server 2005 in different disaster situations happened under 2000. I was reading a lot about no update on system tables, so: sp_detach_db 'tempdb' In sql 2000 i could issue something like the following command to recover: use master sp_configure 'allow updates' , 1 reconfigure with override go insert sys.sysdatabases ( name , dbid , sid , mode , status , status2 , crdate , reserved , category , cmptlevel , filename , version ) values ( 'tempdb' , 2 , 0x01 , 0 , 8 , 1090520064 , '2007-01-27 13:03:10.873' , '1900-01-01 00:00:00.000' , 0 , '90' , 'D:\beep\mssql\temp\tempdb.mdf' , 611 ) go sp_configure 'allow updates' , 0 rec ...Show All

• Visual C# help with structs and arrays

  Hello, I'm something of a C# neophyte, and I have the following problem. I'm trying to set up two arrays inside a struct: public struct Person { public int[] second; public int[,] response; } Then I want to declare the arrays, second = new int[actionwidth]; response = new int[actionwidth,actionwidth]; but then I get an error saying that response and second "do not exist in the current context". I presume this is because response and second are in the scope of Person. How can I declare these arrays Thanks for any advice. Thanks for the lightning quick response. I implemented your suggestion: public struct Person ...Show All

• Software Development for Windows Vista Sate machine workflow

  Hi, I have a simple state machine workflow with three states. I would like to put a timeout on the final state.(ie final state approver didn't approves this within the specified time, the state should go back to previous state). Is there any way to implement this thanks -Abraham Abraham - since each state can have multiple eventdriven activities - the way to implement this is to add an additional eventdriven to your final state - and then have a delay activity as the first activity inside of that eventdriven. ...Show All

• SQL Server Property AnsiNullsStatus is not available for UserDefinedFunction

  I created a table valued function in SQL Server 2000 SP3 using SQL 2005 Management Studio, but when I try to edit it (Right-Click, Modify or Script Function As...) I get the following error: Property AnsiNullsStatus is not available for UserDefinedFunction '[dbo].[fnMyTDF]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo) I can edit it in other tools (Sql Query Analyzer) just fine. I'm in the sysadmin role. Versions: Microsoft SQL Server Management Studio 9.00.2047.00 Microsoft Analysis Services Client Tools 2005.090.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Release of XNA Game Studio Express

  Could we have more information about the releashe time In witch time zone I will wait until midnight GMT -5. Should a go sleep before and wait until tomorow Jim Perry wrote: If you're really dedicated you'll stay up until you have it downloaded, installed, and made a game. If only some of us were that good at game programming. personally I put off learning DX9 for the last couple of weeks, I am just learning, for XNA and have just been reading up on theory and looking ahead in my physics class. ...Show All

• Windows Forms How can we add advance search/filter capabilities to a DataGridView???

  Hi! I would like to use an Advanced search dialog in order to provide the final user with advance searching capabilities in my DataGridView...For example to select only those customers names (from the Customer column) that live in a certain city (from the city column)... The BindingSource.Filter method doesn't support this capability...Any help Thanks in advance... Hi Fox3, This following code works for me. I just learned from MSDN. http://msdn2.microsoft.com/en-us/library/ya3sah92.aspx { // Create the connection string, data adapter and data table. SqlConnection connectionString3 = new SqlConnection ( "Password=; user id=sa provider=SQLOLEDB; Initial Catalog=MAINTENANCE;&quo ...Show All

• Visual Studio Issue with Trial Crystal Reports XI Release 2 + ASP.NET Application (VB.NET)

  I have a asp.net application written in vb.net. I recently downloaded a trial version of Crystal Reports XI Release 2 and created a number of test reports. On my local development machine, I can open and use these reports. The problem is that when I move my app and the reports to the web server running Windows 2003 I am getting the following error: CrystalDecisions.CrystalReports.Engine.InternalException: Failed to open the connection. Details: [Database Vendor Code: 17 ] Failed to open the connection. C:\WINDOWS\TEMP\rptMessages {D859C1D2-06C5-4B49-9251-DC5A537900E1}.rpt Details: [Database Vendor Code: 17 ] ---> System.Runtime.InteropServices.COMException (0x800002F4): Failed to open the connection. Details: [Database Vendor ...Show All

• .NET Development Threadpool Issue with WaitHandle.WaitAll FatalExecutionEngineError

  I have a process that goes out to each machine on the network and executes a few WMI calls. In the case that there is an error it takes about 5 seconds before it continues forward. 5 Seconds X 3000 Computers is more time that I have available. So, I have been messing around with ThreadPools. My thought is that I will kick off the WMI calls for 10 different machines then wait for them all to return. This way it only takes 5 seconds for each group of 10 machines. I have been using the Fibonacci Example to come up with the test code below but on my WaitHandle.WaitAll I am getting a FatalExecutionEngineError: Error: FatalExecutionEngineError was detected Message: The runtime has encountered a fatal error. The add ...Show All

• SQL Server Time of last table write

  Greetings. Can TSQL be used to retrieve the date and time of the last time a table was written to Thanks. alan Alan: TSQL can be used to retrieve this information IF your tables are constructed support this kind of activity.  We typically keep (1) create_user, (2) create_DT, (3) mod_user, (4) mod_DT as standard data elements of our tables.  These columns are updated by trigger whenever a record is inserted or updated.  If your tables do not retain this type of information you might want to consider adding it.  Understand that this does add some overhead; however, there are times in which this information is a quite valuable. Dave ...Show All

• Visual Studio 2008 (Pre-release) M:N Relationships

  Where (link, samples) can i find documentation about implement a M:N relationship I supoose that i need an intermediate table, isnt it Something Like that ... A(IdA, ......) Key = IdA B(IdB,.......) Key =IdB AB(IdA,IdB) Key = IdA,IdB Ive had read "Hand-On Lab Visual Basic document" and page 5 says "DLINQ allows uou to express 1-to-1 and 1-to-many rel. using EntytyRef and EntySet types" ok What about M:N Thanks.And sorry if this question is available in the doc. but i couldnt find it M:N relationships are more a factor of relational data than object oriented. Since LINQ works primiarily in the object space and maps to the relational store, it only works on the 1:N model. For M:N, you need to work with a nested 1 ...Show All

• .NET Development Is there a way to Redirect STDOUT/STDERR during AppDomain.ExecuteAssembly like Process.Start's redirection streams

  I'm trying to locate the ability to redirect the stdout/stderr within an AppDomain when making calls to the ExecuteAssembly method similar to the ability to do so with Process.Start's RedirectStandardError/ RedirectStandardOutput Thanks, Ty thank you for responding. I was assuming that just about everything that does gui or in/out of any kind eventually goes into unmanaged code (even though its MS OS code). So, I assumed that AppDomain handled the unmanaged/managed code transitions. I think I am understanding what you are saying though as far as redirection is concerned. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. GraphicsStream.InternalDataPointer null?

  Good day, We are creating a texture from a bitmap region using an unsafe section in C#, but occasionally the InternalDataPointer for the GraphicsStream's returned from Texture.LockRectangle will be null. Following are the relevant lines: Texture texture = new Texture (device, bitmap.Width, bitmap.Height, 1, Usage .Dynamic, Format .A8R8G8B8, Pool .Default); int pitch; GraphicsStream graphicsStream = texture.LockRectangle(0, LockFlags .None, out pitch); unsafe { byte * to = ( byte *)graphicsStream.InternalDataPointer; ... It is a multi-threaded app, but to our knowledge no other thread acts on these members. What could cause a null InternalDataPointer Thanks in advance... ...Show All

• SQL Server Recursive Call -- Joins etc... I'm really confused

  Hi, Firstly, I would admit that I am not an SQL expert. I know SQL but can't write complex queries... for about optimizing the queries. Ok... coming to my query: I have a structure of a tree as follows: TABLE TreeNode { NodeID int IDENTITY(1,1) ParentNodeID int NULL } CONSTRAINTS: PrimaryKey: NodeID ForeignKey: ParentNodeID REFERENCES NodeID I am using this simple structure to define a tree. All the entries with a ParentNodeid = NULL indicate the root of the tree so that I can define multiple trees. Now, given a NodeID, I want all rows that are a part of tree. For example, if I have a structure like: root(id=3) |--> child, id = 4 |--> child, id = 5 |--> child, id=1 |--> child, id=2 |-- ...Show All

• Windows Forms DataGridView Datasource property

  ArrayList Ips=c1.getIPs(); dataGridView1.DataSource = Ips; The getIps returns an arraylist with count 1 the content of arraylist 0th element is 'Pencil'. but in grid its displaying the length of string i.e 6 rather than displaying Pencil.What should i do to display the content of arraylist rather than the length. regards To solve the issue what i have done is i picked up data from arraylist and stored it into the datatable object. c1.registerServer( this .getHostName()); ArrayList Ips=c1.getIPs(); DataTable dt = new DataTable (); dt.Columns.Add( "UserID" ); DataRow dr; int i = 0; while (i < Ips.Count) { dr = dt.NewRow(); dr[ "UserID" ] = I ...Show All

• Visual Studio Project Size

  We have a few websites that we want to upload on source safe, but we are worried about the size of source safe database getting too big. We have about 10 projects to upload to source safe, there are 4 websites, 1 web control library, 1 wondows form app, and 4 class libraries. The class libraries are referenced in all of the websites and windows form app and all the websites reference the web control library. What would be the best way to upload all our projects onto source safe We are thinking about combining some of the class libraries with the website projects to decrease the number of projects we upload on source safe. Are there any known issues with source safe and the number of projects uploaded on it ...Show All