Answer Questions

• David Pallmann How to set Execute permssion in this case, thanks

  I have a SP in my db need access sysmail tables in msdb, not sure what I need, I created the sp like create stored procedure mysp with execute as 'dbo' as begin select * from msdb.dbo.sysmail_profile ... ..... I just rebuild my master db to change collation, and now I can not get the sp works, it keeps saying select permission was denied on the object 'sysmail_profile and now I can not understand how I wrote the code. The execute as dbo, the dbo should be dbo of my db, it should have no right to access msdb, I need a login to map to user in msdb, right how could it worked before But the document says execute as login should only be used for DDL. I don't understand how we can let sp in db1 access objects in db2 w ...Show All

• WXS123 Converting from Access.mdb database to SQL 2005

  Is there anywhere a program which will convert my 30MB Access database into a SQL2005 database   I've tried the upsizing wizard in Access 2000 and it just bombs.  From the performance hits I now have with my data access since I went to VB.net 2005 and using ADO.net instead of ADO classic, I need to do something.  The ADO.net now takes almost 3 times the time to do my table stuff.  Was using Server side cursors under classic and data access was fast (Is a remote table).  Now the data access is a hog, takes anywhere from 1.5-3 seconds to retrieve a record.  As an added thought, I had done ADO Classic in the VB.net conversion, and I did NOT have any performance hits.  I've troubleshot the problem to ADO.n ...Show All

• George Weihs Update of a text/image and a clustering key

  Hello Everyone, We receive this error with ADO.NET (on a SQL Server 2000): The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at OnExecuteNonQuery@dtbmsq_Statement_c@@$$FUAE AW4dtb_Result_t@@PAUdtbsql_Connection_ip@@PAH@Z(dtbmsq_Statement_c* , dtbsql_Connection_ip* Connection, Int32* NbRowsAffected) in s:\ogl20061\src\odbmsq\dtbmsq\dtbmsq_statement_c.cpp:line 598 N.B. The update concerned only update one row. I ...Show All

• nightwish How to format prediction Expression

  hi, when i make use of predicton functions, the output is formatted in its own.But I want to format that.How to do that Thanks, Karthik. You can try select Flattened ( select $time as TimeStamp, [Performance] as Perf from PredictTimeSeries ([Performance], 5) ) as A from [Stud_Model] This allows you to customize the name of each column, as well as the name of the whole sub-select, and the results should look like A.TimeStamp, A.Perf Thanks a lot bogdan,thats very helpful to me. Karthik. Can you please elaborate Are you using BI Dev studio, SQL Management Studio or other tool to run the DMX query using prediction function. Where are you looking at the output hi Shuvr ...Show All

• markovuksanovic Perform upgrade method

  hi I have two versions of the same dataflow component , i need to use the new version component in the packages created using the old version . How can i do this using the perform upgrade method . Thanks Mani Indeed you are right. I think is time for me to go in vacation Explanation about PerformUpgrade and a sample code can be found in book online or at: http://msdn2.microsoft.com/ko-kr/library/microsoft.sqlserver.dts.pipeline.pipelinecomponent.performupgrade.aspx Hope this helps, Ovidiu Burlacu hi thanks i got the solution the perform upgrade method only works if the current version property, that is stored in the package is less than the currentversion propert ...Show All

• benny353 Groups: keep together -> can't find it

  Hello there. I've got a little problem. I'm deploying reports in RS. I also have to rebuild old CrystalReports-Rreports in RS. 90 % of them are using a "keep together" function. I've read a lot in forums that there must be similar function in RS. I also found descriptions where this property should be, but there isn't. For report-developing I used (RS2000 with VB.NET2003) and (RS2005 with VB.NET2005). Neither of them have this property for table/report. Do I have to install a ServicePack Any other ideas Thanks, Tobi There is a List-Control available. Using this control I got some good outputs. It has a KeepTogether-property. Approximate 95% the page brake is correct. Sometimes, if a textbox gets reall ...Show All

• CodePfo Problem with PDF Exports in RS 2000 SP2....

  Hello All, when we export to pdf, keeptogether functionality is not working properly  in Table.Is this fixed in RS2005 Does anyone know when rs2005 will be released . Thanks in Advance.     rs2005 was released with SQL2005 together some months ago. Hi, Keeptogether is not working for report export to PDF in VS2005... I have a 4 column report and the List (with embedded List) does not wrap as I expected with Keeptogether=False. Am I doing something wrong Is there a trick I'm missing. Thanks.... Frank I have this problem too, in SRS2005, list w/ embedded list acts as if keeptogether is on when export to PDF or print. Mine is ...Show All

• Gabriel Lozano-Moran Alignments between tasks and constrains

  Hello What are your experiences with the alignment of constrains between tasks I find it hard to align two task in an exact same vertical or horizontal position. When you grab the green constrain lines with your mouse, you can see a soft pink dashed line which tels you which way to go with your mouse but it is so hard to get straight lines. Is there a auto align task feature or something else I don't know of How do you guys do it Regards, Worf I knew I shouldn't of asked that question. I better start reading the basics before making packages. Well Rafael..once again, thank you. Worf Have you looked at the options in Format menu of BIDS I personall ...Show All

• syhzaidi Remote connection not working using MSSMSE

  Im getting quite desperate and frustrated!! I have installed SQL 2005 Express successfully and can connect to it fine using Management Studio locally. If I try and connect remotely using Management Studio Im getting the old Error 10061 : The machine actively refused the connection! I have set it up exactly as per all documentation and help from the forums. Remote connections is on TCP and Named Pipes, I even have the firewall disabled. Im running it on Windows Server 2003 Standard. Any help would be really apriciated as i have tried everything!!! The server is listening on port 1833, and it's normal. Try "telnet yourmachine 1833" and make you can connect to the port. Sql browser ...Show All

• irl-barse Complex insert?

  I am at a loss for how to write an insert for my situation. There are two tables involved: SubstanceAbuse (OrderId, AssessmentID) TempAsst( AssessmentID ) The insert has to do this: For each TempAsst.AssessmentID, insert a record into SubstanceAbuse (3, AssessmentID) if there is not already a record in SubstanceAbuse with that AssessmentID and a value of 3 in the OrderID column. Thanks! Maybe something like: insert into substanceAbuse (orderId, assessmentId) select distinct 3, assessmentId from tempAsst a where not exists ( select 0 from substanceAbuse b where a.assessmentId = b.assessmentId ) Perfect! Thank you!! ...Show All

• chu!0 XMLA for Retrieving Database Names

  Hi: Can anyone please share the XMLA Script for Retrieving the database names on a AS 2005 Server . Thanks Thanks Mosha. I am very new to ADOMD.NET. Is there a sample code snippet that I can take a look at to see how I can do it. I was hoping to do it in T-SQL but I am not sure if thats feasible. Thanks again AK Thanks a lot Dave.It works. I have a small question though. The output of the query is also in XML format. Is there any way I can retrieve the output in a relational format something on the lines of (select * from sysdatabases). Will I need to declare a XML data type and then retrieve the output in a column format . Please advice. Thanks ...Show All

• pidnas Olap Mining - Advantages, Disadvantages and Problems

  Dear Sirs and Madams, it's quite hard to find informations about OLAP mining I think. So I have some questions to you: What advantages do I have by using Olap Mining instead of "normal" mining (relational databases) Is it just faster or are there other advantages What are the disadvantages The data can be overaggregated (no detailled results), can not Are there other disadvantages What problem do I have to face Whats going on with empty cells Thank you very much in advance and have a nice weekend. Thorsten The advantages/disadvantages of OLAP mining really lay around the advantages/disadvantages of OLAP itself. Personally, I recommend using OLAP mining models when you r ...Show All

• morgan_ updating sql 2000 database from sql 2005 database

  i have sql 2005 installed on my personal machine, but our server has sql 2000 on it. the structure of my database was made on the server, but i'm not sure how to update the server copy from my local copy. when i try to export my data from my local machine to the server (or import from my local machine to the server), i get pre-execute errors. roughly every other week, i'll need to be able to update the server version from my local version, so i'm trying to find the most efficient method. what is the best way to update a 2000 database from a 2005 database it doesn't matter if i append or overwrite, but i do use identity fields. the error i get when trying to use the import/export wizard is: - Pre-execute (Error) Message ...Show All

• errolian Unable to update XML attribute designated as xs:SimpleType

  Hello, I am trying to update an XML attribute which is designated in my schema like this: <xs:attribute name="SpecialFloodHazardAreaIndicator"> <xs:simpleType> <xs:restriction base="xs:NMTOKEN"> <xs:enumeration value="N"/> <xs:enumeration value="Y"/> </xs:restriction> </xs:simpleType> </xs:attribute> My sql looks like this: UPDATE XMLDATA SET XML.modify('declare namespace MISMO="http://mrgdev.local/mismo/";replace value of (/MISMO:LOAN/MISMO:_CLOSING_DOCUMENTS/MISMO:CLOSING_INSTRUCTIONS/@SpecialFloodHazardAreaIndicator)[1] with sql:variable("@FloodInsRequired ...Show All

• Neil_D_Jones Simple flat file import

  Boy, do I need HELP! Have a simple csv file that I need to import. Worked fine in sql2000; I put it into dts to execute on a monthly basis. Makes connection, db connection, table creation fine, but stops at validation of flat file Basically, I want to go out and get a flat file, drop the existing table, and create the table, and import the information from the flat file. Not a complicated table of about 30,000 records. Create table [db].[dbo].[tblPatient] ( [patientID] into not null, [chartID] varChar(15) null, [doctorID] int null, [birthdate] datetime null, [sex] varchar(1) null, [raceID] int null, [city] varchar(100) null, [state] varchar(2) null, [zip9] varchar(9) null, [patientTypeID] int null, [patName] varchar(100) null) Be ...Show All