Answer Questions

• learningdba Problems with Create Endpoint

  I'm on XP running SQL 2005 (9.0.1314) trying to create and endpoint on my local machine. I'm trying to run the Adventureworks sample code: CREATE PROCEDURE [dbo] . [uspGetPersonInfo] @ID [int] AS BEGIN SET NOCOUNT ON ; SELECT [FirstName] , [MiddleName] , [LastName] FROM [AdventureWorks] . [Person] . [Contact] WHERE ContactID = @ID END ;   CREATE ENDPOINT SQLEP_AWPersons STATE = STARTED AS HTTP ...Show All

• AnilGopu how to access a cube and its dimensions in a cube

  Imports Microsoft.AnalysisServices.AdomdClient Imports System.Data Imports Microsoft.AnalysisServices.AdomdClient.Dimension Imports Microsoft.AnalysisServices.AdomdClient.CubeDef Imports System.Object Imports System.Diagnostics.Debug Imports System.Data.OleDb Partial Class _Default Inherits System.Web.UI.Page Public Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Bu ...Show All

• FlatWhite Implicit conversions using UDTs

  I've written a CLR UDT that basically wraps a COM FILETIME.  While using and testing this UDT, I've come across some unusual behavior that I can't seem to track down.  My question is this: When I make the T-SQL statements DECLARE @ft dbo.MyFileTime SET @ft = 0x0123456789ABCDEF What's happening within the SET statement   My first surprise was that it succeeded.  Then I thought, "The hex value, I understand, is implicitly a BI ...Show All

• kamalindia Help with Web Sync sql 2005 to sql express

  Hello,    OK I finally got the subscriber connected to the IIS server for replication. I am now getting errors when trying to apply the snap shot. Below is the error Did I setup the publication incorrectly by selecting replication with another sql 2005 Am I supposed to select something different when trying to replicate between slq 2005 and sql express Source:  Merge Replication Provider Number:  -2147201001 Message: The sch ...Show All

• Brave Belzebuth Customize QA - 'Script output as Execute'

  Hi group, In QA there is an option called 'Script object as....' Were developing a lot of sp's. When I use this option the 'skeleton' of a sp is created. Eg Create proc uspMySP @Message varchar(10) AS SELECT @Message The mention option would generate the following: DECLARE @RC int DECLARE @Message varchar(10) -- Set parameter values EXEC @RC = [EMGLSP3].[EM3_OWN].[uspMySP] @Message The question: Is it possible to customize this I would like ...Show All

• wackerfu Gurus: Please help! SSIS package using custom dll fails on server

  I have a SSIS package that has a script component. In the script I reference a custom dll that contains some functions. The dll is registerd with a strong name in the GAC on my machine and the SQL Server 2005 box. The package works fine in Visual Studio. The problem lies when I deploy the package to the server. (note: several other packages created without the dll work fine on the server). Is there something else that has to be configur ...Show All

• Long Yan Is there any sample code which creates login and user of one database using SMO?

  Dear All Is there any sample code which creates login and user for database using SMO I cannot find any C# sample code can do this. Any help would be appreciated:) Hi, sorry the same day you posted the question I wrote quick application, I imported that in a q&d Winform solution, which might help you to see the way to do it: http://www.sqlserver2005.de/SharedFiles/UserMappingwithSMO.zip HTH; Jens Suessmeyer. --- http://w ...Show All

• Jeff Putz Access 2003 database upsizing to SQL Server Express

  Is it possible to upsize an Access 2003 database to SQL Server Express without actually installing Access 2003 on my server....I would prefer to not have to do that. Currently, I only have the Access mdb file on the server...it is the backend to my ASP application. Can I download and run the Upsizing Wizard on it's own Thanks in advance, Kris. Currently the upsize wizard is only available as part of of A ...Show All

• Terry Montgomery How to create internet connection?

  Hi everybody,   Is there a client side approach of sending and receiving data from a sql database without a web service or a server component (servicedcomponent and server app) How can you simulate a network connection over the internet that could send and receive data from and to database   How can you create a class that would do the same task as a network connection using internet communication as medium Please point me to top ...Show All

• OMEGA_ReD Problem with Linked Server

  I am running a linked server "SGSC" from SQL 2k to Oracle 9i EXEC sp_addlinkedserver @server='SGSC',   @provider='MSDAORA',   @srvproduct = 'Oracle',   @datasrc='SGSC' EXEC sp_addlinkedsrvlogin  @rmtsrvname ='SGSC',  @useself ='false',  @locallogin =NULL,  @rmtuser = 'bisadmin',  @rmtpassword = 'bisadmin' When I am trying to execute the following query SELECT * INTO GL_BALANCES FROM OPENQUERY(SG ...Show All

• ThomasZecher DTC problem with Linked servers between SQL2k and MSDE

  Hi, can someone help me on this I have two servers linked with each others - ServerA and ServerB. ServerA located in trust area while ServerB located in DMZ behind firewall. I am able to run query from both servers without performance issue. However, when I start using BEGIN TRAN or BEGIN DISTRIBUTED TRAN, it always return the following error: Server: Msg 7391, Level 16, State 1, Line 4 The operation could not be performed because t ...Show All

• SmellyMutantCat How to add/(connect to) database in SQL Server 2005 Express?

  Hello, I just downloaded and installed the Visual Web Developer 2005 Express which is part of the new issued Visual Studio 2005 Express. It includes SQL Server 2005 Express, so I also installed it. My problem is I can't connect to the database supported by SQL Server Express. The log in is failed. I hope anyone who is using SQL Server Express can give me a help and tell me what wrong I've done. What I've done are: 1. In the Database Explorer, ri ...Show All

• gh0st 1 Calling WebService in SQL2K5 - Error generating XML ...

  Hi, I've created a stored procedure in SQL Server 2005 (September CTP) that calls a web service hosted on a local computer.  Here is the error message that I am getting: Msg 6522, Level 16, State 1, Procedure GetProductCost, Line 0 A .NET Framework error occurred during execution of user defined routine or aggregate 'GetProductCost': System.InvalidOperationException: There was an error generating the XML document. ---> System.Security. ...Show All

• Scav Tell Us Your Express Story and Win $100!

  Want a chance to show off a cool way you’re using Visual Studio Express or SQL Server Express We’re looking for your stories! Tell us about something that makes your life easier or is just plain fun and if we like it enough to include in a feature article, we’ll give you a $100 gift certificate to Amazon.com! http://msdn.microsoft.com/vstudio/express/support/hero_promotion/default.aspx Andria1974, You say: No, you d ...Show All

• msr_noida Cannot Open User Default Database (error 4064)

  Hi, SQL Server 2005 installed on my computer. i was trying to make a login page with VS.2005 pro. But i got some errors on Website Administration Tool. Whatsoever, i registered a database (aspnetdb) . Then, i think i made my default database to aspnetdb. Something went wrong and i decided to delete aspnetdb and start whole procces from the begining and i did it. AAANDD WHOOOLA. I got this error: Cannot Open User Default Database, Login Failed M ...Show All