Answer Questions

• friggityfraggity SQL Server 2005 Express Connecting with DB2 iseries

  Hi, I am using SQL Express 2005 sp1 When I created a linked Server to the DB2 on iseries ( V4R5) , the SELECT statement fetches me only the first record and the following message appears. OLE DB provider "MSDASQL" for linked server "DB2TEST" returned message "[IBM][Client Access Express ODBC Driver (32-bit)]Driver not capable.". Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "DB2TEST". I am using 'MSDASQL' which refers to the DSN setup on my machine using the ODBC "Client Access Driver 32-bit" Strangely when I used the same DSN in SQL 2000 within the DTS package, I was able to connect and import data ...Show All

• ZeePrime openxml to build a report

  Trying to build a report for XML data stored in a table... Employee.EmployeeUDF has six fields...I need to be able to report on all the data for the table....any way to do this So far, I have found a plethora of information that will easily allow me to return one row of the table...like below...but can't get more than that... DECLARE @idoc int DECLARE @doc varchar(1000) --The line remarked line below will select the udf xml values from the Employee table SELECT @doc = EmployeeUDF FROM Employee --The following is an example of the getting the udf_date_tamex info from the xml --SELECT @doc = ' <udf> <udf_text_tam>595297022</udf_text_tam> <udf_date_tamex>2009-12-20</udf_date_tamex> <udf_text_sher>2547793& ...Show All

• DGRASoft need advise on DELETE action.

  Hi friends i've a table that has 3 columns that refer to same parent table(foreign keys).am trying to following as part of action. ALTER TABLE dbo.u_childTable ADD CONSTRAINT FK_childTable_MASTER_BATCHTO FOREIGN KEY ( FK_BATCHTO_MASTERID ) REFERENCES dbo.u_master ( MASTERID ) ON UPDATE NO ACTION ON DELETE NO ACTION GO ALTER TABLE dbo.u_childTable ADD CONSTRAINT FK_childTable_MASTER_FEESCALER FOREIGN KEY ( FK_FEESCALER_MASTERID ) REFERENCES dbo.u_master ( MASTERID ) ON UPDATE set null ON DELETE set null GO ALTER TABLE dbo.u_childTable ADD CONSTRAINT FK_childTable_MASTER_SUBDEBT FOREIGN KEY ( FK_SUBDEBT_MASTERID ) REFERENCES dbo.u_master ( MASTERID ) ON UPDATE set null ON DELETE set nu ...Show All

• cythe Incremental Backup in Ms Sql Server

  Hi All, How i can take incremental backup in the Microsoft Sql Server I expect ur valuable replies Regards Mejo SQL Server has only the option for a differential backup /changes since the last base backup) HTH , Jens Suessmeyer . --- http :// www . sqlserver2005 . de --- Don't think of database backups in the same was as file system backups. SQL Server full backups take a copy of each active page in the database and back it up to a backup file. Transaction log backups are critical as well, as they contain an ongoing record of every change made to the database. Differential backups contain the pages changed since the last full backup ...Show All

• Simon__ Problem appending to a raw file

  I have subscription records for five different magazine titles that i process by looping each one though a dataflow using a for-each loop. I am using the following instructions to append to the raw file: http://blogs.conchango.com/jamiethomson/archive/2005/12/01/2443.aspx This works fine when I pass four different magazine titles. when i try to run all of the titles(five), i get the following errors: [Raw File Destination [131195]] Warning: The parameter is incorrect. [DTS.Pipeline] Error: component "Raw File Destination" (131195) failed the pre-execute phase and returned error code 0x80070057. Any ideas Thanks. Frank Yes, me too. It does seem to have something to do with ...Show All

• anubisascends Nonemptycrossjoin alternative

  Hi, Trying to filter out measure group rows for various conditions of different dimensions to do a sum of a measure This is to be used in a cube calculation (mdx expression), not a mdx select statement. The conditions for the date dimension is <>certain date and <=certain date, and hence the filter returns all member except the matching ones, which is a large set. sum( nonemptycrossjoin( (filter(descendants([Purchase Date].[Fiscal Hierarchy].Members, , leaves), ([Purchase Date].[Fiscal Hierarchy].CurrentMember.Name <> "yyyy-dd-dd" and [Purchase Date].[Fiscal Hierarchy].CurrentMember.Name <= "yyyy-dd-dd"))) , (filter(descendants([Ship Date].[Fiscal Hierarchy].Members, , leaves), ...Show All

• OOT_In_Atlanta What is Best way to Count the number of records in a table - Sql Server 2005

  I have a table with 54 million records But it take lot of time when i am using Count(*) or Count (ColumnName). What is best way to Count the records in Sql server 2005 Regards Vasanth count (columnname).. is better then using count(*) .... or use count(1) Hello, Using EXISTS is much less resource intensive than COUNT(*) Here is an example; http://www.bcarter.com/sap18.htm Lets clarify a few points. count(1) and count(field) are different as count only counts non null values Secondly there is a lot more cached than just plans. Data initially resides on disk and then is read into memory when used by a query. If a subsequent query then needs the data it can be read from memory and not disk. This is ...Show All

• Brandon Hawkins System Stored Procedures do not execute

  I tried this morning to check some of the system stored procedures and ran into trouble. Only four of them executed: sp_alterdiagram , sp_creatediagram , sp_dropdiagram and sp_helpdiagramdefinition . I could not check all the rest, I did it selectively. The typical error message was: Invalid object on RETURN statement. Some had syntactical errors. sp_ActiveDirectory_Obj Invalid object name 'sys.sp_ActiveDirectory_SCP' Line 171 sp_ActiveDirectory_SCP Invalid object name 'sys.sp_ActiveDirectory_SCP' Line 171 sp_ActiveDirectory_Start Invalid object name 'sys.sp_ActiveDirectory_Start' Line 19 Invalid object name 'sys.sp_add_agent_parameter' Line 60 Invalid object name 'sys.sp_add_agent_profile' Line 123 Invalid object name 'sys ...Show All

• BLueDeViL Create an array in a result field

  I am between the "newbie" and "intermediate" stages of writing SQL code and I am wondering if there is a way to capture multiple results into one field so I can basically create a "set" for a unique identifier.  Here is few result samples I receive from this code I am using now.   ReqNo                ProcID 7102005           1409 7102005           1796 7139003           1411 7139003           6097 7261030           1409 ...Show All

• simon burgess Problem with ProClarity analystics 6 for SQL Server 2005 reporting services

  Hi, all here, Thank you very much for your kind attention. I'v got a problem with Microsoft ProClarity for SQL Server 2005 reporting services as below: Created a 3-D effect reports (which are views in ProClarity professional ) and exported it into SQL Server 2005 reporting services, but the result in SQL Server 2005 reporting serivces is totally different, no 3-D result, and also the color of the report has totally changed, for better result in SQL Server 2005, I have to manually modify the reporting file in reporting services. Another problem is: the views created in ProClarity always change colors (the colors I think are aweful) after exported into SQL Server 2005 reporting services. Can any expert for that give me any adi ...Show All

• mz1derful Excel with ADO problem

  Hello, I connect to an Excel file with ADO and I get the sheet names and after that I read the table. if the column is all integers or strings there's no problem but if the column is composed of integers and strings then only the strings are returned,others are returned empty. What's the reason Thanks Hi, did you try this here: http://support.microsoft.com/default.aspx scid=kb;EN-US;Q194124 HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• paulixml Saving dates to SQL

  I am fairly new to SQL programming, and have a problem with dates. In my SQL text in vb.net i have this set to eg "04/09/06 00.00.01" executing that sql command works fine, but when i go to read the data back its shows as 09/04/06. If the dates is something like 25/09/06 it fails because i assume SQL read this as day 9 of month 25!. I have UK dates in control panel, how can i ensure SQL supports UK style dates The field type is datetime, i am using the executenonquery command after setting the commandtext to the sql syntax. Many Thanks for your help in advance Chris Anderson Many thanks for your reply. It is a datetime variable but i have solved the problem having seen ...Show All

• Paul Mitton 64 Bit MSDASQL.DLL

  Is microsoft going to provide 64 bit version of MSDASQL ( OLEDB Wraper for ODBC) in future This was working great while accessing Data from IBM AS/400 on Iseries from 32 bit sql 2000. Now, it's all screwed up with rediculously slow OLEDB both from MS and IBM. I wonder if any of these guys really care! How soon is soon Anxiously waiting... Well, Longhorn Beta 3 is our but I don't see an updated MSDASQL.dll download. Will the 64-bit version of MSDQSQL.dll be a separate download I do not want to download the immense Longhorn to simply install and extract a single DLL. This lack of 64-bit availability is delaying a production implementation for us. Thanks ...Show All

• Chris Howarth SQL 2005 Standard on Vista RTM

  Hi All, I've read a number of threads on here where users have managed to get 2005 working on Vista RTM. I'm having no such luck however. The issue I have is as follows: Clean Install of Vista RTM Ultimate 32bit. Attempt to install 2005 Standard. This error appears: SQL Server Setup Failed to compile the Managed Object Format (MOF) file D:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. I've read elsewhere that I need Sp2 of SQL Server. I can't install SQL server though so that makes it hard to apply a service ...Show All

• AllisonH Management Studio Solution user-defined project folders?

  When you create a Solution/Project in Management Studio, it creates 3 folders for you - Connections, Queries, Miscellaneous. It does not appear that there exists the ability to create your own set of folders, either under the project or any of the 3 provided folders.  Does anyone know of a way to do this If you are working on a project that has hundreds, perhaps thousands of stored procedures, views, etc., there currently seems to be no way to organize them.  If this is true, this is an incredible MS oversight! Thanks! I would hope so! Since Mgmt Studio is based upon the Visual Studio shell, it doesn't seem like it would be that hard. In fact, I would think they would have ...Show All