SQL Server

Page 3008




  • Topics
    Replies
    Last post
  • Report Builder and optional parameters
    by Wapper
    14 Replies
    Last post by elibet
      • Hi, Is it possible to create optional parameters in Report Builder An *ordinary* parameter is created by marking a filter expression as "prompted". At run-time, the user will be asked to provide a value for this parameter (or accept a default value if it is available). This works fine. What I want is to let the user choose whether to provide a value, or leave the parameter empty. I
  • Error - SQL Server requires Encryption On
    by JackW9653
    3 Replies
    Last post by JackW9653
      • Hello All, I have a commercial application built for Pocket PC's that connects to SQL Server 2005 via TCP/IP over wireless networks. In installations for our sales people we installed SQL 2005 Express on their notebooks for demonstrations. In one of these installs we are getting the following error message: "An error occurred - SQL Server requires Encryption On". We do not use enc
  • Applying snap shot at subscriber from DVD on SQL 2000
    by PhilD62154
    3 Replies
    Last post by Hilary Cotter
      • I want to send snap shots by DVD to a SQL2000 server from SQL2005. This config is replicating fine using trans replication with the publisher and distibuter on the source SQL2005 server. I am using push subscription to the SQL2000 server. I now need to create snap shots on the SQL 2005 server that I can send to the SQL2000 server using DVD. I know how to create the snap shot on the SQL2005 server
  • How can i encrypt or mask a column in the database
    by Karenros
    3 Replies
    Last post by Laurentiu Cristofor
      • How can i encrypt or mask a column in the database Any help will be appreciated Regards Karen
  • Maximum size of the SSIS String Variable?
    by Clay Smith
    8 Replies
    Last post by Leon Ford
      • In SSIS, what is the maximum size of the String variable (one that you would define in the Variables dialog box)
  • Enterprise Manager returns [MS Visual Database Tools] - The parameter is incorrect when returning all rows
    by Xanothos
    3 Replies
    Last post by Satya SKJ
      • When I try to return all rows from a view or table by selecting Open Table|Return All Rows from the context menu, I get a dialog in the middle of EM stating: An unexpected error happened during this operation. [MS Visual Database Tools] - The parameter is incorrect. Any ideas
  • DataFlow Update?
    by paburgos
    7 Replies
    Last post by jwelch
      • Hi, I'm wondering if it is possible to make an update of a specifics rows in a database table using dataflow tasks thanks
  • New Log or append?
    by TagTech
    4 Replies
    Last post by TagTech
      • I'm backing into the DBA position from being an app / web designer. Using SQL 2005 and hating wizards, I'm trying to code a BACKUP LOG query to run every 15 minutes and create a separate date-time-stamped TRN. I have several questions starting with - should I be doing this Is it better to create separate LOGs or append to one Isn't it true that the only time I'll need the LOGs is when I have a c
  • JIT Debug HELP
    by MarcPacker
    2 Replies
    Last post by MarcPacker
      • See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at HP.CUE.Video.PlaybackControl.UpdateProgressBar() at HP.CUE.Video.PlaybackControl._ProgressTimer_Tick(Object sender, EventArgs e) at System.Windows.Forms
  • Displaying member name instead of key in query
    by Andrew Sears - T4G
    2 Replies
    Last post by Andrew Sears - T4G
      • In the tools that I have used for getting generated MDX queries (Query Analyzer, Proclarity, Excel) the query always seems to show the key value instead of the member name. Is it possible or is there a query tool that will generate queries with the member name instead See example: [Organization].&[152551] Should read [Organization].[By Division] thanks, And
  • Simple select statement gone wild!!
    by Tim1022
    10 Replies
    Last post by Tim1022
      • I am very new to sql and would like some help with a simple select statement. I am trying to pull birthdates using the following code. I can get the query to run but some of the dates are not between the parameters. What am i doing wrong SELECT Employees.EmployeeStatusID, People.FirstName, People.LastName, People.BirthDate FROM Employees FULL OUTER JOIN People ON Employ
  • Missing DLL during installation
    by Al Williams
    1 Replies
    Last post by Al Williams
      • XP PRO SP2 I downloaded and installed SQL Server 2005 Express with Advanced Services (9.0.3042.0). The installation appeared to complete successfully and I looked at various options of Management Studio. After exiting, rebooting, and restarting Management Studio, I got the message, (paraphrased) Management Studio failed to initiate - terminating. After using Add/Remove to remove all installed c
  • Issues importing from Visual FoxPro 7
    by ed_hand
    0 Replies
    Last post by ed_hand
      • I'm trying to bulk load tables in SQL 2005 from a Visual FoxPro 7 database. We have the latest VFP OLE DB driver loaded and have run into an odd issue. When viewed from the table designer in VFP the tables have all columns set to not null (null column is not checked). However there are lots of rows with "empty" values for columns with both numeric and date data types. When I selec
  • problem in connecting to sql server Express
    by Amjath
    13 Replies
    Last post by William Vaughn
      • Hi to all, i'm installing sql server in my pc as netwrok service. when i try to connect it, it showing me a error sql server does not allow remote connections error 26 error locating server/instance (MS Sql server ) how can i resolve this plz help me out. it not able to connect the server locally. when i try to connect it with .\SQLEXPRESS or localhost\SQLEXPRESS it will connect to the DB But when
  • Drilldown/interactive chart
    by Chandbi
    7 Replies
    Last post by Deepak Puri
      • Hi Friends! I m working on a learning BI project in MS Analysis Services 2005.I have designed a cube having tea production quantity as measure and district,garden,time are dimensions.This cube is designed to analyze tea production of several gardens of a producer. Here is the relation between measure and dimension: A GARDEN(Dimension) of a DISTRICT(Dimension) produces certain amount
  • Calcaluting total nu of people based on their name field
    by shamen
    14 Replies
    Last post by Adam Tappis - IMGroup
      • I want to create a report which should be looked like this. Members Joined Members Borrower Depositor Members Joined Yesterday 8 4 4 Members Joined Last 7 days 39 20
  • generate report using recordset
    by AmitKa
    7 Replies
    Last post by Teo Lachev
      • I am generating crystal reports using recordset in ASP.Now i want to generate the report using reporting services 2000 with the same recordset.how can i do this.pls suggest me. Thanks
  • Slowly Changing Dimension [58] Error
    by Jegant
    3 Replies
    Last post by Rdjaramillo
      • i am using SCD to insert or update .my source and destination table are Oracle and i am using Orcale OLEDB provider . i am getting the following error while executing the package.what could be the solution [Slowly Changing Dimension [58]] Error: An OLE DB error has occurred. Error code: 0x80040E5D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult:
  • bug: name change of connection manager is not propogated through package
    by adolf garlic
    5 Replies
    Last post by Bob Bojanic - MSFT
      • create a package with a connection manager reference the manager with a bunch of tasks change the name of the manager stand back in disbelief as you receive the following message Error: 0xC004800B at Data Flow Task, DTS.Pipeline: Cannot find the connection manager with ID "SourceConnectionExcel" in the connection manager collection due to error code 0xC0010009
  • Default date '1899-12-30 00:00:00.000'
    by AC_28
    6 Replies
    Last post by Darren Gosbell
      • Hi, Date field in one of the tables is Nullable. Some rows contain NULL while some other have it as '1899-12-30 00:00:00.000' While processing the cube on this table, both NULL and '1899-12-30 00:00:00.000' get converted to Blank. Does anybody have any idea why this happens and if there is any workaround to show values exactly as they are. Thanks.
  • DT_I8 versus DT_UI8
    by 1Dave
    8 Replies
    Last post by Phil Brammer
      • Can some one tell me in basic terms the difference between a signed and unsigned integer When would you decided to use one over the other I'm looking for it more in layman terms than a technical bit level discussion.
  • Results to row instead of column
    by Dan Crowell
    6 Replies
    Last post by Umachandar Jayachandran - MS
      • Is there a Transact SQL statement I can use to get my results in a row instead of a column I thought of PIVOT but couldn't get it to work. I think I have done this before but I cannot remember to keyword to use. For example: SELECT TOP 3 [FirstName] + ',' FROM [AdventureWorks].[Person].[Contact] This query returns: Gustavo, Catherine, Kim, I would like it to return: Gustavo,Catherine, Kim, Tha
  • Microsoft Access Database Synchronizer (ADS) RTW
    by Laxmi Narsimha Rao ORUGANTI MS
    14 Replies
    Last post by Manish Agnihotri
      • Hi, Today we are very pleased to announce the RTW release of Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly. Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Compact Edition database on a device. The salient
  • how to delete text file
    by shacky
    11 Replies
    Last post by shacky
      • hi... how to delete text files from c drive (ex: c:\sale\300407.txt) using ms sql express edition 2005 plz help me...
  • Visual Studio Query Designer Date Function Bug?
    by Judah2
    2 Replies
    Last post by Ambrish Mishra - MSFT
      • In the Visual Studio Query designer against a ce 3.1 sdf file, if I type in SELECT DATEPART(yyyy, GETDATE()) AS Expr1 FROM CropYear The designer updates it to SELECT [DATEPART](yyyy, GETDATE()) AS Expr1 FROM CropYear Which results in an error SQL Execution Error. Executed SQL Statement: SELECT [DATEPART](yyyy, GETDATE()) AS Expr1 FROM CropYear Error Source: SQL Se