e-wrench's Q&A profile

• SQL Server logging DDL Stmts

  Hi : The database i am using is SQL Express. I am using .cmd files to execute .sql files. sqlcmd is used in .cmd files to execute the .sql stmts. In .cmd file the sqlcmd line of code is as follows: sqlcmd -i .\..\..\sql\tables\create_employee_table.sql In .sql file the ddl stmt is as follows: CREATE TABLE [Employee]( [EmployeeID] [int] IDENTITY(1,1) NOT NULL, [NationalIDNumber] [nvarchar](15) COLLATE Latin1_General_CS_AI NOT NULL, [ContactID] [int] NOT NULL, [LoginID] [nvarchar](256) COLLATE Latin1_General_CS_AI NOT NULL, [ManagerID] [int] NULL, DF_Employee_rowguid] DEFAULT (newid()), [ModifiedDate] [datetime] NOT NU ...Show All

• Visual Studio Team System Deleting Source Control

  How the heck do you delete items from Source Control (Source Control Explorer) if there is no Project associated to them If I right click on the node, select Delete, I get the error message: "TF10169: Unsupported pending change attempted on team project folder $/Test.  Use the Project Creation Wizard in Team Explorer to create a project or the DeleteTeamProject tool to delete one." I've used the DeleteTeamProject tool to delete the project but I still have the source control files out there. If you are still seeing the team project in your source control explorer, chances are that you had pend ...Show All

• Visual Basic VB express edition with odbc connection

  I want to connct through odbc in express edition .........can any one help me Hi. I have been successful in using ODBC connections in VB2003, and VB2005. But I do it all using codes. Meaning, if you want a databound system, you will have to bind it programmatically, not on the Design View. You may have to use this: Imports System.Data.Odbc All the resources are revealed on this namespace ...Show All

• Visual Studio Team System Can't access to the documents

  Hi, I can't access the documents tree. There is no permissions problem (I can view the sharepoint site via browser, but not in team explorer). Thanks, Michael The URL used to access the SharePoint site is stored as an absolute URL (i.e., with protocol, port number and machine name) in TFS Registration data. The first thing to check is that the URL that is specified in the registration data actually works from the client machine. Log on to your TFS application tier machine and browse to http://<server>:8080/services/v1.0/registration.asmx Click on GetRegistrationEntries and Invoke the method with no parameter ...Show All

• Windows Forms tab control + validation

  Hi there,  I am using a TabControl with 5 tabs. Is it possible to disable some of the tabs and make  them available i.e. if the application is connected to the  server Also I was wondering if there is something similar like the  validation controls on webforms for the winforms as well. I am using VS .Net 2003 and C# Thanks a lot for your help.&nb ...Show All

• Smart Device Development Save a datarow to a new table.

  Ok so I have a dataset and a few tables in it. what I want to do is take a row from the original table and save it to a new table. What i have done is declared a new datatable, declared a new datarow. set the values in the new datarow to equal the values in the row from the original table. Then newdatatable.addrow(newrow). All i get is "This row already belongs to another table." So my question is how do I save a row from a datatable to a different datatable ...Show All

• SQL Server RS2000 on multiple websites, customize look and feel, turn off admin

  I'm brand new to SSRS and just installed RS2000. I have seen numerous posts/articles about how to set up RS2000 on the non-default website, but haven't been able to figure out if you can install it on multiple websites on the same server. Here's my situation: we have multiple clients who run our software on the same server. Each client has their own db and their own website in IIS. I'd like to provide each client with access to reports through their own website that report on their own database. Is this possible at all From what I'm finding, I don't think it is (it seems SSRS can only be installed on one site), but figured I would ask t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectShow forums available

  We are pleased to announce that the new DirectShow forums are up and running! Please direct any DirectShow questions you might have to here . ...Show All

• SQL Server Password field (very important)

  A collegue from me used the MySQL database before (I haven't done this before). He asked me, if it is possible to store a MD5 hash in a cell. He telled me that MySQL has got a special function wich computes the hash value. Can someone help me Thanks for help Sorry for my bad writing. I've forgotten to ask, whether it is possible to make this with the MSSQL. ...Show All

• Visual Studio Express Editions ListView Woes

  I am creating an Archive directory project and have run into a problem with my listview. I am populating a listView with a directory listing of directories withing a selected directory. I am doing this so that users may select those directories they want archived and leave the rest alone. Here is the code I am using to generate my listView textBox2.Text = "" ; listView2.Clear(); // Create a new ListView control. //listView1.Bounds = new Rectangle(new Point(309, 33), new Size(163, 256)); // Set the view to show details. listView2.View = View .Details; // Allow the user to edit item text. listView2.LabelEdit = ...Show All

• SQL Server Login Failure with Linked Server

  Hi, I have both NT authentication on the two servers, and I'm getting the following error when I try to execute the statement: select * from Main1a.GondorMain.dbo.bds Error Message: Server: Msg 18452, Level 14, State 1, Line 1 Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Any system SPROC that I could check to verify what's causing the error Any help is appreciated! -Lawrence Please take a look at the following resources: http://support.microsoft.com/default.aspx scid=kb;en-us;326839 http://support.microsoft.com/default.aspx scid=kb;en-us;306212 ...Show All

• Windows Forms TabIndexChanged event not firing? (VB.NET 2003)

  I have a form with a tab control with 3 tabs on it, and a button. Clicking the button changes the selectedIndex of the tab control, which is then SUPPOSED to fire a function through the "TabIndexChanged" event. This event doesnt' fire. To see this in action build a form described as above, and add this code:     Private Sub Button1_Clic ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. seting objects look at position

  all my mesh objects when created are save in a position that when there loaded you see the front of them, to get these objects to move/face in the right direction I use 2 vector3 kinda how my camera is set up a lookat point(direction) and a eye point(position), when I draw them what should I use for the rotation matrix if I use my lookat vector with rotationyawpitchroll the mesh rotates when I change its lookat but the pitch is all messed up, if I use rotate axis the mesh never turns any help would be great thanks I usually store my position and rotation data in a similar fashion. In OnFrame ...Show All

• Visual Studio Team System Can't back up WSS content database since migration to RTM

  When I try to backup my TFS databases, I'm getting an error: System.Data.SqlClient.SqlError: The backup of the file of filegroup "sysft_ix_STS_server_#_####" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. Apparently the full-text indexes on the WSS content database have been lost/deleted/corrupted/ by something that happened during the migration to RTM. Any ideas what I might be able to do to re-create the full-text indexes for the WSS content database I had the same issue: This was my fix :-) ...Show All

• Visual Basic Drawing images to a picture box?

  I'm trying to draw multiple images to one picture box (for a map editor) so that I can save the picture created as a file. I've been looking around but I can't find any help on it, so I'm posting here. It uses ONE picture box for the map and you can load one tile at a time, so I can load from the filename, from a hidden picture box, whatever I need to do. Thanks for everyone's help. well, the image gets redrawn when ever it's needed.  (from the paint event arg) To remove a tile, all you'd really have to do it remove it from your bitmap arraylist, and call the paint event code again do have it redraw (and without the tile this time ...Show All