SQL Server

Page 2122




  • Topics
    Replies
    Last post
  • RemoteDataAccess
    by Mark Cooray
    2 Replies
    Last post by Mark Cooray
      • Dear Friends, To use RDA, do I still have to use Replication, Publishing if yes which publication need to be used is it Transaction If you can guide me as to how I can imliment RDA, would be a great help.
  • installing msde 2000a
    by new to sql server
    2 Replies
    Last post by Patricia_Osorio
      • I tried to install the MSDE 2000A to have a copy of the SQL Server northwind datbase on my machine. When I was installing it I got an error that said the following...... "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Set up will now exit" Does any one know what I need to do to fix this
  • Scheduling an automatic backup
    by Berly Sam
    13 Replies
    Last post by Arnie Rowland
      • I have only started using SQL Server 2005 Express Edition recently.I also installed Management Studio Express version to manage the database. While testing the database I had came across some question and they are: Can I upgrade from SQL Server 2005 Express to Workgroup/Standard/Enterprise without loosing the database and its contents. While I backed up the database, I was permitted to bac
  • Sql 2005 Intergration Services Installed But Service isn't there
    by DavidWGoodall
    10 Replies
    Last post by iistudio
      • I am a bit out of my league here so any help would be greatly appreciated. On a Windows SBS 2003 R2 server. I am trying to add Integration Services at the request or an external Consultant group. I ran the install & followed the bouncing ball from this article http://msdn2.microsoft.com/en-us/library/bb326043.aspx The only odd thing is that it didn't give the option to pick a
  • Unable to merge two stand-alone recordsets
    by Frank Ramos
    2 Replies
    Last post by Frank Ramos
      • I have two stand-alone recordsets. They have the exactly the same fields definitions. They come from different ADODB connections (Microsoft Jet). And I cannot merge them into one recordset. I was trying to merge the second recordset into the first, but instead of adding the records, the first recordset becomes populated with infinite copies of the first record of the second recordset. This
  • Can you reference a Package using ActiveX Script Task?
    by Jayaram Krishnaswamy
    2 Replies
    Last post by Jayaram Krishnaswamy
      • Using ActiveX Script Task it is possible create office automation objects such as Word and Excel typically using the CreateObject() Syntax. Can you use this syntax to create a Package object using CreateObject("DTS.Package") If not Why not I am not sure whether it was possible in DTS. I am aware of the fact that ActuveX Script Task is included in this Version of SSIS and will be d
  • cannot view wsdl of endpoint.
    by winstonSmith
    7 Replies
    Last post by winstonSmith
      • i created this endpoint in SSMS: Code Snippet /****** Object: Endpoint [first_Endpoint] Script Date: 06/19/2007 16:39:22 ******/ CREATE ENDPOINT [first_Endpoint] AUTHORIZATION [Domain\username]--scrubbed my username out of post! STATE = STARTED AS HTTP ( PATH = N '/sql' , PORTS = ( CLEAR ), AUTHENTICATION = ( NTLM , KERBEROS , INTEGR
  • SQL server integration with Monitoring Tool
    by zestq
    2 Replies
    Last post by zestq
      • hi guyz i want to integrate Sql Server 2000 with Microsoft Monitoring tool , and wht I exactly want is , I need a report of each users and their internet history. i have an application on asp.net 1.1 in which i need to import data from some source it may be microsoft proxy server or any monitoring tool. 1 of my mate suggested me to use the tool which lies at : Control Panel -> Ad Remove program
  • Multiple database files on the same disk
    by Aviel
    8 Replies
    Last post by Tarek Ghazali
      • Hi there It is obvious that putting multiple database files on different physical disk is better for performance, but what about splitting the data on different files on the same disk I have got a database of about 20GB and only a single data file. will I benefit from splitting this file to multiple files on the same disk
  • Strange Script behaviour
    by Kapil Kelaiya
    13 Replies
    Last post by Bob Bojanic - MSFT
      • I am facing a strange problem. SSIS is executing a piece of code which is inside comment !!! I have got a master package which executes number of other packages. When I right click on a package and click "Execute task", SSIS respects the comments and ignores code inside it. But when I execute master package, SSIS executes piece of code which is inside comment!!! The only thing I can thi
  • Distributed ETL server
    by Chopaka
    1 Replies
    Last post by DarrenSQLIS
      • I work in the data warehouse team of my organization. We are currently rearchitecting our server environment. One of the ideas on the table is to devote a separate server for ETL processing. The databases would reside on several other servers. The ETL server would run the SSIS packages. I'm questioning if this would be a good idea. The database servers would continue to carry the load of the qu
  • MSSQL ODBC difference compared to MySQL
    by Martin Piper
    3 Replies
    Last post by Martin Piper
      • The source for this problem can be found http://www.wellytop.com/SQLProblem.zip This test creates two threads each with a database connection and uses transactions to insert values into the same table. The objective of this test is to check that a thread cannot read the results from a pending transaction on a different thread. In effect this checks dirty reads do not happen and transaction lock
  • errors in the metadata manager. The dimension with the ID ...
    by js40
    9 Replies
    Last post by js40
      • I am building an adomd .net client app which can connect to a local cube as well as a server cube via SSAS. Everything works fine on my development machine but when i deploy the solution to another user's machine I get errors accessing the local cube but no errors accessing the server cube. The code is the same between accessing the local cube and SSAS cube, the only difference is the data sour
  • Invalid Namespace error while login Report Manager
    by The Akash Jain
    5 Replies
    Last post by MihaelaE MSFT
      • I am using Custom Security Extension DLL for implementing Forms Authentication in Reporting Service 2005. While Login I am getting an "Invalid Namespace" error. After debugging it, i found below lines in the AuthenticationUtilities.cs page of the Custom DLL which is giving error. const string WmiNamespace = @" \\localhost\root\Microsoft\SqlServer\ReportingServices\v8 "; cons
  • Adding mutiple columns
    by Rajesh_M
    10 Replies
    Last post by hunchback
      • HI, I have two tables A and B with following Data Table A ------------ ID(PK) | V | W | X | Final ---------------------- 1 | 4 | 5 | 6 | output Table B ------------ ID | Par_ID (FK) | Cost_Per_Annum ------------------------ 1 | 1 | 12000 2 | 1 | 24000 3 | 1 | 14000 Output should be calculated using below the formula . output = Column V * 1st record of par_id=1 + Column w *
  • Having trouble installing SQL Server 2005 SP2
    by Judy W
    10 Replies
    Last post by Judy W
      • I tried the hotfix listed in the "Unable to install SQl Server 2005 SP2 - Unexpected error" thread and it did not work. Something I'm running into that I haven't seen here is I cannot install or uninstall anything at all. I am getting a message that says I'm still in the process of installing something, please finish that first. I assume it is the install of SQL SP2. Here is the log file
  • My doubts on revoked users in MSSQL...please reply
    by ketu0001
    2 Replies
    Last post by Steven Gott - MS
      • Hi I have following doubts: 1. Is there any stored procedure provided by MS SQL server for checking whether the user is revoked or not 2. What is the query for checking whether the particular user is revoked or not in MS SQL 3. Do all revoked users get stored in separate database in MSSQL Please reply.
  • LAN / WLAN acces 2 SQL Server from Win CE device
    by ducky12
    1 Replies
    Last post by ErikEJ
      • After an internet search I have some questions regarding SQL Server access from a mobile device via LAN / WLAN. I will write a application in C that write data to an SQL server. First if I correct that's not possible to acces an SQL server via ODBC on Windows CE What alternatives are there Stef
  • (urgent) How can I solve this error
    by Karenros
    14 Replies
    Last post by Karenros
      • Hi i am trying to implement Multivalue parameter in my report.... So for the Parameter PlanId i have selected multivalue parameter... and the avialable values are from a query... when i run the report and just check 1 Plan it works fine.. but when i go to check more than one plan.. I get this error An error has occured duing local report processing. an error has occured dur
  • ?? SQL Server 2005 Express SP2 Install Fails on Native Client ??
    by AFoxmore
    2 Replies
    Last post by AFoxmore
      • Hello all, I'm trying to install "SQL Server 2005 Express Edition SP2" on a newly installed XP Pro SP2 machine. I downloaded "SQLEXPR32.EXE" (38,220,656 bytes) from the Microsoft site. At the beginning of the setup the installation program scans my system -- no problems or warnings. Everything looks fine and ready to go. During installation I unc
  • How to get the installed MSDE and its Service Pack in a given desktop using APIs
    by Alagumani
    1 Replies
    Last post by Sam Lester - MSFT
      • Hi, I have question regarding the MSDE and its service pack information. For example, How i can get the installed MSDE version and its service pack information in a given desktop Is there any way to find the above using APIs Can anybody help me in this Thanks in Advance Regards, Alagumani Boju. Software Engineer - Developer.
  • Inserting symbols in field
    by abs
    1 Replies
    Last post by Arnie Rowland
      • Hi All, I am trying to insert symbols in a field of a table. I am using the datatype nvarchar for the field. However when i tried to insert a statement with the symbol pi, it comes out as following: (A) 100 cm2 (B) 140 cm2 (C) 200 cm2 All the pi symbol are converted to . Can ne 1 tell me how i can store such strings in the field. Thanks
  • VS 2005 - Connecting TO DB
    by ajwaka
    2 Replies
    Last post by Anton Klimov - MSFT
      • I've spent the last 2+ weeks building a website for a client on my local machine. This morning Updates were installed on my computer because it was rebooted when I came in to work. Now, I cannot connect to my DB that's in my App_Data folder using Windows Authentication. All my other local dev sites are fine! It still shows my user as being the Owner of the DB, and I can attach it to SqlServer Mgm
  • Image Graph wont show in HTML Report
    by plengski
    3 Replies
    Last post by plengski
      • I have a graph in my rdl which retrieves data from database.It works fine in report viewer and also when i export it in PDF and Excel format,but in HTML,it wont show What could i do about this,i can see in the property that it is looking for the getimage.aspx.I had tried to incorporate the code i have seen from the internet but it seems to me,that the new reporting services now dont have the metho
  • Sample coding wanted!
    by Baby programmer
    8 Replies
    Last post by Baby programmer
      • Dear all, Can anybody provide sample t-sql procedures coding to do the following tasks I want to call a sql stored procedures with parameter passing. I write down the pseudo codes as follows: In the SQL server side, write a stored procedure which performs the following: With input parameter "ABCDE"; execute SQL statement "select * from table A whe