thalion99's Q&A profile

• SQL Server SSIS Performance

  I am currently in the process of migrating DTS packages to SSIS. I am finding that most of the packages are running faster, but some of them are taking longer to execute. The DTS package copies data from our Production server to Development. It uses a Copy SQL Server Objects Task to copy only the data from about 50 tables. This takes about 3.5 minutes. I created the exact same package in SSIS using the Transfer SQL Server Objects Task and it is running about 5 minutes. Another package I am having this problem with is only copying data from 1 table using a Copy SQL Server Objects Task. This package executes in 19 minutes. I have created the exact same package twice. Once using Transfer SQL Server Objects and once with a data flow task ...Show All

• SQL Server Problem with output parameters that are varchar and null

  I am using version 9.00.2047.00 SP1 of Visual Studio 2005. Using ADO.NET, I have been unable to get the Execute SQL task to successfully return the value of an output parameter defined as varchar or nvarchar when the value is null. No other data types seem to have this problem, including the sql_variant data type. Here is the stored procedure I am calling: create proc spx @in int = null output, @vc nvarchar(10) = null output, @dt datetime = null output as select @in = null, @vc = null, @dt = null return The variables to which the three output parameters return their values have a data type of Object. The task runs fine when the integer or datetime parameters are used, and the variables can be identified as null using IsDBNull ...Show All

• SQL Server Create a publication in SQL Server 2005 Express

  Hi, is it possible to create a publication with SQL Server 2005 Express. I can’t seem to find it in Microsoft SQL Server Management Studio Express. Do i have to install the full version :( Isn’t there any other option Thanks SP SQL Express can't serve as publisher or distributor for all types of replication. For more considerations for replication on SQL express. checkout this topic: http://msdn2.microsoft.com/en-us/library/ms165686.aspx in BOL. You will need workgroup edition or above, although the workgroup has limitations on the number of subscriptions. For full detail, take a look at "Features Supported by the Editions of SQL Server 2005" ( http://msdn2.microsoft.com/en-us/library/ms143 ...Show All

• SQL Server choose from SQLDMO /SMO

  in my classic ASP 3.0 application I would like to back up and restore SQL Express database. Should I use SQLDMO or SMO Whats the difference Thanks for your answer.I am using SQLDMO for backing up and restoring Sql Express database. While Restoring if i have any users connected to db ,restore fails.. Whats the solution for the problem Do i need to Stop SQL Server ,restore and start again ...Show All

• SQL Server @@IDENTITY vs. SCOPE_IDENTITY() on CLR Context Connection

  Dear all, I am trying to use SCOPE_IDENTITY() on the CLR Context Connection since it is limited to insertions in a more narrow scope than @@IDENTITY . The connection string in the .NET Assembly is: Using connection As New SqlConnection("context connection=true;"), Onwards, I insert a new row to a table with an int(4) identity column, but the following returns zero (0): Using command2 As New SqlCommand(" SCOPE_IDENTITY() ", connection) Try NewTagID = CInt(command2.ExecuteScalar().ToString) However, the following code returns the actual identity value : Using command2 As New SqlCommand(" SELECT @@IDENTITY ", connection) Try NewTagID = CInt(command2.ExecuteScalar().ToString) Why doesn't ...Show All

• SQL Server Need information about protocols in SQL Server 2005.

  I want to know the followings for an installation of SQL Server 2005 which is installed by accepting all the defaults: 1. Which protocols under SQL Server 2005 Network Configuration are enabled by defaults 2. Which protocols under SQL Native Client Configuration are enabled by defaults Will the answers for #1 and #2 vary: - among different editions of SQL Server 2005 including Express - among different Windows O/S - if SQL Server 2005 are installed by upgrading an existing instance of SQL Server 2000 or MSDE 2000 - due to the service accounts used by SQL Server Browser service or SQL Server Database service - due to any other factors 3. Which protocols under SQL Server 2005 Network Configuration need to be enable ...Show All

• Gadgets Gadget behavior on spaces vs live.com?

  I am still working on my first gadget and noticed things work really different on live.com compared to spaces. If you want to load what I have so far and see what I mean, the manifest can be found at http://www.incendy.com/MyRSS/rssgadget3.xml Basically the css is very different and also the function that rebuilds the list does not really work on Spaces and you have to manually refresh the page to get the new feed. Just curious if others have experienced this and have advice on what I should be doing differently. The function getfeed gets called but the content seems to be cached on Spaces where it works fine on live.com! It looks like Flickr uses a different "media" namespace than Soapbox ...Show All

• Windows Live Developer Forums VE in XAML application

  I am trying to embed VE in a WPF application (XAML). From this forum, I have learned how to embed VE as a web browser control in a WinForms app, and then load a .js script into the webrowser and talk to the script methods inside (I don't like kludges like this, but then that is what I get for trying wacky things). But ( VS-Studio, Sparkle (interactive designer)) do not allow web browser controls to be placed in XAML pages. So I am stuck as to do do this. Duncan (BTW, nice interview on channel 10), Yes, I understood your post to my earlier thread ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=907575&SiteID=1 ) that this was not possible to overlay WPF over a D3D surface. However, since we are so enticed with t ...Show All

• Visual C++ how to determine memory footprint of code from EXE

  i'm using VS2005 to develope some large C++ programs. is there an easy to determine the number of code bytes for an EXE i linked everything statically. thanks al This will give you the size of the executable code on disk - to get the actually in memory footprint while the executable is running you will need to profile your application. Note: code size is very rarely a performance issue. ...Show All

• Visual Studio Team System Urgent! TFSWSS and TFS AppPool Launch Failure

  Hi all, The application pools TFSWSS and TFS AppPool failed to launch at startup and it doesn't start when i try to manually start it on the IIS Manager. I've also looked on the services.msc and found out the following services also didn't start: Code Coverage Analysis Service, SharePoint Timer Service and TFSServerScheduler; Still i can't start it manually (Error 1069: the service did not start due to logon failure). Please do reply, I really need the server to run tomorrow. Thanks ...Show All

• Visual Basic How to extract files from zip file

  Hello Can I extract files from a zip file I have Thanks   The is a Microsoft example that uses the java libraries to handle the zip files.  http://msdn.microsoft.com/msdnmag/issues/03/06/ZipCompression/default.aspx I have been trying to convert the code to VB. I keep get an invalid cast exception on the following line.  Any help would be greatly appreceated. 'Reset to first object in collection.  Here is where I get the invalid cast exception m_Wrapped = m_Method change m_Method to m_Method.invoke and this code will work. Here is the main form Imports System Imports System.Collections 'Imports java.util Imports java.util.zip 'Imports C ...Show All

• SQL Server Failure Details?

  Where is, (or even does it exists) the best place to look for some details on when package execution fails if running as a scheduled job. Obviously when you run from the command line or in VS, there is plenty of output detail on progress and on the source of errors, but when you run it as a scheduled job, it just says step 1 failed in the sql server log, and package foo failed in the NT application log . Is there anywhere to find this info or do we need to build error traps into the package to write stuff out somewhere THX Dave package logging looks like a candidate http://support.microsoft.com/kb/918760 ...Show All

• Visual Studio Team System Reporting Serrvices Error

  When I told users to view reports in Project portal after setting them as Readers/ Contributors in TFS project portal setting, they complained that they can not see any report and get this error: The permissions granted to user 'Domain\UserId' are insufficient for performing this operation. (rsAccessDenied). There are lots of info about this error from SQL Server 2005 standpoint. But when I am trying to give users access to TFS team projects, what extra things I have to do for them being able to see the reports. Unfortunately, in V1 you have to separately control permissions between TFS and Reporting. In this case, the error is coming from reporting services (the "rs" part of "rsAcce ...Show All

• SQL Server article row filter - 2 parameters

  hello, i need to filter an article based on a user-supplied datetime filter (the datetime parameter is specified by the subscriber just before replication). at the same time i need to filter again by user (different subscribers get different rows). i already did the user-based filter using HOST_NAME( ). but the difficulty here (al least i think so) lies in passing 2 parameters to the filter. i cannot rely on using SUSER_SNAME to pass the user filter, because no one will want to create 500 user accounts. so i guess the only solution here is to pass both parameters using only HOST_NAME( ) and then write 2 splitting functions which uses HOST_NAME( ) as its parameter. am i right publisher/distributor is sql server 2005, all subscribe ...Show All

• .NET Development Problems using port 80: Services not running?

  I have been developing a client/server application for some time now and recently I did a complete reinstall of Windows XP Professional. I have everything working, and everything has been working the past few weeks, so all was good until I had a friend test connect to my server remotely. My server runs on port 80. The problem is that now port 80 is closed on my computer. I have it forwarded to my computer via my router's port forwarding, and I have no firewalls running at all. Windows Security Center is disabled as well. So my question is, are there any services that port 80 depends on for me to be able to accept incoming connections Is there a way I can force it open on my computer I will provide any details necessary. This is kind of u ...Show All