Answer Questions

• Michael Rich How to Delete Files on Maintenance Plan

  Hello, I am creating a Maintenance Plan in SQL Server 2005. The 'Back Up Database Task' has the choice 'Create a sub-directory for each database' as SQL Server 2000 does. But when I add a 'Maintenance Cleanup Task' I do not see a choice to delete files on subdirectories. Looks like it only deletes the files from the directory I specify. So, looks like SQL Server 2005 is removing some functionality already available in SQL Server 2000. ...Show All

• naskar FTP Task - Delete remote files always fails

  Hello, I have two FTP Tasks configured in my SSIS package. One is for "Receive files" and the other is set for "Delete remote files." Both use variables for the source/destination paths. My remote path variable contains a wild card in the name field such as /usr/this/is/my/path/*.ext and it is working to FTP all the .ext files to my working directory. I then rename the files and want to remove the original files from t ...Show All

• JonathanPerret How to Select Delimiter in 'Results to File'

  I want to use custom delimiters for different queries when I send the results to files. However, that choice seems to be missing from the menu in Management Studio: Tools>Options>Query Results>SQL Server. There is a Genereal tab, Results to Grid tab & Results to Text. What's up I wonder how to execute the query and save 'Results to File' by sql command, can anyone help ...Show All

• Stijn.Adriaensens Display SQL 2005 KPI status graphic using visual studio 2005

  Dear All, Could anyone help send me a sample mdx code on how i could get the KPI status graphics from MS SQL 2005. I create a cube and add a few KPI's into the cube, on the management studio 2005 I am able to view the graphics e.g. smiley but when i use the mdx command I could only display the KPI status -1, 0 or 1 not the graphics. The MDX functions does not include the KPI_status_graphics. Thank you in advance. Mike Siow siowm@meti ...Show All

• m00gle Missing image in PDF Export version

  I have an ASP.NET application that passes stored procedure params and generates a dynamic report with one or more Image controls. The image paths are created with absolute references to their locations in a separate web directory, the one that the .NET app calls the report from. So the stored proc returns a string similar to http://mysite.com/myimage.jpg , and with an expression I wrote in the report designer, I assign this to the Image contr ...Show All

• Tomasz Audit task

  Hi, I have to compare the values of two fields which are in different tables and then generate a audit report. How to view the audit report . How to compare values Hi Jamie, I have a master database. Based on certain criteria's I will be creating one new database. Once I have finished the creation, I have to check the value of a particular column in both database tables. This is actuall ...Show All

• GaetanoDiGregorio Creating an update trigger for a multi-table view

  I have a trigger on a view defined as follows: CREATE TRIGGER MyTrigger ON MyView INSTEAD OF UPDATE AS UPDATE MyTable SET field1 = inserted.field1, field2 = inserted.field2, ... FROM inserted INNER JOIN MyTable ON inserted.key = MyTable.key This is copied pretty much verbatim from various examples I've seen around (see Figure 2 on this page: http://msdn.microsoft.com/msdnmag/issues/04/01/DataPoints/ ), but it doesn't work ...Show All

• Philip Coyner SQL 2000 Best Practices Analyzer report clarification needed.

  I have an SQL 2k server that I've run the BPA against. Part of the report with the "SQL 2005 Readiness" filter shows several database options such as ANSI_NULLS, ANSI_PADDING_ENABLED NUMERIC_ROUNDABORT with recommended settings. My question is, where can I find the reason these are recommended for 2005 I need to present this information to the developers to discuss any issues before migration to 2005 can be planned, but the only docs ...Show All

• dsmerchek Attribute Relationships

  Hi, one more question about Attribute Relationships. I learned that you enter the "next higher level" as an Attribute Relationship to an attribute. So "month" is an attribute relationship to "day" (you put it under day), you put "quarter" under "month" and so on. What about attributes which are not a "higher level" but "belong" to an attribute (like "member prop ...Show All

• JockForrester Linking reports

  Hello, I am currently working on a project that involves tracking progress over several months. So, for the month of July, I need to show the results of June, May, etc. The easiest way I can think of doing this is to "connect" to the previous month's report. Can this be done The only other options I can think of are: A. have my July month recalculate all the values to the beginning of the year. B. create an new table in my DB that will store th ...Show All

• rreyna How to UPDATE ID in SQL

  Okay, I was able to delete some records from my db, however, I notice that I have some gaps in the record (ID) field such as  1, 2, 3, 5, 6,9... the missing numbers are the deleted records. How do I update these records to be in numeric sequence such as 1,2,3,4,5,6,7   I keep getting an error that ID is not updateable (set on Auto).  How do I change it Thanks. I can't find anything regardi ...Show All

• Mike C# Database with empty name

  I somehow managed to get a database object with an empty name into one of my instances of SQL Server. I can't delete it or otherwise work with it (I've tried renaming it so I could delete it) without getting an error message because of the empty name. I've tried these things (as well as a "Drop Database" query with no name, which I didn't expect to work and it didn't) from both the SQL 2000 and 2005 environments. Has anyone come across ...Show All

• BobHSC Changing data type

  Use databases a bit, but new to SQL Server. We just want to change a column of existing SQL Server 2005 data from a string data type to one of the UNiCODE data types, such as DT_WSTR or DT.NTEXT (such as one can use for various data mining tasks, etc.). It seems to do this one needs to "the data conversion transformation editor". To use that one has to have a package and a project Does any one have a full script or set of steps to ...Show All

• DieHardGuy How to use ODBC SQLSetConnectAttr from C# ?

  Hi, I'm having problems dealing with some large datatypes in a C# application using odbc. Basically certain datatypes, such as db2 CLOB, are not recognized as 'valid' by the odbc driver. It seems the fix is to use the SQLSetConnectAttr function using the appropriate key/value pair to 'map' those to datatypes known to ODBC but I'm not sure how to use it in C# code. The template seems to be more an unmanaged C type API with handles being ...Show All

• John Patterson Custom library Use

  When I had used SQL2K5 Sept. CTP there was an issue using custom .net framework 2.0 library. I had to register the library in GAC +  had to copy the dll into .Net framework 2.0 folder structure. I understand why we need to copy the dll on the development box so we can build packages, but why do I need to copy the dll in framework folder for production environment. Should GAC registration be enough   If this is a feature, what's t ...Show All