Mark Crouse's Q&A profile

• SQL Server selecting data between servers

  Hello, I am using SQL2K5 and I am trying to select data from a database on Server A and insert the data to a database on Server B, using management studio. Does anyone know how to write this query. I keep getting an error expecting a linked server. Is there an easier way to do this I am avoiding SSIS for the time being, because my recent experiences with it was not good, so as a consequense I want to create a script to accomplish this task. Thank you for your time, David You can use OPENROWSET or you can create a linked server or bcp out and bcp in Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All

• SQL Server wmi error

  Am running a SQL Server 2005 Ent IA64, 2 node (active/active) cluster on Windows 2003 Server Ent with SP1 IA64. Everything working ok, but everytime I launch the SQL Server 2005 Management Studio, the following is logged in the Application Log: also all was ok until I ran the remote debugger wizard in visual sutdio. There were no errors prior to this. I did not select anything, open the wizard, click next and finish, I did not select anything. Event Type: Error Event Source: WinMgmt Event Category: None Event ID: 10 Date: 04.06.2006 Time: 07:32:04 User: N/A Description: Event filter with query "select * from __InstanceModificationEvent within 10 where TargetInstance isa 'Win32_Service'" could not be (re)activated in namespace &q ...Show All

• Visual C++ Wizard problem

  I tried to use VC++ 2005 Express, and when trying to start a new Win32 console application a wizard appears, but it doesnt do anything. I modified the thing in line 441 to 445 in the sdk file, but nothing happens. Those numbers remind me of the editing of "\Microsoft Visual Studio 8\VC\VCWizards\AppWiz\Generic\Application\html\1033\AppSettings.htm", which you need to edit when  integrating the PSDK into VC++ Express . Most likely, FlyFox_B1 has edited the AppSettings.htm file incorrectly (isn't it lines 441- 444 You're supposed to leave line 445 alone). If that file gets corrupted, the File -> New Project will cease to work, and that's exactly the problem FlyFox_B1 is seeing. ...Show All

• Visual Studio Team System mssccprj.scc file question..

  Good day, I thought I was successful in my conversion of data from VSS to TFS - I analyzed the data, migrated the data, opened the .sln files using VS2005 and ran through the conversion wizard - all of this without errors. When I compare 'mssccprj.scc' files for the same project in an old environment using VSS and a new environment using TFS and VS2005 the files are identical. When I check which source provider I'm using in VS2005 - it lists the desired TFS server and all files are listed as 'Connected' with a 'Valid' Status again to the TFS server. Am I missing something, shouldn’t there be a difference in either the 'scc_aux_path' or 'scc_project_name' string Any assistance would be great. Thank you. ...Show All

• Visual C++ Combine multiple IDL files into one typelibrary

  I have a visual studio 2005 C++ project that has a bunch of IDL files. My ultimate goal is to combine all those IDLs into one TLB. Is this hard to do The reason is that we want just a single file our other projects can include to access to everything, rather than having like 10 separate TLBs... Anyone have experience with this 1. Comment out all library definitions in your idl files. 2. Create new master IDL file and import all your other idl files using the 'import' keyword. 3. Create new library definition in the master IDL file and copy and paste into it all your coclass definitions (from your commented out library defintions) into the new library defintion. If the IDL compiler complains about interfaces forward decla ...Show All

• SQL Server How can I shrink SQL Express database on local machines?

  Hello, I have deployed a vb.net application to a few laptops that holds the SQL Express database as a local datastore. What is the best way to compress or shrink the database and log files I would like a way that this can be done automatically or unattended if possible... Thanks in advance. Ah thanks AlexB ... I thought I was the only one. I will take a look at the links you provided me. Regards, Rashar ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Legacy audio content

  Is it just me, or is there no way to use legacy audio content in XNA It doesn't appear there is a way to load .wav files into the pipeline. I'm trying to load .wav files out of an old prepackaged format and I can get everything else to import into the pipeline using custom importers... I wasn't aware of that, but it was just an argument... :) I'm trying to port the Quake 2 engine to XNA, and the problem I have is that there's no way to get the sounds into the engine without bursting the pak files and adding the sounds to an XACT project. The goal is to not distribute id's copyrighted levels AND not require the end user to build the audio resources themselves. There needs to be a content importer than can c ...Show All

• Visual Studio Team System Single-server installation Sql connectivity issue

  We have a single server installation of team foundation server that had been working great. Yesterday the SQL server 2005 instance was changed in the surface area configuration tool to allow only local connections. It seems this should work since they are both on the same machine, but an error is logged now for the work item tracking web service that it is unable to connect to the SQL server. How can we allow the SQL server to be set to local only and get TFS to be able to connect to the DB again. The odd thing is that the source control hasn't stopped working, only the web services. Thanks Thanks Vic, Is this fix going to be included in a future service pack only, or will there be a hotfix we ca ...Show All

• Visual Basic Convert VB struct to LPBYTE

  Hello evrebody. I'm trying to use the Setjob API within my vb.net project but I don't reach to pass my JOB_INFO structure to the API. So my question is : How to convert a VB structure to a LPBYTE I use this declaration : Public Declare Auto Function SetJob Lib "winspool.drv" ( ByVal hPrinter As IntPtr, ByVal JobId As Int32, ByVal Level As Int32, ByVal pJob As IntPtr, ByVal Command As Int32) As Boolean and Structure JOB_INFO_2 Public PrinterJobId As Integer Public pPrinterName As Integer Public PrinterName As Integer Public PrinterUserName As Integer Public PrinterDocument As Integer Public PrinterNotifyName As Integer Public PrinterDatatype As Integer Publi ...Show All

• Microsoft ISV Community Center Forums Run Time Error 9 when Calling a Userform

  Hi folks, I am getting a run time error # 9 when I run a macro that calls a Userform or when I try to run code in a Userform module. The code performs beautifully on my computer, but it did not work on a coworker's computer. It ended up working on 3 out of the 5 computers I have tried it on. I have tried changing security settings to low, and a bunch of other stuff, but I cannot get the code to run on the computers that get the run time error on them when I try running the code on them. I get the run time error when I try to load or show any userform in the workbook and I get it if I try to run code that is in the userform module. However, if I paste the code into a regular module and run it, the code runs fine. Does anyone know what co ...Show All

• SQL Server SSIS "does not exist at the source" bug fixed in SP1?

  As I wait for 250 odd MB of SP1 to download, can anyone tell me if this annoying import/export bug has been fixed in SP1 Or if they added back in the "transfer objects" option to the Import/Export wizard I need to create and copy several databases worth of SQL 2005 tables/views/procedures/etc. to a shared hosting environment where I can not be a sysadmin or use Windows authentication and which is still running SQL 2000. Having created a package in SSIS to do what I want, I get this dreaded error on the first table before it fails: Table "BusAccess" does not exist at the source. If I use the simple Import/Export wizard, I lose all my keys, indexes, etc. I no longer have the T-SQL scripts used to create these objects, so the only op ...Show All

• .NET Development CodeDom: How to declare var & assign to indexedProp of Shared Obj

  Hi, I'm doing some codedom work and am wondering what syntax I need to write in order declare a variable and assign it to a static objec'ts property so that the emitted code is in one line. I can use the codeDom to output what I need in two lines-- but that's not what i want. ie: Output I want: ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings[connConfigKey]; Output I get: System.Configuration.ConnectionStringSettings settings; settings = ConfigurationManager.ConnectionStrings[connConfigKey]; The code that produces the above: private void CreateVarDeclAndAssigntoStaticStaticIndexObjProp(KeyValuePair<string, Type> var) { this._methodObject.Statements.Add(new CodeVariableDeclarationStatement ...Show All

• Visual Studio Express Editions how to add a doc file as message body to ms outlook

  i am using the following code to open outlook and compose a mail theStringBuilder.Append( "mailto:someone@somewhere.com" ) theStringBuilder.Append( "&subject=my subject" ) theStringBuilder.Append( "&body=my body message" ) theStringBuilder.Append( "&attach= C:\myfile.ext" ) System.Diagnostics.Process.Start(theStringBuilder.ToString()) but i require to send a .doc file as the message body to the outlook can any one help me how to solve this problem I have a similar problem. I can understand the issue with the attachment, however, the question of whether one can take the text from a word document and insert it as the email text still remains unclear... ...Show All

• Smart Device Development Targeting the different device with existing pocket pc application

  Hi, I developed an application for Pocket Pc2003. I want to target to Treo700WX. But Generally I get only 5 devices in the list (in "Deploy" window) when I use F5 to deploy and debug. Treo700WX is already added to All platforms menu(Tools-->Options-->devices--> All platforms). Can anyone tell me how to target the Treo700WX or any other device with my present developed application.. Thanks in Advance, While creating the applications you will have to select for the supported platform. You might not have selected TREO as a supported platform when creating project. -Thanks, Mohit ...Show All

• SQL Server Dropping an auto numbered primary key and add a new one

  The table I am using have a column called Key which is the primary key of the table and a auto number. This primary key is not a foreign key in any other table. I need to write SQL to drop the current primary key and add a new one Say "RecordId" as the new primary key and which should be a autonumber too. any idea. thanks in advance What's the point It is easy enough, just drop the column and add another one, but there might be an easier way to do what you are wanting to do. Here is a script that does it: set nocount on drop table test go create table test ( testId int identity constraint PKtest primary key, value datetime default (getdate()) ) insert into test default val ...Show All