Answer Questions

• albator69 SQL select events entered between 9am and 5pm on the same day

  Hello, I am trying to select appointments that were entered in a database table between 9am and 5pm. CREATE TABLE [Appointment] (  [appId] [int] IDENTITY (1, 1) NOT NULL ,  [appDate] [datetime] NOT NULL ,  [patientId] [int] NOT NULL ,  [practiceNum] [varchar] (50)  ... below is the psuedocode of what i would like to do select patientID and appDate from Appointment where appDate lies between 9am and 5pm of the current da ...Show All

• KJV Moved the post "SSIS Package Configurations Stored in SQL Server Table "

  Please look for the post in the SQL Server Integrated Services forum. ...Show All

• Fausto_Jasso Failed to generate a user instance of SQL Server

  Hello Everyone, I have instaled SQLExpress September on my Windows Server 2003 Standard. and I work on a windows XP SP2 for development using Visual studio Web Edition (Beta2) which comes with sql server 2005 too. I've built my application and tested it on my computer and everything went fine. But When I copied the application to the server, it showed the following error: "Failed to generate a user instance of SQL Server due to failure in retr ...Show All

• TheSwede SQL 2005 RTM We hit an error Msg 8630, Level 17, State 99, Line 18

  We just hit the following error with SQL 2005 RTM version Msg 8630, Level 17, State 99, Line 18 Internal Query Processor Error: The query processor encountered an unexpected error during execution. Any idea of what that message could mean The only explanation I found in some forums was that this means we had come upon a SQL Server bug The query is actually the EXEC of the below stored proc. After running j ...Show All

• Brent Rockwood File Access Error

  Hi All DTS fans, i know this is not the perfect forum for posting a DTS problem i am having but i thought that most of you who are now working on SSIS might have been using DTS earlier. anyways, the DTS package that i have written transforms data from a csv file into a table in SQL Server 2000. There is another application ,written in .NET C# which writes continuously to the csv file. When i run the transform task, i see an error mes ...Show All

• psystems Calling Reports without URL

  Hi, I am working in SSRS2005.creating reports using VS2005 and deploying reports in report server( http://localhost/reportserver/). I am using URL for calling reports. Now,I am working on another application which is runing on session.I am asked to develop a report for this session application.In this application security is an important factor. Without explicitly calling an URL how can I call a report in a button click event .I tried us ...Show All

• Ambient Difficult Query

  Hello, I am new to Transact SQL and am not sure how to get the proper result set.  If there is OE 1 and only EP 1 for the same sysprojn (see 3000021), I only want to select the row with the OE 1.  If there are more EP rows for the same sysprojn (see 3000024) then the sum(bookd) of the EP rows equals the bookd of the OE.  In that case, I need to select all the EP rows and the OE row.  Any help would be ...Show All

• Yogesh Ramakrishna System tables are not visible at all, why?

  Dear all, When you go to Sql Management Studio->Object Explorer and select Tables and then System you don’t see any at all. Why are not visible system tables for each user database as previously did Sql Server 2000 They are hidden or there is other stuff Any thought or view would be very appreciated. Tools forum is better for Management Studio questions: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=84& ...Show All

• th0 beta3

  Does beta3 work with vs2005 beta2 Are there any special rules for uninstalling the april ctp first dennist First, through Add or Remove Program, remove all of the SQL Server components (SQL Server Setup Support Files will removed automatically so you shouldn't have to touch this component. Don't forget to remove SQL Native Client as well). Second, through Add or Remove Program, remove .Net Framewor ...Show All

• RayRanson Problem because of . in xml tag

  HI , I am using sqlxml 3.0 for creating tables in sqlserver 2000 . sqlxml read schema file and create tables in database. The problem i was facing is if xml file contains .(dot) in tag name or in attribute name then it gives error while creating tables in database because table's field name cannot contain .(dot ) in it. To resolve this problem I use sql:relation and sql:Filed in my schema file for each element and attribut ...Show All

• doug gorman Could Not Bulk Copy

  Hi: I am doing a full snapshot on couple of subcriptions but getting this message from last couple of days. I have to do this at night because tables are very large so it does not block the users. I am not sure which table this error is happening. It used to work fine but from last couple of days this has started to happen. I need to re-sync my subscription database with production database but some of the tables are giving problem. The pr ...Show All

• PaulKline SSIS against Oracle source

  Hello, My SSIS packages import data from an oracle source. I have noticed and read through the limitations of the oracle ole db sources using the MSORA provider. Is there another provider that doesn't have the limitations So generally, is there a way to make parameterized queries work against Oracle without constructing dynamic SQL comamnds And even more importantly, is there a way to retrieve data that is returned in a "out ref " cur ...Show All

• dotDavid client to client connection

  hi we have a sql 2k installed on one server and 2 clients installed with sql server 2005 express.. clients pc are winxp..is it possible to connect from one client to one client pc using the sql express thanks By default, SQL Server Express is not configured to accept remote connections, which helps reduce the risk of attack via the SQL Server service.  If you do need to access your Express server from ot ...Show All

• pins Can I dynamically change the width of objects?

  I have a problem using the table object.  I have columns that I sometimes want to show, and I want the page to run off the edge and be two pages.  However, usually I'm hiding many of the columns and the table "shrinks" enough to fit on one page.  When this happens, the table looks right on the first page, but I get blank pages after it, because the report itself will not shrink.  Is there a way to dynamically change the siz ...Show All

• grennis "No Such Interface Supported" Exception 0x80004002 - HELP!

  AAAAARRRRRRRRRRRGGGGGGGGG! I finally figure out why I can't connect to the SQLEXPRESS on this computer (technically, I was a remote connection), get everything installed (Advanced edition), and then... It keeps telling me that "No Such Interface is Supported" and "Unable to cast COM object of type "System._ComObject" to Interface type..." I grabbed it in a screen capture and will try to get it to a server t ...Show All