sql dev's Q&A profile

• Visual Studio Team System How to use code coverage over manual test?

  Is there any tutorials or references on using the code coverage over manual test I would like to manual test my program and then obtain the code coverage report. I have a lots of UI so I don't have any unit test program written. Actually, I am not sure how to do the unit test properly. Please advise. Regards, Alex Here is a post with the info you seek: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=694921&SiteID=1 ...Show All

• Visual C++ how to form a avi or wmv file

  Hi I am working on a project about screen capturing. I came cross a problem when I can get the screen and put the DIB into the memory. the project request that the software must get 15 frames/minute and form a avi or wmv file . Now , I just can get 5 frames/minute using the GDI . I must improve my method of screen capturing and I don`t know how to form a avi or wmv file , If anyone can give any advices about the problem , it will be a grateful thing. data is just the screen . I get some ideal from my colleague that I can get the data from GPU by using HOOK ,but I don`t hava a sample or some embody advice; ...Show All

• Visual Studio How to debug a Class

  I want to debug a class, more specifically functions that I have in my class. I know that I can create a little app and reference my class and call the functions like that, but I was wondering if there is a general tool that I can provide a set of parameters into and get output from it... Thanks. One can get Nunit here . Here are the steps to get going with NUnit: Install Nunit to your computer. Create a Library Assembly and add it to your solution. Working in that library, reference the Nunit Framwork and your assemblies. For that assembly project only change the Debug setting found in Start Action to Start External Program . Browse to the nunit-gui.exe. Setup a class which looks like this: using NUnit.Framework; nam ...Show All

• SQL Server Standalone models and local install of Report Builder

  Is there any way to take an existing model(s) out of the SSRS framework, and load both the model(s) and a local copy of Report Builder on to an unattached laptop and then have it function for designing a report In other words, the pc is not able to network with the SSRS server, but you still want to be able to design a report. ...Show All

• Visual Studio Express Editions Create Array Control like on vb 6 ?

  Hello all, i have question about the array control on vb.net 2005 How to create the array control like on vb.2005 and we create it on design not on code. for example if i use the vb6 : if we have two object or more and have the same of name its will creating the index for otomatically. And this idea do try on vb.net 2005 but it not create index control for otomatically. How to handdle this problem It detects that this code is hooked up to the following events by the handles clause- so in this case it shows button1.click, button2.click and button3.click Private Sub Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click, Button2.Click, Button3.Click    ...Show All

• .NET Development FileSystemWatcher: how do you keep FSW running in a C++ app without an infinite loop?

  I have a program that checks for changes in a log file and performs actions on it. The only problem is that I have to have this line while(1); at the end of my program or else it closes out and does nothing! Unfortunately, the infinite loop causes 50% CPU load. Actually, I'm not sure if it is FSW or the loop itself that is causing the load. Is there any way around this Its the while(1) statement. You could fix it like this: while(1) { System.Threading.Thread.Sleep(1000); } I assume you are using a console mode application to require this loop. Consider a service or Windows Forms application with perhaps a NotifyIcon in the tray instead... ...Show All

• SQL Server Stored Procedure : Create Table with parameter ?

  first of all hi all, my problem is, i want to create a table which name from my parameter what should i do here my code CREATE PROCEDURE ProcedureName -- Add the parameters for the stored procedure here @ype nvarchar ( 15 ) AS BEGIN SET NOCOUNT ON ; CREATE TABLE [dbo] . [@ype] ( [TeklifEM] [bigint] NOT NULL, [Cinsi] [nvarchar] ( 50 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Adet] [int] NULL, [Birim] [nchar] ( 10 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BirimFiyat] [money] NULL, [ToplamFiyat] [money] NULL, [TeklifId] [bigint] NULL, CONSTRAINT [PK_ype] PRIMARY KEY CLUSTERED ( [TeklifEM] ASC ) WITH ( IGNORE_DUP_KEY = OFF ) ON [PRIM ...Show All

• SQL Server Looking for suggestion of how to manage a DB file when it getting too big.

  Hi all, At our facility, we have a > 350 gigs database and the DB is breaking into 2 files. One file is our Image table with the size of 300 gigs. The other file contains all of the other tables. The image file is getting bigger and bigger everyday, I am worry that eventually when a data file getting too big it could lead into problem. - DB fragmentatio, hard to manage etc My question is anyone has run into this problem, and how do you solve it I am open for any suggestion. BTW: I am using SQL 2000. Thanks in advance. Rajeev, My problem is I can't reduce the size of my image db, I can't archive (at least in SQL 2000) I can't partition my table either and I don't want my data file growing too big. So spliting a si ...Show All

• SQL Server User Rights

  I'm running into an issue with a user with restricted rights being able to access a local SDF file. The user has Modify right to the folder (and the file), but cannot access the SDF if it was created by someone else. The only two workarounds I've found are: 1) If the I delete the SDF and then the restricted user creates the SDF they can then access it. 2) If I grant Full Control to the folder then the restricted user can access the database. Is this by design Are there programatic changes that can be made to enable access All users who login to the box (Windows XP) need to be able to access the same SDF. The SDF is stored on the local machine. Thanks,rlw... Again, remember that the SQLCe datab ...Show All

• Visual Studio MSBuild fails to rebuild a resource-only project with no culture-neutral resources

  Hello, Our daily build failed on a couple of projects, and after some tests I managed to reproduce a failure on a simple samle. Strage enough, it only fails when MSBuild is executed from command-line - not from within Visual Studio (I thought VS does the same). Here are the steps to reproduce the problem: 1. Create a C# class library project, accept all defaults. 2. Remove all C# from the project (both Class1.cs and AssemblyInfo.cs from the Properties folder). 3. Add a resource table by selecting Add -> New Item -> Resource File. 4. Now make your resource file culture-specific by renaming it from Resource1.resx to Resource1.en-GB.resx. 5. Delete from the project Resource1.en-GB.Designer.cs 6. Remove all reference ...Show All

• Visual Studio Team System Web.Config Version Control?

  I am trying to find the best way to go about this. Right now our ASP.Net 1.1 project is under version control TFS. When we added the project our team used a web.config that is specific to the integration server, however, there are values that are specific to ones local development environment. Editing and saving the file requires one to check it out of version control and we would like to prevent this from happening, as we would to prevent our developers from "accidentally" overwriting the file. Am I making a mountain out of a mole hill here Part of me feels like I am but I would like someone else's opinion. Thanks in advance...   Hi, I have the same pr ...Show All

• Internet Explorer Development Drag from desktop to IE, what's in the javascript dataTransfer object?

  Hello all, I've noticed that you can drag files from your desktop into IE and it will open the file. I'm developing a web application in asp.net and using JavaScript for the client scripting. My goal is to allow the user to drag a file from their desktop (or windows explorer) into my web page and initiate some sort of asp.net file upload based on the file that they drag. When I drag the file from my desktop into IE, all drag/drop enabled web elements recognize that a drag is happening and they also fire the drop event. When I do an alert(); on the dataTransfer event argument, it says "object" in the dialog which leads me to believe that the object is created. What I can't figure out is how to find out what is inside of the ...Show All

• SQL Server Business Intelligence Development Studio Installation doesn't work

  Hello, I have just tried to install (among other things) BIDS, and have found it hasn't worked. I tried it once over an old SQL Server 2005 Express Edition installation, and that failed, so I followed the advice of others and removed it. In fact I removed everything I could find to do with SQL Server 2005, and started right from the beginning (restarted after removing everything). My steps were: 1) Install SQL Express with Advanced Services (SQLEXPR_ADV.EXE, 240 MB, downloaded today from http://msdn.microsoft.com/vstudio/express/sql/download/ ). Choose to install all components, with default options. Restart when complete. 2) Install SQL Express Tools (SQLEXPR_TOOLKIT.EXE, 218 MB, dowloaded today from http://msdn.microsoft.com/vst ...Show All

• Visual Studio Team System How can I get files that are changed from time I get version from Source Control

  subj In TFS you download files using the "get" command (at least in 99% of the cases ;) - http://msdn2.microsoft.com/en-us/library/fx7sdeyf.aspx It's not clear if you want only a list of files that were changed (/preview flag in get command) or download them to your workspace (get with optional paramters). Hope this helps ...Show All

• Windows Forms Datagridview image column

  Hi all, I have been trying to get this code to work to no avail The code below I believe should put an image into a datagridview image column , but I could be wrong.. I tried to use byteArrayToImage(e.value) but all it says is systems.drawing.bitmap - it's not giving bytes, it's giving a string. What do you reckon I'm missing to return the byte array Private Sub dgvUsers_CellFormatting( ByVal sender As Object , ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles dgvUsers.CellFormatting Dim _cell As DataGridViewCell = New DataGridViewImageCell If e.ColumnIndex = 1 Then dgvUsers.Columns(e.ColumnIndex).ValueType = GetType (System.Drawing.Bitmap) _cell.ValueType = GetTy ...Show All