steve brsk's Q&A profile

• SQL Server Saving scripting setting

  Hi,   In SQL Sever Management Studio:   Is it possible to save the scripting setting (in Database -> Tasks - > Generate Scripts) for future use   If not, I think it is a useful feature to add.   ...Show All

• SQL Server Standard compliant

  Hi, SQL Server 2005 is compliant to which standard Ansi92 / partially ANSI 99, ISO HI, SQL2k5 is ANSI99 compliant. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio How to pass parameters in Msbuild

  Hi, I want to automate my task of getting latest version, building the solution, obfuscation and then making setup files..so for making setup file i want to pass paramenters for giving the version number of the new setup. I want to give paramenters when I am running msbuild through command prompt. So plese tell me how to do that..... Thanks!!! I have the requirement of passing the parameters for the msbuild. i am using msbuild <solutionname> /t:rebuild /p:configuration=release It is generating the publish dlls, but my intention is to generate the separate dlls for all pages. I think this c ...Show All

• Windows Live Developer Forums Access Denied?

  I've been playing around with using the MetaWeblog API to make a little front end app in C# for posting my blog entries and various other functions the API supports. Recently I've been getting nothing but Access Denied errors. Is it possible that Spaces has locked me out of my account due to too many password errors or something and if so how does one go about getting it unlocked I have verified my username and password and I was using the wrong one for a while but now I'm certain it is correct and I'm still getting the Access Denied (3001) errors. I know it's not my app because I'm getting them with w.bloggar now too whi ...Show All

• Smart Device Development PocketPC client, Web Services and security.

  Not sure if this is the best forum for this question so feel free to point me in the right direction. I have a Mobility application client that communicates with a Web Service. I would like to have at least a minimum level of security with this. I am not concern about someone reading the data going in and out, what I want to make sure is that it's my actual client code that's attemting to access the Web Service and no one else. Does anyone one have some thoughts on this and what are some of the things I should be reading up on Thanks Not sure which of the following two cases is what you want: ...Show All

• SQL Server SSIS server agent

  How can I setup an SSIS package so that it will generate a report and email (html version) everytime upon completing/populating my datareaderdest Assuming that you're talking about a SQL Server Reporting Services report, you would want to set up the report scheduling and generation and delivery on the Reporting Services side, and merely designate your Integration Services package as the data source. Please see the BOL topic, " Retrieving Package Data from SQL Server Integration Services." If you're talking about a different type of report, such as a spreadsheet file, you can add a SendMail task after the data ...Show All

• .NET Development Connecting to SQl 2005

  Hi, I have built an application in C#, using VS.Net 2003 and .net framework 1.1. i am trying to connect it to a SQL2005 database, which is held on another machine within the same network. I keep getting an error reporting that the sql database does not exist or can be not accessed. The connection string is OK. Do I need to install .net framework 2 on my local m/c, or is there something else which I need and if so what Thanks Jason Network access to SQL Server 2005 is blocked by default at two places on the server box: TCP/IP support. Open the SQL Server Configuration Manager and enable TCP/IP . You may also open t ...Show All

• Visual C++ Image Color Management in VC++ 8 Platform SDK

  I'm converting a VC++ 6 MFC app to VC++ 8 using Visual Studio 2005 Standard. The existing app uses Image Color Management, so it #include's icm.h. In the VC++ 6 environment, it is included from the Platform SDK [$(ProgramFiles)Microsoft SDK\include] directory. A Visual Studio .Net installation delivers a version of the Platform SDK in a subdirectory of the VC directory [$(VCInstallDir)PlatformSDK] and this directory is setup to be used for includes upon install. However, icm.h is not included in this version of the Platform SDK delivered with Visual Studio 2005. The file does exist in both VS2002 and VS2003 installations. Was this ommi ...Show All

• Visual Studio Express Editions BindingSource.Find by operator LIKE

  How to find a letter begins them string with operator LIKE and object BINDINGSOURCE The following code does not work : Dim sString As String sString = "Like 'C*'" Dim foundIndex As Integer = Me .DATI_BindingSource.Find( "Cognome" , sString) If foundIndex > -1 Then DATI_BindingSource.Position = foundIndex Else MessageBox.Show( "Nessun nomimativo con questa lettera iniziale." , "GSL" , MessageBoxButtons.OK, MessageBoxIcon.Information) End If Thanks and ........excuse my imperfect English language. ...Show All

• SQL Server How to print

  I've searched this forum and seen several mentions of client-side printing.  However, when I access a report through Report Manager, I see no button/icon for printing   So, the question remains for me:  Aside from the browsers print command, how does one print reports without exporting and printing the exported file More specifically, you will need RS 2000 SP2 installed. You can download and get more information here: http://www.microsoft.com/downloads/details.aspx FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en -- Robert ...Show All

• SQL Server Management studio enhancements

  Hi, sorry about posting this here, msdn feedback is currently down. There are 5 enhancements that I would like to suggest for Management Studio: 1. Option to have tabs (such as Object Explorer, Registered Servers...) auto display only on click and not on mouse move. 2. As per sql 2000, allow user to return Top X from a table in the Object Explorer tab (i.e. from: Server > Databases > [database] > Tables > Right Click on table > Open Table > Return Top) 3. Option to save scripts as Unicode. Sometimes saved scripts have unrecognized linefeeds/carriage returns when viewing the .sql in a text viewer. This can b ...Show All

• Windows Forms Outlook Calendar Look and Feel - Corrupts Form Designer

  I added the CalendarLibrary project (Outlook Calendar Look and Feel) to my solution.  First I encountered the Serialization problem and used the fix listed here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=167334&SiteID=1 I add a reference from my VB project to the CalendarLibrary project, add a new form to my VB project and drag and drop the Calendar control onto the form.  When I build the solution I get this error: One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. ...Show All

• SQL Server Using returned values from one SP in another

  Hi all, I have a SP that needs to return a record set based upon the values of calling another SP. The 2nd SP uses the output parameter and works fine. However, the resulting Insert doesnt see the value. I cannot for the life of me work out why not! My other question is how do I stop the imbedded procedures from outputing a result When the procedure is run in analyser it produces three sets of data. The first two being the outputs for the two SPs. Any help would be much appreciated! Code as follows: CREATE PROCEDURE [dbo].[trl_GetOpenDurations] AS --- CALLS the sp trl_CallOpenDuration with the following params ---1 min minu ...Show All

• SQL Server DBMail permission error

  I am using DBMail to send an email notification at the completion of service broker process and have been getting the following security error: Msg 229, Level 14, State 5, Procedure sp_send_dbmail, Line 1 EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb', schema 'dbo'. I have given the userID used to run the Service Broker, databasemailuserrole in msdb as per instruction in the msdb. I have also given it execute permission on the sp_send_dbmail but keep getting the error. The service broker is run using a sql login and the dbmail profile is set as public profile. Any suggestions would be much appreciated. ...Show All

• Software Development for Windows Vista Calling the DDI from a User-Mod Component

  Hi, I was wondering if it is possible to call MoComp functions from user mode component such as a custom filter. According to http://download.microsoft.com/download/1/6/1/161ba512-40e2-4cc9-843a-923143f3456c/VMR%20Deinterlacing_v85.doc this should be possible, but I saw on one of the forums that it was not. Could you please clarify on this issue. If it is possible, could you please provide an example on how to do that, I am interested particularly on how to fill the data structures passed as parameters. Thank You. ...Show All