Answer Questions

• krisjl20 Could not create DTS.Application because of error 0x800401F3

  I am trying to run an ssis package from a classic asp web page. if I run it from the command line it works as expected. dtexec /f D:\publish\mypackage.dtsx however if I try to run it from the web page - I get the following error: "Could not create DTS.Application because of error 0x800401F3" I am assuming this is a permissions error - can anyone help Can I run a dts package from classic asp ...Show All

• Stine Returns Nothing, But Executes Fine

  SELECT tblWatchInstance.WatchID,tblWatchBrands.Description,tblWatches.Serial_Number,tblWatches.OwnerFName,tblWatches.OwnerLName, tblClients.Name FROM tblWatchInstance INNER JOIN tblWatches ON tblWatchInstance.Watch_Key = tblWatches.WATCH_KEY INNER JOIN tblWatchColors ON tblWatches.COLOR_KEY = tblWatchColors.COLOR_KEY INNER JOIN tblWatchBrands ON tblWatches.BRAND_KEY = tblWatchBrands.BRAND_KEY INNER JOIN tblWatchTypes ON tblWatches.WATCHTYPE_KEY ...Show All

• WiT8litZ SQL Express Management Setup Error on Windows Vista Beta 2

  Miscrosoft SQL Server Management Studio Express (SQLServer2005_SSMEE.msi) don't complete setup on Windows Vista Beta 2 with Sql Server 2005 Express installed. Error Code 29506. C:\Program Files\Microsoft SQL server\\90\Tools, Alberto What mean (Alberto is my Windows account) 29506 is "SQL Server Setup failed to modify security permissions on file %. To proceed, verify that the account ...Show All

• itsmike Updating Table Structures

  Colleagues: When I try to save changes made to tables in SQL Server 2005, I get a time out error about 30 seconds after I initiate the save to the changes made to the table. I then have to back out of the "modify table" operation and I lose my changes.  I never had this problem with SQL Server 2000, even in tables with millions of rows - it would take a while, but I wouldn't get the time out messagand the updates would be saved.  ...Show All

• ragc About the user defined sp for calculating & updating the staff annual leave record

  Hello, I'm using sql2005 and created a table use for contain the staff annaul leave holiday records of the company. I created a table 'test' and 3 columns 'id' (int), 'dj' (datetime), 'al' (int) which represent staff id, date join, annual leave holiday respectively. I used this table for testing the calculation of the annual leave of each staff have. the annual leave has the following conditions that must obey: working years annu ...Show All

• Vijaye Raji compatibility question

  just a question.... my web project is using SQL Express2005 and ASP.NET and C#. my web hosting company only have MSsql2000. would there be any conflict with regards to my database im sorry if i sound dumb. im a newbie to this. thanks a lot! can I implement the membership control (provided by ASP.NET) on MSDE i can try migrating from SQLEXxpress to MSDE but im not sure if membership control works on tha ...Show All

• Liquidream Performance with processing large dimension

  Hi everyone, I'm looking for suggestions on ways to improve performance in Analysis Services 2005 and Sql 2005 while processing a large dimension. I am using MOLAP aggregations. SQL Server & Analysis Services - Data & Log files are on same hard disk due to space constraints. This will be changed in production. Server has 6GB RAM & 4 CPUs. Data table has 21M rows @ approx 500MB. The Select statement reads just the th ...Show All

• Scott Dorman RUNNIG A JOB???

  I HAVE A PROBLEM,, I``ve just deployed a package into my server..it runs without problems from my SSIS.. but when i set a job with the sql agent and the package to it,. the job just fails .. why any solution please somebody help me!!! ruk_walled wrote: i,ve tried changing the destination to a flat file (.csv) and the job worked fine.. but why it doesn’t run when i use and xls file destination all these errors about connect ...Show All

• Needinput Dynamic Tooltip for TextBoxes in Reports?

  Hi, I want to add dynamic tooltip for the textboxes on a report where the tooltip text comes from a database lookup or maybe a resource file How can this be done. This is a required feature for our client and we do not want to add "Constants" as tooltip text which can be done in min as the drawback would be if the value for the tooltip changes, it has to be changed in all the reports wherever it appears. Thanks again. You can do this by c ...Show All

• SKB2006 connection string

  In a VB6 app, I am using the following connection string to connect with a SQL Server 2005 database: strDbConn = "Provider=SQLOLEDB;Integrated Security=SSPI;" & _ "Persist Security Info=False;Database=" & strDbName & ";" & _ "AttachDBFileName=" & DbPath & ";" 'Data Source=.\mssqlserver;" I am getting the following error message: Error No. -2147467259 [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not ex ...Show All

• jbender Calculated member for Grand Total...

  As part of a cube I would like to have access to the Grand Total for my measure "Events". Is there a simple way to access the grand total regardless of the Dimensions either as a calculated measure or directly for example if the dimensionsion were MonthNumber and EventType and the values for the intersect of these dimensions are 12, a = 5 11,a = 6 12,b = 3 11,b = 2 I'd like to end up with something like : Mont ...Show All

• Rusty Deschenes how to create sql server 2005 instance(after uninstalling sql server express)

  I have uninsttaled sql server 2005 express then installed sql server 2005 developer edition.All things are installed and working fine like management studio,BOL,reporting services ,e.t.c. But there is no instance of sql server 2005.I can connect to sql server 2000 instance from management studio. I have check from all ways but there isn't any instance. Could I create a instance of sql server 2005 from some where if yes the how. Y ...Show All

• pamskate5 Explanation of Security Groups for 2005

  I've been reconfiguring my Windows service accounts for the SQL Server service and the SQL Agent service to comply with the security best practices for SQL Server 2005.  Specifically, I created two new network accounts.  One account runs the SQL Server service, the other runs the SQL Agent service. Each account is an ordinary user account with no administrative privileges, althought the SQL Agent account is a member of the "Pre-Windows ...Show All

• JoeJoe simpson T-SQL

  Could you pls. advice me on following dilemma   I am having table called ‘ UNITCONVERTION ’, its containing following records.   IDfrom                                     FromValue             & ...Show All

• Anwar Buchoo Sql query for helpdesk application

  I am having a difficult time to create the following query. I am creating a vb.net command-line app that will produce a report from our helpdesk system on a scheduled basis. I have the following table structure timeStamp - Date/Time RuleID - Text(50) ResultId - Text(50) The RuleId are the Ids of the different server process that we monitor. The ResultId can be a 1 for Success, or 3 for Failure. Entries are only added during a falure, ...Show All