SQL Server

Page 3402




  • Topics
    Replies
    Last post
  • ExceptionMessageBox
    by S1monk
    13 Replies
    Last post by jaegd
      • I am trying to get the Exception Message Box to work in a script task in SSIS. I am using the example from http://msdn2.microsoft.com/en-us/library/ms166340.aspx almost verbatum. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.MessageBox Public Sub Main() '
  • Reporting Services authenticating with Analysis Services
    by pavel_hlobil
    2 Replies
    Last post by Pavel Hlobil
      • Setup: Reporting Services and Analysis Services are on the same server. Active Directory User. Default configuration of Reporting Services. Problem: Reporting Server does not apply Analysis Services Role after login. Details: I have created a report that retreives data from the Analysis Service. I created a role and added my user company/myUserName to the role. On the Reporting Server
  • custom plugin error: how to pass information to Mining Model Viewer?
    by Renan Souza
    1 Replies
    Last post by Bogdan Crivat
      • Good morning, Well... As I said in other topics, I'm doing a clustering plugin for text mining. I'm facing many problems and, with your help, solving them one by one. First of all, thanks a lot again. Well... I've made a clustering function that is actually working very well. But I'm exporting its results to a log file I use as an algorithm trace for debugging. My clustering method ret
  • Documents in VLDB
    by Ike Ross
    11 Replies
    Last post by ggciubuc
      • Hello All, I have been experimenting with SQL Server 2005 partitions. I loaded a terabyte of information into 2 tables. The first holds the document information and the second holds the actual binary document (in this case pdf). Most of the documents are about 1 megabyte in size, but the largest is 212 megabytes. SQL Server has no problem storing the blobs. The problem oc
  • replacing Null values with 0's in Matrix
    by techie234
    4 Replies
    Last post by sluggy
      • Hi, I am newbie to reporting services and I need some help. Could any one please let me know how to replace Null value with 0 in the data section of the Matrix. I don't want blanks to be displayed on the report, I want those to be replaced with 0's. Thanks for your time.
  • TSQL - Retrieving my Databes index (list)
    by ajliaks
    3 Replies
    Last post by ajliaks
      • Hi guys, If I have an SQL connection called "SERVER" and into SERVER I have five different Databases like "DB1" "DB2" "DB3" "DB4" "DB5" (each one with it's own Tables / Views / Functions / etc) How can I get the DATABESES LIST Thanks in advance, Aldo.
  • Handling errors returned by SSRS
    by cvajre
    7 Replies
    Last post by Teo Lachev
      • We are displaying the report in our reporting application but we do not want to display errors from SSRS to the user. We want to handle the errors and display a user friendly message. How can that be done . We are making URL access to the report server. Thanks.
  • subcube functions
    by hmayer
    1 Replies
    Last post by Mosha Pasumansky
      • does subcube functions respect the current subcube if I nest them inside a scope Like FREEZE - I guess not LEAVES - I guess yes Is it true if I guess - Scripting Statements - no - Functions - yes HANNES
  • EDI file output
    by jadoger
    1 Replies
    Last post by Phil Brammer
      • any good example of extracting data from sql server 2005 in EDI file format I need to generate EDI files from sql server thanks
  • Client Components Fail to Install - UPDATE
    by nielsb
    5 Replies
    Last post by nielsb
      • Me as well can not install the client components on boxes that have CLR 2.0/Office 2007 already installed. Notice that the failures have occured on boxes that doesn't have any SQL Server 2005 components installed. I do not know if it is CLR 2.0 or Office that causes the failures. The error I'm getting initially is the same as Bogey1 and willgart: " Upgrade failed due to the following error
  • Help: how to generate sql statements according to parameters in a table-valued function
    by Ricky Wang
    1 Replies
    Last post by Louis Davidson
      • I need to enchance the following function: create function dbo . GetCustomersByRegion ( @PageNo integer , @PageSize integer ) returns table as return ( select * from ( select row_ number () over ( order by customerid ) as row_num , * from customers ) a where row_num >= @PageSize * @PageNo and row_num &
  • public key in certificate
    by purusingh
    0 Replies
    Last post by purusingh
      • <code> CREATE CERTIFICATE SalesCert encryption by password = 'blabla' WITH SUBJECT = 'Sales cert', EXPIRY_DATE = '10/31/2009' GO </code> When I create certificate using such tsql where is the public key.
  • Truncate database tables based on foreign key constraints
    by Amsri
    1 Replies
    Last post by Philip Kelley
      • Guys, I have 600 tables in my database, out of which 40 tables are look up value tables. I want generate truncate scripts which truncates all the tables in order of Parent child relationship excluding lookup tables. Is there any way to do this apart from figuring out Parent Child relationship and then writing the truncate statements for each of the table. For example EmployeeDetail table referenc
  • Problem with Lesson 3 in the Analysis Services Tutorial
    by joney
    2 Replies
    Last post by Mary Potapova
      • I am at the step of "Adding an Attribute and Defining Display Folders" where I am experiencing problems. The steps are: 2. In the Attributes pane, select the following attributes by holding down the CTRL key to select multiple attributes, and then in the Properties window, set the AttributeHierarchyDisplayFolder property for the selected attributes to "Location": ? City ? Coun
  • Connector between executables dissapears
    by London79
    3 Replies
    Last post by EuphoricHed
      • Dear Forum Members. I am currently using Visual Studio 2005: Business Intelligence Development Studio to create an Integration Services Package. The package contains several containers, within each container there is a ¡®foreach loop container¡¯ and within the ¡®foreach loop container¡¯ there is a script component, execute component and another script component. Each of the three components i
  • Need to Subtract the result of two stored procedures
    by ink innovations
    13 Replies
    Last post by ink innovations
      • I am trying to take the results from two stored procedure and subtract them to get credit from two columns. The stored procedures look like create PROCEDURE mw AS select * FROM pla p where p.st in ('ds', 'sd') and (iPlayerID = '5345') compute sum(p.amount) RETURN both procedure have the same syntax. I am not able to use AS in to insert the values into a variable. Is there a wi
  • SSIS Logs Vs Custom Logs components
    by spattewar
    3 Replies
    Last post by spattewar
      • Hi, In my case I have to log the errors raised by any task in a package to either windows event log, text file or SQL server. Also I need to send an email notifications to a group of people telling them about the error. Now can I use SSIS package logging for logging the errors into the required destinations. I mean right clicking on the package and selecting Logging, then adding the required
  • Parse text file (csv, fix width), Perl or something newer?
    by ydbn
    6 Replies
    Last post by MatthewRoche
      • I need to parse some text files and load them to database - these files are mostly CSV files or fix width columns format and the column names (first line) may vary in text (e.g. different abbreviation), order and extra columns, etc. Is it a good idea have this done using script task of SSIS How it compare to Perl on performance Or any other tools good for this
  • protected sql database file
    by Romantic_touch
    7 Replies
    Last post by Hemantgiri S. Goswami
      • how can I create sql database file and it cann't be use or open (open mean to design view or structure) . my case is: I have Acces db and this db has its own username and password, no body can read, write or view the designing, so it is useless. But there are somesoftware able to break and hacking db access. I think sql database file is more secure, so how can I do it
  • Old Excel files after SQL2000 > SQL2005 migration
    by P&amp;#228;r Hedberg
    14 Replies
    Last post by Par Hedberg
      • Hello there! We are having some problems over here after our SQL2005 upgrade. If we try to use an excel file that previously accessed the SQL2000 database (same DSN name and credentials), and then try to refresh the data after the 2005 upgrade, we get the errormessage "[Microsoft][SQL Native Client][SQL Server]User 'DOMAIN\username' does not have permission to run DBCC TRACEON."
  • Dynamic SQL Cells
    by Trekkie_SG9
    3 Replies
    Last post by Arnie Rowland
      • How can I make the values for certain cells in a table in a database show the day a folder was created On the same note, How can I make other values in other cells change (say the values 101 through 200 had to change to 1-100)
  • Database mirror certificate expired
    by David Dong
    7 Replies
    Last post by lrod
      • anyone has the experience to solve this
  • create local cube issue
    by olap_user
    7 Replies
    Last post by olap_user
      • Hello everyone, I have a problem in creating the local cube in MSAS2005. This is what I have done please guide me to solve the issue. Steps: We have installed MSAS2005 with SP1 on Dev box I created cubes on BI Studio (linked to dev box from my local pc) I can see the cubes from MSMS (linked to dev box from my local pc) Then I tried to CREATE GLOBAL C
  • Seek in a SQL table from Access
    by WesJD
    4 Replies
    Last post by Mike Wachal - MSFT
      • I have an MS Access 2003 database from which I want to seek a specific record in a SQL Server Express 2005 database. I can connect to the table and get a recordcount but the recordset.supports (adseek) and recordset.Supports(adIndex) both return false. Any suggestions Specific code I'm using is as follows: Dim cnxn As ADODB.Connection Dim strCnxn As String Set cnxn = New ADODB.Connection
  • SQL2005 64bit, snapshot creation error
    by Legi0n
    2 Replies
    Last post by Legi0n
      • I'm running SQL Server 2005 SP2 64bit under Windows Server 2003 64 bit The system is the replication distributor as well. Transactional replication. But I can't create the snapshot! I have run snapshot.exe repeteadly with all parameters in a command prompt and it crashes at various BCP percentages. The error is like this: 2007-10-16 00:38:56.32 [10%] Bulk copied snapshot data for article 'Dictiona