Answer Questions

• Philippe Bonneau How can I export data to a .sql with insert statements?

  Can someboby help me sith this issue. thanks in advance There's already data in the tables and I would like to become something like this... INSERT INTO Vertices VALUES (-99.6875 , 13.9952516555786, 0, 1); INSERT INTO Vertices VALUES (-46.597225189209, 14.1290817260742, 1, 1); INSERT INTO Vertices VALUES (-34.9146385157818, -8.08516788087916, 2, 1); INSERT INTO Vertices VALUES (-66.7407750757877, -54.3090734484738, 3, 1); INSERT INTO Verti ...Show All

• kgottfredsen MDAC 2.8 Fatal Setup Error. This setup does not support installing on this operating system

  I have XP Pro SP2 with MDAC 2.8.1022.  It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error. I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP.  There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Prog ...Show All

• MossyBlog Last Cube Process Date/Time

  Is there anyway to programmatically retrieve the last date/time that an SSAS cube was processed I would like to display this date/time in reports. I could add a step to the job that runs the process to add a row to a table upon successful completion, but don't want to re-invent the wheel. Thanks! BobP It is available via both DSO (for AS2K) and AMO (for AS2K5). Just look in BOL and you will see it. _-_-_ Dave using System; usi ...Show All

• Alan_98 Retieving ODBC Settings.

       I'm having some issues grabbing ODBC Settings. First off I need to present a user with the options to select thier DSN, Server, UID, PWD, and Database settings. I have come up with a way using the SQLBrowseConnect function to obtain the Server and Database information I need. Therefore, I have a semi working version of the program.      I just need a way to make the program a little more user friendl ...Show All

• Dirk Myers - MSFT Schema changes and Merge replication

  Hi there, I wonder if I can ask for some advise I wish to use SQL 2005 and merge replication but I have a few concerns over the schema changes that I am allowed to do on the publisher. Ideally I want sql replication to push all my schema changes from the publisher to the subscribers but I don't know if it can. or even if it is recommended. I see the BOL suggesting that schema repl. was mainly intended for ALTER type of statemenets, but ...Show All

• JHibbins Copying a cube but using a different data source

  We have a cube that we've been using for a while. I need to make several more cubes with the exact same schema and roles and everything else...just with different data sources. The other data sources have the same schema as the database the original cube is using. I know that when you copy a cube and paste it, the data source is copied over too. And I've read that you can't change the data source of a cube. My question is what is the easiest wa ...Show All

• mike bel Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' for insert reference using New Linked Server

  I get this error when trying to alter a stored procedure that has an insert statement referencing a new linked server I created: INSERT INTO [servername].databasename.dbo.DirectReport ... Msg 18456, Level 14, State 1, Procedure Get_Direct_Pay_Move_Data, Line 17 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I added Administrators and my logon to the permissions of my linked server but still get this error when it tries to save my stored ...Show All

• Niels A-J RS 5000 upgrade

  Can I upgrade the RS client to RS5000 and get the benefits of the date picker and multi-value parameters, or do I need to upgrade the RS server also I am in a time crunch and would like to use the newer RS features without needing the resources required to test and upgrade the server. ...Show All

• eglasius MIRROR database questions

  Hello all. I was reading an article by Rich Heiges called Mirroring - A New Look at HA. It left me with 2 questions (A) Can I change the operating modes of the principal and mirror roles on the fly, or do I have to stop the MirROR process (B) It said that MIRROR supports 32-bit to 64-bit H/W interoperability -- but will it support interoperability between 32-bit and 64-bit instances of the database Thanks! yo ...Show All

• Aleksey777 Bug? No WSDL information fo a WEBMETHOD that points to a table-value function

  Hello all, I'm trying to create a web service that merely exposes a table value function. I have a dummy function that looks like this (in a DB called ReportingDB): USE [ReportingDB]; DROP function [dbo].[TestFN]; GO CREATE FUNCTION [dbo].[TestFN] () RETURNS @Table_Var TABLE (c1 int, c2 int) AS BEGIN  RETURN END; GO My web service definition looks like this: DROP ENDPOINT sql; go CREATE ENDPOINT sql STATE = STARTED AS HTTP(  &nbs ...Show All

• gimmick Problem with text field: text input too long, weird characters

  Hi, Im a programmer for an university webportal which uses php and msssql. When an user creates a new entry and his text is too long the entry is cut short and weird characters appear at the end of the entry. For example: http://www.ttz.uni-magdeburg.de/scripts/test-messedb/php/index.php option=show_presse&funktion=presse_show_mitteilung&id=333 How can I set the text limit to unlimited Could it be something else Is there a way of splitt ...Show All

• Kevin56 Install of MSDE2000A fails.

  I'm trying to install the MSDE2000A (MS SQL Desktop server) and it fails with return code 3. I did have the Visual Studio 2005 beta 1 and 2 installed last year and had a heck of a time removing them, but VS2005 RC has been working fine. I previously uninstalled anything that even had SQL in the name. I've attached the last part of the eror log below. Any suggestions Property(S): SqlTools.CC1A8C58_27D1_4 ...Show All

• Sensei Migrating SqlServer2000->2005 and classic ADO: problem with AddNew to recordset, related to adFldUnknownUpdatable attribute?

  The application is running ADO (MDAC) version 2.81.1117.0. The application gets an recordset created by SQLServer by an select statement. In this case the recordset is empty. The application adds a record to the recordset by AddNew(). Works fine. But when assigning the first field (smalldatetime in database) I get ADO error -2147217887. I have inspected the recordset and I found a difference between the working one from SQLServer2000 an ...Show All

• Ozan No support for SQL Express or SQL Developer edition running on Virtual PC?

  Am I miss-reading something   After spending hours upon hours trying to install VS2005 Beta 2 June CTP edition, I stumbled across some documentation that basically says that SQL Express is *not* supported running on a Virtual PC.  Has anyone else run into this problem This is the documentation that I found: http://download.microsoft.com/download/9/9/5/99599cc4-93ee-4252-85dd-23abff8631b0/RequirementsSQLEXP2005.htm ...Show All

• kbrouill SQL Job setup to run SSIS 2005 Package is Failing

  I keep getting a failure when trying to run my agent which is trunning an SSIS 2005 package.  I have checked the logins and appear to have given the right logins owner to the msdb database and my other databases but still getting this error: 03/09/2006 10:13:31,Run EBN Process,Error,0,BG-22SQL,Run EBN Process,(Job outcome),,The job failed.  The Job was invoked by User domain\myuserid.  The last step to run was step 1 (Run EBN SS ...Show All