SQL Server

Page 2119




  • Topics
    Replies
    Last post
  • Database Restore
    by *565222
    1 Replies
    Last post by Madhu K Nair
      • A backup of a database from a server replaces a similar database when I restore it on another server. What I want is to add to the existing data and not to replace it. How can I overcome this situation Please I sincerely need your help.
  • counting records in all tables
    by VuaCorona
    11 Replies
    Last post by AKMEHTA
      • Hello all,    I was wondering if there is anyway to find number of records in all tables instead of count one table at a time by select count(*) from table_name. thanks  
  • Add mode problem on field setup with Foreign Key
    by
    1 Replies
    Last post by drkbl
      • Hello, I have two tables (one-to-many relation) related thru a common key. I have setup the Relation using the Database Designer. The Form is populated using Drag-and-drop which automatically adds the BindingSource, TableAdapter, and Binding Navigator. The Relation works great in the change mode, and life is good. In the Add mode the field setup with the Foreign Key is not automatic
  • Running Totals
    by NLC4241
    5 Replies
    Last post by Hammer2
      • We are trying to create a report that shows a Week to Date, Month to Date, and Year to Date Week to Date Month to Date Year to Date Item Number I've tried using an if statement (if date = current week, Qty, 0) and then sum the data but I get an error message that reportitems can only be summed in the page header and footer. I've also tried running to
  • Reporting Services how do I disable a drop down box
    by dwemh
    1 Replies
    Last post by JDee
      • Hi, SQL Server Reporting Services 2005. I have a tick box that is required to enable or disable two associated drop down boxes. Example: Tick box has 2 associated drop down boxes. The drop down boxes list details of Area from a database. The Area is linked to Properties. This allows the selection of Properties to be filtering by Area. Ticking the tick box allows the user to select from th
  • connection problem at remote server
    by sureshv
    10 Replies
    Last post by Phil Brammer
      • i use connection to connect to a remote sql server.Here are the details provider :Native OLE DB/SQL Native client Server :ip address database elect respective database authentication ql server i have a problem and it comes up with this message "Test Connection failed because of an error in initializing provider.Login timeout expired.An Error has occured when establis
  • Login failed for user Domainname\computername
    by Santhosh Pallikara
    7 Replies
    Last post by Raul Garcia - MS
      • Hi, I am using SQL Server 2005. The below message is added to the Application Event Viewer frequently. Failure Audit: Login failed for user "abc\xyz$". (Client: xx.xx.xx.xx) abc is my domain name and xyz is my computer name. When I look @ the SQL error logs, I find the following message: Error 18456 Severity 14 state 11 Login failed for user "ab
  • T-SQL how to output to file system.
    by Dietz
    4 Replies
    Last post by Dietz
      • Hi There This is for Sql Server 2005 Express Advanced Services SP1. I have data in a varbinary(max) column in the database. I want to output this column to a filename to a directory on the file system. How can i do this I do not want to use CLR or SSIS. Thanx
  • Determining Table Name from TableID in Cube Partition
    by Marek Stefanek
    3 Replies
    Last post by Matt Carroll
      • Hi all, I am trying to determine source table name of the cube partition using AMO. I am able to get the partition source (which is of {Microsoft.AnalysisServices.DsvTableBinding} data type). There I can see the TableID property, but not the table's real database name. (TableID has dot between database schema and table name replaced by underscore). Is there a way how to translate TableID into its
  • How to encryt a Date field??
    by ks06
    3 Replies
    Last post by Sung MSFT
      • How do we encrypt/decrypt a datetime field For e.g. Date of Birth
  • SSRS Newbie - How to display "rich" text in a report
    by opinez_michael
    2 Replies
    Last post by niallhannon
      • Hi (Note when I say "rich" text I don't specifically mean rich text , I'm refering to text with user defined bold, italic, numbered lists, colors, fonts, etc.) We have a (new) system where we want a user to enter "rich" text notes into a single column using an editor embedded in our application (much like the editor I'm using for this forum) and have the notes dis
  • problem conecting to sql express from vis studio
    by hwiz
    6 Replies
    Last post by Andrea Montanari
      • hello please can somebody help me. I downloaded sql express a couple of days ago, first time using it. I want to connect to it from visual studio , but i get an error message. I can connect to an access database fine. The Message i get is as follows from within visual studio 'generating user instances in sql is disabled. use sp configure 'user instances enabled' to generate u
  • Execute Process Task using StandardInputVariable
    by SpinDisc
    7 Replies
    Last post by jwelch
      • Greetings! I am using a Excute Process Task calling a selfwritten EXE and I'm trying to pass a command line argument to it. The code for the EXE is quit simple: Public Sub Main() Try Dim info As String = My.Application.CommandLineArgs.Item(0) MessageBox.Show("Info:" & info) Catch ex As Exception MessageBox.Show(ex.ToString) End Try End Sub According to the help fil
  • Credentials problem or deployment puzzle or permission problem?
    by henry.han
    1 Replies
    Last post by henry.han
      • Hi,All: I had development a reporting service home page for our intranet . And I deployed this home page at "domain.server1" (for example) and my sql server database and reporting service is at another server "domain.server2"(for example). on the "domain.server1" , the Authentication methods is Integrated windows authentication. and on the "domain.server2&
  • PRINTING REPORTS
    by DotNet_Guy
    5 Replies
    Last post by LAS
      • Is there a way to save print settings with the report so that settings such as the size of paper (A4, legal...) and layout (landscape, portrait) do not have to be specified by user everytime she wishes to print the report
  • SQLExpress Reporting Services and Casini
    by Randolph
    1 Replies
    Last post by Mike Wachal - MSFT
      • I haven't looked into the detail and thought perhaps someone else had... Here's my question... In a custom winforms app using SQLExpress, can the SQLExpress Reporting Services implementation be made to use Casini or another IIS "light" in environments where IIS is not installed or available If so, how For me, having to run full-blown IIS for SQLExpress RS kinda runs counter to the
  • Bad results from my MDX Adventure Works query
    by Wildert
    3 Replies
    Last post by Deepak Puri
      • I have an Adventure Works MDX query that I want to return all the male employees and their total reseller-sales (including the people below them) Select [Measures].[Reseller Sales-Sales Amount] on Columns, non empty Exists( [Employee].[Employees].AllMembers ,[Employee].[Gender].&[M] ) on Rows from [Analysis Services Tutorial] which, when run, returns Reseller Sales-Sales A
  • Secondary Replication test <Please Ignore>
    by bChristophel
    1 Replies
    Last post by bChristophel
      • Final Check.
  • How Can I add a linked server with IP address only(Not server name)
    by J Ma
    2 Replies
    Last post by J Ma
      • Hi, there, I am try to add a linked server to one of my server. the problem is, those two servers are not on the same network. I have to put in IP address as linked server name. I added the server OK, but when I do the query, I have to put the server name in the query, which caused error. say the IP address of the linked server is 64.253.133.100 the query looks like, select * from 64.253.133.100.
  • ReportServicesConfigUI.WMIProvider :The RPC is not listening error :when config reporting srv 2005 please help
    by naijacoder
    4 Replies
    Last post by naijacoder
      • I have been using Sql server Reporting services 2000 and i never had these problems I tried firing up my Sql server Reporting services 2005 today i went through the reporting services conf manager and then got to the "database setup" stage and bingo can't get through this error below * On my PC i have Reporting services 2000 and Reporting services 2005 installed and my is work
  • Inserted Rows count from SSIS not like table Rows Count
    by Hossam Abdel Wahab
    5 Replies
    Last post by Phil Brammer
      • Hi all i using lookup error output to insert rows into table Rows count rows has been inserted on the table 59,123,019 mill table rows count 6,878,110 mill ............................ any ideas
  • Database Design
    by Paul60
    6 Replies
    Last post by Paul60
      • I could not decide where to post this question -so- I thought I would try here first... I am looking at a database design and would like some comments on what some "competent" database people might think - any suggestions, etc. The tables have been 'normalized' and there are some 300 tables. The application is a club membership system and will maintain member data such as name, address,
  • Installing Sql server 2005 Compact edition
    by ofer ebert
    6 Replies
    Last post by ofer ebert
      • I have a PDA application that manage a database. My application uses Sql server 2005 Mobile edition and I want to change to Sql server 2005 Compact edition. I have an application that automatically upgrade new version of my software at users (customers sites) It is shipped on a memrory card (SD Card). I want in my upgrade tool to install Sql server 2005 Compact edition so I do it by ru
  • Invalid number of result bindings returned... Help Please
    by crodrig
    0 Replies
    Last post by crodrig
      • Hello, I am very, very new to the world of SSIS and from a totally different platform (iSeries), learning, digging and finding golden nuggets as I go. Two questions please. Question One: I am presently encountering the following exception. SSIS package "DW.CUST_CNCL_ORD.dtsx" starting. Error: 0xC00291E2 at BP Parter Exec SQL, Execute SQL Task: There is an invalid number of result bindi
  • Using NOT EXIST to get Results of Accounts That have never been used.
    by LUISCARLOS
    10 Replies
    Last post by LUISCARLOS
      • Write a SELECT statement that returns two columns from the GLAccounts table: AccountNo and AccountDescription. The result set should have one row for each account number that has never been used. Use a correlated subquery introduced with the NOT EXISTS operator. Sort the final result set by AccountNo. Thank you for taking your time to post your answers.