Sweeps78's Q&A profile
Visual Studio Express Editions Can't seem to change opacity of window
In this code: http://nomorepasting.com/paste.php pasteID=74503 I'm trying to simply change the opacity of any window. But that doesn't seem to be working. Anyone know what I'm doing wrong and/or how to get this to work I'm not talking about changing the opacity on the forms my app spawns, thats easy, but any other window, like mIRC, or internet explorer. ...Show All
SQL Server Connections through a server alias, IP address, or any other alternate name are not supported.
Hi I am trying to connect to another sql server in my company using the IP address for exmp. : 111.111.1.1\SQL2005 but it show this message: Connections through a server alias, IP address, or any other alternate name are not supported. it was working well on SQL2000 Please help Hi Ziad, Can you explain what you did exactly did you create the following: 1-create alisan name : mysecondserver 2-port: by default empty , you need to specify the port in case you have firewall issue. 3-protocol: TCP/IP or other.. 4-server: IP\instance_name NB: to be sure about server name on the second server select @@servername in query window on the second server. If you still cannot connect ...Show All
SQL Server Database files free space (SQL Server 2005)
Dear friends I need to report the amount of free space in each datafile of a database. I have tried sys.dm_db_file_space_usage , but the documentation says that it only works for the TempDB. Please help. Regards Parviz Here's some code, cribbed from a sqldbatips report designed to mimic the taskpad in SSMS. ( http://sqlblogcasts.com/blogs/sqldbatips/archive/2006/11/21/custom-ssms-reports-in-sp2-enterprise-manager-taskpad-view.aspx ). All I did was add some code to show the amount free. Seems to work well. Posting here because this was one of the top results in Google when I went looking for code myself. create table #data ( Fileid int NOT NULL, [FileGroup] int NOT N ...Show All
Visual Basic Loops to type
How can you use a loop to make it appear that the computer is typing one letter at a time I am trying to create an example which will show the user how to use a "wild card" with a text box. The I would like the computer to "type" each charachter at a time, that way it looks like it is being typed at about 20 WPM. "T" 1 second "Te" .5 seconds "Tex" .4 seconds "Text" ...Show All
Game Technologies: DirectX, XNA, XACT, etc. How to draw an arc between two points
Im trying to make an application in C# to draw an Visio Drawing. The problem is that I dont know how to implement the ElipticalArc statement in the .vdx file. Is there a way to draw an eliptical arc between two points and thru a control point with direct3d Yetti helped me to solve the problem in a math forum. http://www.mathlinks.ro/Forum/viewtopic.php p=644880#644880 ...Show All
Visual Studio error MSB4018: The "GenerateResource" task failed unexpectedly
I have a Smart Device application that is generating the following errror when I attempt to build. I would appreciate any feedback in how to debug this error, or what might be a typical cause of this problem. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.Common.targets(1616,9): error MSB4018: The "GenerateResource" task failed unexpectedly. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.Common.targets(1616,9): error MSB4018: System.InvalidOperationException: Collection was modified; enumeration operation may not execute. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.Common.targets(1616,9): error MSB4018: at Microsoft.Build.Shared.ExceptionHandling.RethrowUnlessFileIO(Exception e) C:\WINDO ...Show All
SQL Server The "fastest" way to load string data
I need to load a lot of data into a sql table as fast as possible. (All data is string data, CSV file). I have read that the "fastest" way to load data is using the "Fast Load" option of the OLEDB Destination but I have also read that the "SQL Server" Destination is fast. 1. Is there a general consensus as to which way is the quicksest load 2. The file is a CSV file. Would a fixed-format file be faster to read TIA, barkingdog Also be sure to read our whitepapers: http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/ssisperfstrat.mspx And perhaps this webcast will h ...Show All
.NET Development What method can be used to get the list of all the attributes present in a class in C#
What method can be used to get the list of all the attributes present in a class in C# System.ComponentModel.TypeDescriptor.GetAttributes() ...Show All
Visual Studio Team System Version control of dbschema DBPro vs Team Explorer
Hi If I as a DBA use DBPro for doing checkin checkout operations, how should the developers that don't have DBPro do the check in check out of the files they need We are impleting Team System as the version control system. Should they use team explorer (I believe this is how it's called the free add-on to be able to check out and check in all files in Team System). Thanks jegar wrote: Hi If I as a DBA use DBPro for doing checkin checkout operations, how should the developers that don't have DBPro do the check in check out of the files they need We are impleting Team System as the version control system. Should they use team explorer (I believe this is how it's called the f ...Show All
Visual Studio Team System Failed When I execute Build Team Project
Hi All, After I created a new Team Build Type and executed Build Team Project and I got the Report Summary : Failed Build Steps: Initializong build: Failed Failed. Please help me how to find the reason why it failed and how to fix the problems. Thanks, Ptn715 Thanks DQM, it worked now. I'm very appreciate with your and Patrick Carnahan's help Ptn715 ...Show All
SQL Server mdx filter problem
I have the following calculated member, which give me a certain type of billing info. CREATE MEMBER CURRENTCUBE .[MEASURES].[CTP format billing] AS aggregate ([PREP CONTROL HDR].[Bill Formats].&[19],[Measures].[Billed Sales Amount]), FORMAT_STRING = "Currency" , VISIBLE = 1 ; i use this in a set to filter out those Accounts/customers with a zero dollar amount. There may be a record in the cube with a zero dollar amount that I wish to filter out. CREATE SET CURRENTCUBE .[customers with CTP billing] AS FILTER ( DESCENDANTS ([CUSTOMER JOB].[By Cust-Title-Job]. CURRENTMEMBER , [Customer Name]),([Job Complete Date].[Calendar Full]. CURRENTMEMBER ,[Measures].[CTP format billing]) > 0 ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Save As for an entire project?
Greetings! When I create a new project in MS Visual C# Express, a full set of folders (bin, obj, Properties) and files are created. I'd like to be able to "source" my projects, but can't figure how to use Save As so that Express will create new folders and files using whats currently open, just with a new name. Hope that makes sense. Thanks! You have a few options, but the easiest would be what Jim said. Anytime you want to version your code, just navigate out to the folder above your project, CTRL-CLICK, DRAG and RELEASE the folder. Rename the copy to comply with your naming standards for versioning and go back to work on the original. All done. Other, more complex options, include ...Show All
Visual C++ About this Forum
I read the heading of this forum, which says " General questions about Visual C++ 2005, including the development environment, libraries, setup, debugger , samples, and documentation." Seeing the word "debugger," I asked a couple questions about the VS2005 debugger, and they were both moved to a debugging forum. In which case, I wonder why the word "debugger" is part of the description of this forum. Anyway, the questions being moved wouldn't be so bad, except that nobody has answered my questions on the much lower traffic debugger forum. The questions can be found here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=658102&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=654161& ...Show All
SQL Server New Install of Sql server Express fails to restore Master database
Hello, I have a fresh install of sqlExpress and Management Studio Express on my test server. I want to restore my master database from backup. From the command prompt I set the Sqlservr -s SQLEXPRESS -m Then I opened another comand prompt and ran my SQLCMD script to restore the Master Database. here is the sql script: RESTORE DATABASE [Master] FROM DISK = N'E:\COPLEYNEWSDATABASEBACKUP\Master.bak' WITH FILE = 1, MOVE N'mastlog' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Master_1.ldf', NOUNLOAD, STATS = 10 GO I recieve the following error. Msg 3154, Level 16, State 4, Server COPLEYNEWS\SQLEXPRESS, Line 1 The backup set holds a backup of a database other than the existing 'Master' dat abase. Msg 3013, Level 16, ...Show All
Visual Basic Waiting for form input
Hi, I have a section of code which is updating a number of tables with processed details. This works fine, but i now need to add 2 additional pieces of informtion which i had hoped to have entered by using a popup screen with a combo box and a textbox in which the user enters the data and when the OK is clicked, it returns the value back to another form which processes it. the problem lies in the fact that this data is required in the middle of a loop and this loop lies within another! What would be great is to just freeze the code while this other window is open and then resume once the user closes it. Any help is greatly appreciated. Fantastic - Thanks for your prompt help :-D I was used ...Show All
