Chuck Cobb's Q&A profile
SQL Server Timeout expired on Index Creation
I am trying to change the index' on a table I have to create a Clusterd index. When I apply the changes I want I get a message 'SiteData' table - Unable to create index 'IX_SiteControlData'. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The table has around 6M records How do I change the timeout period and what is the default so I can set it back Thanks in advance for the help Thanks, that helps. But it leads to another question. If there is no timeout....why am I getting a timeout error when I try to change my index the actual nessage is: 'SiteControlData' table - Unable to create index 'IX_SiteControlData_SiteID_Calc_Date_Calc_Time'.& ...Show All
SQL Server SP1 for ReportViewer Redistributable?
Hi Everyone. I see that Visual Studio 2005 SP1 is out and includes an updated ReportViewer control. Is there an update to the ReportViewer Redistributable with those same fixes Our product installs this redistributable silently, and we render reports locally (i.e. RDLC), so installing the full Visual Studio service pack would not help us (and installing just the assemblies would not either, since the Redistributable install seems to do other things "under the hood." Thanks for your help! Erik An updated version of the redistributable is going to be available as a separate download soon. You may want to watch the following t ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Dream Build Play - partner in crime
I'm still hard at work on a new game I'm working on, but it's more for fun than anything I would submit for a contest. But I really want to enter the dream, build, play contest too, I just don't think I'll have the time to do it all on my own. Does anyone out there want to partner up I'm no programming guru, but I've got a few skillz. I've been messing with XNA since beta 1, I got one (and a half) xna game(s) under my belt, and I'd say my biggest assets are creativity, thinking outside the box, analytical problem solving, writing, story, plot, characters, and high fives (not necessarily in that order) ...only reply if you plan on winning! Thanks fo ...Show All
Visual Studio 2008 (Pre-release) Weird animation problem
I have an animation which changes the Opacity of my LayoutRoot form 0 to 100 in 1.5 seconds. This animation is set to run when the when the loaded event of a window is fired. The effect I am after is that after my window is shown then it will gradually become active. The problem I am seeing is that the animation does not seem to be occuring correctly. The window gets created, which takes a couple of seconds, to show and then the window is displayed without a delay. After the window is displayed I can call the same animation from a button and the animation appears correctly. I can also set the animation to a longer amount of time like 8 seconds and then I get the desired effect but it does not seem to take the entire 8 seconds. To me it se ...Show All
Smart Device Development how to know whether a Registry key is exist?
how to know whether a Registry key is exist for example RegistryKey rk = Registry.LocalMachine.OpenSubKey("Software\\myTestKey", true ); if myTestKey is not exist, I want to create it, and set some values to it. if myTestKey is exist, I want to read values from it. How to code with c# .net cf. Thank you. Check the return value of OpenSubKey() (as stored in rk) to see if it is null... if it is use CreateSubKey() to create the key as it does not already exist. Does this work for you ...Show All
SQL Server Wish List - Package Logs
Because packages are not edited in msdb, there exists a chance that I might not always remember to re-import a modified package. So I would like to include "something" in the package that would write the date last changed of the package to the package log. Do you have any suggestions that I could use now I tried the Script example in BOL and it did not write anything to the package log. When the log entry is written for each step, include the elapsed time since the package started. While the csv format is now the default, is it possible to have any other format I seem to remember in DTS there were some messages that were displayed in Name:Value pairs. Sometimes this is more helpful and requires less horizonal scrolling. Thanks, ...Show All
SQL Server distinct count
Hi I have a table which stores the shift information for employees. The table contains 10 columns as Employeename,Employeeno,month,year,shifttimings etc. If an employee works a day in a particular shift, then a row will be inserted in to the above table for that employee. Now at the end of the month i wanted to calculate the shift details for each employee for a particular month of a given year like employeename,employeeno, noofdays(countof shiftdays). Can some body help Thanks in Advance! Santhosh You could create a view as Select EmployeeName, EmployeeNo, Month, Year, Count(*) As NoOfDays From EmployeeShift Group By EmployeeName, EmployeeNo, Month, Year and apply Where to it... ...Show All
Visual Studio Express Editions stuck newbie - exporting dll functions to vba ?
Hi, Please bear with me, I'm totally new to C++, although am reasonably proficient in VB and VBA. Anyway, I have some VBA Excel user-defined functions that take a long time to run, so want to speed them up by transferring them into a dll and then importing the function to VBA so that they run in compiled rather than interpreted code. Apparently I can't do this in VB Express, but can in VC++ Express That's where I'm stuck... I've set up a new project, Win32 Console App, application type Console App (the DLL box wasn't selectable). In the project properties, I've selected configuration type dll. I have two files in my project: BMIPDll.h which reads: // BMIPDll.h namespace BMIP { class BMIPFunctions { ...Show All
SQL Server SQL 2000 Maintenance Plan failure
I have 3 maintenance plans inplace One to backup our 3 production databases, master, model, msdb, one to backup the log files of our production databases and one to optimize our production databases. The backup plans are set to delete old backup 3 or more days old When the plans were first put into place they worked correctly. Lately (month or 2), the backup plans have not been working correctly. When I first noticed the problem, 1. I saw the the drive I'm putting the backups on was almost out of space and 2 the delete part of the backup was not deleting backups more than 3 days old. When I deleted the old backups, the plans worked as normal until the hd became full again. I have 2 questions. 1. When does the "Delete&qu ...Show All
Visual Studio Express Editions no visual studio template found
I just installed the recently released Visual C# 2005 Express. When i tried to create a new project. I got this error message "no visual studio template found". I went to the "event viewer" in "Administrative Tools" to see the log. I found the message : "The Visual Studio template information is out of date. Regenerate the templates by running 'VWDExpress /installvstemplates' or reinstalling Visual Studio. Note: corrective action requires Administrator privileges. " I reinstalled the VC# but the problem is still there. Anyone met this problem before Sorry, folks. Figured out how to work around this problem. For those uninitiated as myself: 1. Open command prompt START --> ACCESORIES ...Show All
SQL Server Bulk Insert from Mapped Network Drive
Hi, I am trying to perform bulk insert using mapped network drive, but getting following error: Server: Msg 4861, Level 16, State 1, Line 1 Could not bulk insert because file ' F:\Download\MVY.b45 ' could not be opened. Operating system error code 5(Access is denied.). F is mapped network drive pointing to my SQL Database Server. While searching, i got the following link but not able to relate with my problem: http://support.microsoft.com/default.aspx scid=kb;en-us;238238 One exe is running on component server [CTom] and copying the data file to mapped drive (i.e. F:\), then bulk insert is trying to insert from that mapped drive. Any idea/suggestion would be of great help Though this only applies if Kerberos is ...Show All
Visual Studio Express Editions fatal error LNK1104:cannot open file 'user32.lib'
hallo, i got this error after building my source code: fatal error LNK1104:cannot open file 'user32.lib' i've seen a similar thread but i still can't solve the problem. I folowed all the instructions from the video on installing the PSDK. What can i do Pliz help!! Sorry for the two long posts, but for anyone who'd like to help me figure this out, here is the environment portion of the build log: __COMPAT_LAYER=RunAsAdmin _ACP_ATLPROV=C:\Program Files (x86)\Microsoft Visual Studio 8\VC\Bin\ATLProv.dll _ACP_INCLUDE=C:\Program Files\Microsoft SDKs\Windows\v6.0\Include;C:\Program Files\Microsoft SDKs\Windows\v6.0\Include\gl;C:\Program Files (x86)\Microsoft Visual Studio 8\VC\inc ...Show All
Visual Basic Call a VB 2005 DLL from VB .NET 2003
I have an executable program written in Visual Basic 2003. I now have a DLL written in Visual Basic 2005. How do I call the 2005 DLL from the 2003 EXE I have tried Reflection and simply CreateObject. Even tried to create a reference. All attempts told me that the DLL was invalid. Help please Rory The solution with the .config file will only work when you run the executable directly from the OS. You won't be able to debug this executable from VS2003(aka play/run button) because the VS2003 debugger expects and uses the 1.1 Framework, and the config file specifies that it should be using the 2.0 Framework. If you don't add the config file, then the 1.1 Framework is loaded, in which case you c ...Show All
Visual FoxPro How to calculate the data connection time?
I tried to add 2 fields, time_on, datetime, time_off, datetime to calculate user's log on time in the Users.dbf. How do I calculate the total time between the 2 value Any better way to capture users' activity You may create a clock like: http://support.microsoft.com/kb/139390 and start it when user log on ... ...Show All
Game Technologies: DirectX, XNA, XACT, etc. XNA Wiki Project
Me and a few friends have started a XNA Wiki project for the community...please stop by and contribute any expertise you can lend to make this a good source for the community for quick reference to everything from theories, to simple and easy to understand documentation on XNA. We're hard at work this week expanding the XNA section. If you have a XNA tutorial or community website, please be sure to drop a link off on the page too! CodeGeeks XNA Wiki Project Thanks, there isnt a lot there right now, and I think a lot of that has to do with the overall general lack of knowledge of the framework still...but I do believe that after a few months, more people will start to post, and any new developers that crop ...Show All