roypython's Q&A profile

• SQL Server Moving a SQL Server 2000 Database from one server to another advice

  Hi, i was after some advice on moving a SQL Server 2000 database from one server to another. Usually i would do this by backing up the database on the original server the copying it accross the LAN to the new server and restoring it there. This database is 10Gb in size and copying it accross the LAN will take some time and i would like to minimise downtime if possible. The database is at a customer site where i am not responsible for the netw ...Show All

• Visual C++ Mouse Events!

  Hello together! I am sorry, but I am new to Visual C++ and I would like to know how can I react on a mouse click, like a mouseListener in Java. I would also appreciate helpfull links and a few lines example code. Thanks for you help. For what are you trying to catch the mounse event   Is this sort of thing any use _ui_object->MouseClick+=gcnew System::Windows::Forms::MouseEventHandler(this, &a ...Show All

• Visual Studio Intellisense on Visual Studio 2005.

  Can anyone explain how VS 2005 implements intellisense In 2003 (i think) it uses the c# language service and only works on existing code. But in 2005 it can infer a label that has been declared in a webform but hasn't been generated by the asp.net runtime yet, or in the web.config you can create a profile variable and it automatically shows up as a member to the ProfileCommon class Basically, can this feature be extended If for instance i'm int ...Show All

• SQL Server How to find which stored procs and UDFs reference a column

  How can I list the stored procedures and user-defined functions that reference a given column I could search ROUTINE_DEFINITION in INFORMATION_SCHEMA.ROUTINES for '%MyColumnName%' but MyColumnName is not always unique. Thanks. Recreating SPs or altering SPs are costly operations since they will block access to the SP metadata. So you have to probably schedule this during a maintenance window. And if you don't have a mechanism to know wh ...Show All

• Visual Studio Do I need to install SQL Server and Reporting Services locally to create a report server project in VS2005?

  I am using SQL Server 2005 and Studio 2005 to create reports through Reporting Services on SQL Server. This works as intended if I create the projects on the Server, but on my development computer I don't appear to have a way to create any Business Server Projects like I do on the server. Do I need to install Reporting services locally and if so, do I also need to install SQL Server locally I think there must be a better way ...Show All

• Windows Forms How to make minimized application flash in Task Bar?

  Hi, When my application runs, the user sets up some parameters and then they click on "Go". The application minimizes and waits for stuff to happen. It may take several hours before further user interaction is required. When my app has some information to give to the user I want it to remain minimized but to be able to attract the attention of the user so they know they need to do something. I don't want it to un-minimize because the information ...Show All

• Visual Studio T3 template engine

  Is the T3 template engine only avavilable for use with Visual Studio 2005 Is there a DLL available that I could use if say I wanted to use this instead of CodeSmith Also if this DLL is available would it strictly require Whidbey I ask because my team uses macros to spit out some code, such as dataccess code using the Enterprise Library blocks (including correct parameter discovery for stored procs) and I thought the T3 templates would be usefu ...Show All

• Visual Studio Express Editions incompatible types - from 'char [4]' to 'LPCWSTR'

  Hi #include<windows.h> int WINAPI WinMain(HINSTANCE hInstance,HINSTANCE hPrevInstance,LPSTR lpCmdLine,int nCmdShow) { MessageBox(NULL,"test","test",MB_OK); return 0; } a.c .\a.c(4) : warning C4133: 'function' : incompatible types - from 'char [4]' to 'LPCWSTR' .\a.c(4) : warning C4133: 'function' : incompatible types - from 'char [4]' to 'LPCWSTR' how to solve that problem   ...Show All

• SQL Server Can not change filter on model report - UPDATED

    I have a very simple report based on a test model. The report is filtered via a date field and runs ok. If I try to change the filter I get the following error message: Operation Failed Short time pattern does not include hours and minutes Does anyone know how I can correct this Regards John  UPDATE This only happens if I try to filter between two dates, a single date works correctly! ...Show All

• Visual Basic backup the database

  Seriously, I have a VB.Net application working against an Access 2000 database and want to be able to periodically zip and backup the database using Winzip. I cannae find the code to do it, Scotty! Beam me down some information, please! what version of .Net 2.0 has the Compression libraries. I think in 1.1 you can reference the J# compression libraries. there are also a few ZIP libraries out there (written ...Show All

• Visual Studio Team System Branching is Broken - Severe SQL Error

  About two weeks ago I was able to successfully create a feature branch off of our Main\Src directory.  Last night I tried to help a co-worker create a different feature branch off of Main\Src.  We tried from the VS 2005 UI and via the command line with no luck.  Both ran for 15 minutes without completing.  Finally we left the command line branch going all night and when we got back in this morning the following error message ...Show All

• Windows Forms serious big

  I run my program,when i close it , unlucky, there has unknow software exception, it only tell me: .NET -BroadcastEventWindow.1.0.5000.0.3 I am also experiencing the same problem. The error message is displayed after the applcation exits and not as a result of a specific line of code being executed. From my testing it seems to only occur when I use an oleconnection to a database. Unfortunately I am still struggling to resolve ...Show All

• SQL Server IIF driving crazy

  This is driving me crazy… =IIF(Fields!COUNTRY.Value = "United States","US", IIF(Fields!COUNTRY.Value = "UNITED STATES", "US", Fields!COUNTRY.Value)) Is that not correct =Iif(Fields!Country.Value = "United States", "US", Nothing) =Iif(Fields!COUNTRY.Value = "United States", "US") =Iif(Fields!COUNTRY.Value, "misb_db_prp1" = "Un ...Show All

• Visual Studio Express Editions Displaying an image stored as a pointer in a SQL table.

  I am having trouble getting images to display on an application I am trying to build. I have my images stored in a directory and then have a pointer in sql to those files. I want to display the photo associated with the particular record in my windows form but I cannot seem to make it happen. Any advice or code samples would be appreciated. Thanks. Are you having trouble reading the database, or opening an image ...Show All

• Visual C# Question on Localization

  i have another few questions about localization is there any walkthroughs for building a application to be multilingual for .net 2005 beta2. And also what is the best way to update resources from outside the project. I know winres will work to update each form, but how do you compile to a dll from outside the project, because i would like to just ship the exe and reference a dll for resources can this be done . I hope ...Show All