Answer Questions

• TDH Subscriber.Enabled() returning incorrect result

  I am giving my users the ability to disable their account from my NS front-end web app and to do that I am using the NS API. In order to disable the subscriber account, I - instantiate a Subscriber object for the subscriber - set its Enabled property to False - call the Update() method The problem is, when I create another Subscriber instance for the same subscriber somewhere else and check the subscriber.Enabled() property, it always retu ...Show All

• LPastor how to search a database by paramaters

  Hi, Does anyone know how i go about writing a search query using paramaters, ive been using this as my template: Select Distinct Recipedata . Name , Ingredients . Ingredient , Directions . Directions from Recipedata , Ingredients , Directions Where Ingredients . Ingredient Like '%Chicken%' and RecipeData . RecipeID = Ingredients . RecipeID and Ingredients . RecipeID = Directions . RecipeID ; Problem is now that i want ...Show All

• Nick Swan Install

  I just installed sql server 2005 express and everything seemed to go well. However I only see the configuration tools under program files in the start menu. Any suggestions would be appreciated. Thanks! Thanks, this helps. I actually wanted to initially load the free msde but got an error that said: "A strong SA password is required for security reasons. Please use SAPWD switch to supp ...Show All

• SW Skeen Can SSIS parse this text report without a lot of programming?

  I've got some machines that output text files after each shot of parts. I'd like to take the data in those files and parse it and insert it into a SQL Server database for future massaging. The text files look like the example I've posted below. Can SSIS parse out the set points and actual values even though the file isn't CSV or tab delimited and the data is kind of 'strewn' all over the report Each report does have the exact same format so the ...Show All

• Kamen Yotov SQL Server management studio index creation does not really create index

  I am trying to figure out what is going wrong. If you use the GUI Management Studio to create an index it shows in the list of indexes.  But if you do a createto> from the table the constraint code to create the index is not there. On tables created in previous versions of sql server it is there. I discovered this when i attempted to make a different index the clustered index.  The cluster change is made in the gui, but the ...Show All

• Brunni Debugging SP On server from workstation using Query Analyzer

  Hai .....,          I 'm able to debug a Stored Procedure directly on the server, but I 'm not able to debug the same stored procedure from my machine. What should i do in order to debug the stored procedures  on the server from my workstation.           (I can debug the stored procedures of my local sql server) Please take a look at t ...Show All

• Ragi B Maintenance Plans is SSE and Studio Management Express

  Hi all, I am using the Express versions of SQL Server and the Management console and can't seem to find anyway to set up basic maintenance plans. Is this feature not in the Express management studio I hope I am just missing it and it is not totally missing. I am trying to get my skills back up to speed so I can tackle some DBA jobs again and am working from home at the moment. Can someone fill in the blanks for me to tell me if thi ...Show All

• ACAnghel Cursor Help Please

  I have a requirement for a user to access time sheet information by accessing a SharePoint portal listing. They will be required enter a date range. The login will be based on their domain access. Based on the query below, I can return a result set which gives the user all rows they'll need, grouped accordingly and based on a date range. Except for a required billable percentage figure. A billable percentage is defined as billable hours / t ...Show All

• pate Join Dates....help!

  Hi group, I want to check if a date in table a exists in a holiday table. I need to match the [date] field of both tables. The problem is that table a has a datepart and a hourpart. Table b has only a datepart (the hour part is always 00:00:00.000). How do I join them so that the hour part is not taken into account PLEASE HELP! Regards, Sander Here is the layout: #PeriodDates Column DataType [Date] DateTime Values: 2006-01-01 00:00:00.0 ...Show All

• CharlesY Need dump 200 columns to a flat file

  All, I need to dump a table with more than 200 columns to a flat file. I tired in SSIS with the flat file destination, but it only allows 84 columns. What should I do if I want to dump all the columns to a text or cvs file. Thanks in advance Yeah absolutely. Why not take the package constructed by the wizard and either: 1) Build your additional requirements into that package or 2) Copy a ...Show All

• cesc_s SQl Server CE question..

  Hello.. I want to install Virtual Directory (PC Windows 2000), but I've got this error "The computer that you specified is not configured for NTFS. You do not have to set permissions." Did I can't do my merge replication using PC without NTFS Thanks Darren.. I'm already convert my PC from FAT32 to NTFS.. :D You do need NTFS to properly set permissions on t ...Show All

• vvkmlhtr How to send parameters to report when executing ReportingService.Render

  I'm trying to figure out how you send/set the report variables when using the ReportingService.Render method. I can get the ReportParameters array using GetReportParameters but can't seem to find a way to populate the ParameterValue array that is passed as a variable in the Render method. I've tried creating an ArrayList comprised of ParameterValue objects (non-array), adding them to the ArrayList, and trying to convert that to a ParameterValu ...Show All

• Kelvin Penus is sql server 2005 a standalone install? Or do you have to install windows server

  I have never installed sql server before and I didnt know if I just take the sql server 2005 standard edition media and boot off it and do a fresh install that way or do I have to install Windows server thanks, that exacty what i needed to hear. SQL Server is "just" a database*. You need an underlying operating system in place before you attempt to install it. For SQ ...Show All

• Tony_Rodriguez how to create a DTS package in 2005

  Can anyone give me a quick tutorial on how to create a DTS package in 2005 using Business intelligense studio. I want to import a file from a ftp location and load it into the database as a table. I know how to do it in 2000, but can use some help in 2005. thanks Look at the tutorials in BOL. -Jamie ...Show All

• J Hill Resources about Load/Run SSIS packages using .NET Remoting.

  Hello, I don't have a specific problem, I'm looking about resources because this is the tipical case when something is working but I don't know why .. On particularly I have to load and run a dtsx package from a window application and the package is located on the server. I decided to use .NET Remoting. I developed my "Remotable Object" which contains: package = Microsoft.SqlServer.Dts.Runtime.Application. LoadFromDtsServer() packag ...Show All