Answer Questions

• Ring0 Cannot save my Maintenance plan

  I use sa to login to sql 2005. I can save Maintenance plan using wizard, however, when I try to save maintenance plan using the maintenance plan design screen. I received error message "Apply to target server failed for job ...". When I check the job, there is no step in the job. In the Maintenance wizard, there is no maintenance clean up task. I want to create a task to delete my backup file if it is older than certain days. Any ...Show All

• blueskywalker Return random rows

  Are there any way to execute a procedure and return N random rows Well I didn't know about newid() either, thank you Jens. newid() is a funcion that creates a unique value of type uniqueidentifier. I executed select top 10 * from ACCOUNTS order by newid() against ACCOUNTS table with 30000+ rows, the execution plan shows 0% cost for generation of newid-s. So I guess it serves perfectly for you-you don't need to create and maintain ...Show All

• conzero RS with W98

  Hello I dont know the problem, I have install SQL 2005 Express with Reporting Services in Windows Server 2003, on this machine i saw the report from internet explorer, the other computer whit WXP i saw the report whit problem, but when i trye to see from computer with W98 i dont see the report, the IE show error with conecction and i dont know the problem, if i forget to installs something. Please help me ...Show All

• wien Time series problem

  I'm going to create an analysis report based on time range. The data is grouped by the hourly range. There're two problems that I'm facing. 1. How can I generate such result set so that it will give me 0 count instead of missing that column 2. How can I vary the start and end time which depends on another table I believe this is quite hard to be complete within a single SQL. However, I would still want to try. The SQL server is the Expr ...Show All

• sandeepkumar puppala Error: Unable to load one or more of the requested types.

  When I'm trying to deploy a SQLCLR assembly , I get the following error: Error: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. This is an error you get were you cannot get the assembly types during reflection. I was able to deploy it previously, and I'm not aware of any change I made that could make it refer to a different external type. It has a reference to another SQLCLR assemb ...Show All

• Bill_Thompson SQL 2005 Standard edition fails during installation

  When trying to install SQL 2005, I keep getting the foll. error: Error 1706. Setup cannot find the required files. Check your connection to the network or CD-Rom drive. For other potential soltions to this problem, see C:\Program ....\1033\setup.chm I have tried using two different DVDs, and also downloaded SQL 2005 from msdn, but none of them work. Can some please help. Thanks, Amir acharania@trimontrea.com   A ...Show All

• lizzy64 <Unsupported Data Type> ??

  I have a problem in a store procedure.... the field isn't updated or touched...it's only readed with a nested select... In the grid pane is showed :<Unsupported Data Type>  as this.. http://www.base2.it/img/sql3.JPG If I force a cast  like this.. CAST(derivedtbl_1.Descrizione AS varchar(255)) the value is showed... tha field in the original table source is definded ...Show All

• fender46 Numerous (every 10 minutes) Event log entries

  Hi, Every 10 minutes, I get and information application event log of type ID:17137 Info: Starting up database 'ReportServer$SQLExpressTempDB' This is a brand installation of the Express SP1 advanced package and the reporting service has not been yet used. Thanks Hi Mike, First, I would like to mention that t he installation is on a fresh Windows Server 2003 SP1. I also tried to reinstall th ...Show All

• Patrick Ng - MSFT inner join on reverse records

  I have some data that looks like this Col1 Col2 SumCol XXX,YYY, 5 XXX,ZZZ,6 ZZZ,XXX,7 YYY,XXX,2 I want to do a inner join on that data so I get this XXX,YYY, 7 XXX,ZZZ,13 Right now I'm using a CTE set to do that, is there a better way That query worked wonders! Thanks The <= query actually works but it seems to be slower a lot slower then my CTE ...Show All

• nvb2008 Change included columns when modifying table

  Is there a reason you can't modify included columns when modifying an index on a table I full appreciate that the index needs to be rebuilt, however SSMS manages that for you when you change the columns, clustering, file groups etc. So why can't I change the included columns and SSMS just do a drop_existing. Well, the primary reason would be due to the fact that adding additional included columns would touch all of the leaf pages in ...Show All

• Americo Indexed Views

  We are about to start a new project that includes fairly large data sets. Additionally, in many cases we have to grab data from a variety of tables. I was looking over SQL Server 2005 Indexed Views and I am currently considering using them to boost the performance of the joined tables I need to query and display results. Does anyone have experience in using Indexed Views as a means of increasing the performance of large table joins Additionally ...Show All

• Sevak006 SSIS will not start after SQL Server 2005 SP1 upgrade

  Hi guys, I have experienced a problem with a SQL Server 2005 SP1 upgrade, where hotfix.exe reported an error during the SSIS component upgrade, and then the SSIS service would not start back up. I have since attempted an additional SP1 upgrade on the server, which completed successfully, however the SSIS service still will not start. The server is running Windows Server 2003 Standard Edition SP1 with SQL Server 2005 Standard Edition (x86), wh ...Show All

• Sanjay659 SQL 2005 Enterprise June CTP Installation Error

  Tried to install several times (on Win2003 Ent. SP1) but I always get the following error: Failure adding user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelperUser (1388) The user varies (sometimes NT AUTHORITY\SYSTEM) and so does the local group (sometimes SQLServer2005SQLBrowserUser). Any tips Regards Roger Here's a thought... are we by any chance all trying to install it on a dom ...Show All

• Gad_appraisal Error Adding Package Configurations After Removing Them

  I have a package that used to have package configurations enabled, with a single XML file holding the configuration information.  The configuration information was removed from the package (and "Enable Package Configurations" was left checked, although I'm not sure that is creating this problem). Now trying to add a new configuration to the package.  When I open the Package Configurations Organizer dialog box and select "Add...", I get ...Show All

• Chazoo Add database in VWD - can't find SQLExpress

  ERROR: Connection to SQLServer files (*.mdf) require SQLServer Express 2005 to function properly . ASP.NET Config manager is able to create aspnetdb and set up MemberShip correctly. SQLExpress service account has access to teh folder (as witnessed by ASP.NET manger success). What else can cause the IDE to fail to create and attach the file Also the accoutn I am running VWD under can access and create/attach db files with no prob ...Show All