Answer Questions

• Antfor MCDBA or MCTS

  For my last 3 years I have work with the SQL 2000 as a database analysis. Now I want to get a certification to prepare me to look for a better job. Which certification is more valuable in today job marker MCTS or MCDBA. Indeed, you don't gain any benefits when doing MCDBA. The only benefit you could have is to gain some extra knowledge when studying for the exam but since you allready have some experience this will be limited. There is an upgrade track from MCDBA to MCITP Administrator but this is only for the administrator track and not for the Development or Business Intelligence track. You can check the multiple possibilities at http://www.microsoft.com/certification Greetz, Geert Geert Verhoeven Consu ...Show All

• Bill Reiss Unable to retrieve Column information when using Ole Db Provider for sybase

  Hi All, I am in process of transfering data from Sybase to Sql Server using SSIS 2005 have taken a Data Flow Task in Control Flow tab In Data flow tab, I have taken one Ole DB Source and One OLe DB Destination For the source, I am using Sybase Adaptive Server Anywhere Provider 8.0 For Destination, I am using Sql Server 2005 database In Ole Db Source Editor , For OLe Db Connection Manager, I choose Sybase Connection For Data access mode, I choose Table or View For Name of the table or the view, I choose a table by name Table1( it lists all the tables from Sybase database) When i click on preview button or Columns link, I get the following Error Error at Data Flow Task [OLE DB Source [1]]: An OLE DB error has occu ...Show All

• Danawar Displaying images that are accessed through URL

  Hi, I have trouble displaying images that are accessed through URLs in my report. If I call the URL directly in the Browser the Image can be opened without problems. The images can be accessed with an anonymous access. When I deploy the report or in the Preview of Visual Studio I get the following message: [rsWarningFetchingExternalImages] Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access. In Layout View of Visual Studio the image is showen correctly. The Images are stored on a Solaris maschine with WebSphere 6.0 as WebServer. Any ideas Thank you. Frank ...Show All

• enric vives For Remus - Access to the remote server is denied because the current security context is not trusted.

  Remus (or anyone who can help) - I am sorry for posting this question here. The only reason I am doing so is because Remus answered a question similar to this late last year, but I couldn't get access to the whole thread. In SQL 2005, from a stored procedure in a local database I am attempting to execute a remote stored procedure in another database on another server. I am getting the error referred to in the Subject when the local stored procedure tries to execute the remote stored procedure. A couple of comments: a.. The remote database is set up as a linked server in the local database. As part of the linked server definition I selected the 'be made using this security context', and provided a local user name and password. b.. The ...Show All

• orlop sharedenyread didn't work in ADO

  hi .. i made an application using vb6 that access the table in a sqlserver database and in the load event i write cn.mode=adsharedenyread and i make two copies of the application and run them both of them read the data and no deny happen !!! although both of the applications have adsharedenyread how can i make privilage for some users to read or write by the way is that can be done in ado.net 2.0 thanks in advance. hi any help hi if any thing not explained good i can describe the problem again thanks in advacne Can you trap the execution by displaying all the properties of the connection so yo9u can validate any answers Hi, You should make sure that you are setting the mode when the connection has n ...Show All

• sai ravi SQL2005 : Can not run the DB tuning tuning advisor

  I've setup Sql2005 developer edition. Created a test server and one database with a few tables. I can connect through Server Management Studio. When I try to run the Database Engine Tuning Advisor I receive this error: Failed to open a new connection. Failed to initialize MSDB database for tuning (exit code: -1073741819.) (DTAClient) any tips on what to do next have you checked your MSDB database and ensure its not in a non-operative state aka Suspect database etc... I'm no SQL Server expert, but I do know I can connect to my DB Server and all the contained DB's and tables just fine through the management studio. ...Show All

• su45937 hosting SSIS packages where?

  After i create a SSIS package, where can i put it or store it in the SQL SERVER 2005 so that i can execute it later on He informing the poster that he can use the deployment utility to deploy his packages, and it will show him the different options available.   Grant Swan wrote: Hi, The option to do this is available once you have built you're project and you have done this whilst the CreateDeploymentUtility is True. All you then have to do is go to the deployment folder (usually in the bin directory) and run the .SSISDeploymentManifest file. This will give you all deployment options including where to store your package. This link gves some info on how to execute the packages programmat ...Show All

• Dwight Kulkarni How to Fax Reports from SSRS 2005

  How do I fax out reports from SQL Server Reporting Services (SSRS) 2005 I tried RightFax 6.0 but it didn't work. Do we have to be on a certain version of .Net (like 2.0 Framework) to use the printer custom extension Does the Printer Delivery extension allow you to print to RightFax with a native printer font I believe that is what the problem is here. Since I can't use a native printer font (non-true type font) in SSRS, the RightFax embedded codes can't be passed to RightFax. You will need to create a custom delivery extension. The best way would be to start with the Printer Delivery extension that comes with the SQL Server Samp ...Show All

• bboylen Erasing digit

  Hello. I have a column in my database which is holding phone number. The problem is that although I gave the number starting with zero but it will erase it automatically. So can you help me to solve this problem Thank you ok thank you for you help Store it as a char or varchar KHodam wrote: Hello. I have a column in my database which is holding phone number. The problem is that although I gave the number starting with zero but it will erase it automatically. So can you help me to solve this problem Thank you As Paul alluded to, you aren't storing the phone number as an integer, are you Store it as a varchar and make sure that inside your data ...Show All

• AdrianG Restore a single partition SQLServer2005

  I want to to restore a specific filegroup to a prior point in time, but leave the remaining filegroups current. Assume a 100 partition table which is updated by a job which updates data in one partition - say a monthly job. The specific filegroup is backed up prior to the changes. An error occurs then we want to restore only that one partition back a few hours or a day or so, but do not want to touch any other partition - they are all OK. So far, it seems that i have to restore and roll forward to the current time - including PRIMARY filegroup or i can restore the whole database back to a point in time. Any help is appreciated. Thanks Glenn Filegroups cannot be restored to a prior point in time. They and the partiti ...Show All

• ElvenWong Anyway to schedule a report to deploy automatically

  Can this be done with ssis or executed in a package You only deploy a report when the definition changes. Do your modify your reports on a regular basis If that is the case then I would suggest writing a little program using the SQL Reporting Services WebServices API. You can do just about anything with it! Nevermind, it's the table that is getting updated and the report is already there. ...Show All

• Stanley Yuan question on package configuration

  Hi, Programmatically, how will i be able to know if a package is using package configurations Thanks. The script task can't know whether configuration is used. How would you use this information, what is your goal thank you very much for the information!! one last thing... the reason why i wanted to look the configuration table, is because i need to get the passwords for the connections. I tried to get it programmatically but it is write-only and Duane said that I cannot retrieve it. I need to have the password because before package execution, i need to test if i can login to the ftp server (already created a connection object during design time). i ...Show All

• Sean D Wright Latest value for all members at a given point in time

  We have a fact table with a current balance record. For this balance rows are added to the table only when the balance has changed. This way we can reduce the volume in the fact table by not saving redundant information for every point in time that we want to analyze. In SQL it is a simple task to get a view of the lastest fact records for a given point in time. SELECT f1.* FROM factTable f1 WHERE f1.timestamp = (SELECT MAX(f2.timestamp) FROM factTable f2 WHERE f2.timestamp <= givenPointInTime AND f2.balanceKey = f1.balanceKey). In other words, the given point in time directly determines which rows should be fetched from our fact table, one row for each balance record (balanceKey). This row will of course include several dimension at ...Show All

• JustinS Trying to return DISTINCT COLUMN data with varying information

  I'm trying to find the best way to return distinct data from a column (Message). The problem is that the messages are not distinct. Ex. Message1 - An unhandled exception occurred type 123456 Message2 - An unhandled exception occurred type 346742 Both of these messages are being returned since they are not unique. Now I was thinking about doing a character length and dropping the message after x number of chars, however, there are other issues like the unique data in the message isn't always in the same location. Any ideas of how to query this would be much appreciated. Wow... 10,000 rows that can be shrunk into a single one with a little string manipulation. I'm still somewhat dubious, but either way... ...Show All

• El Gaseron Visual Studio 2003(1.1 .NET Framework) SQL Server2005 compatibility

  Hello, I had a simple question (I'm hoping). Can a 1.1 .NET Framework ASP.NET website use SQL Server 2005 Express edition for it's database Thanks. Brandon Yes, you should be able to connect to SQL Express just as you would have SQL 2000. Regards, Mike Wachal SQL Express team Thanks. ...Show All