SQL Server

Page 1982




  • Topics
    Replies
    Last post
  • Package Error.
    by coolbuddy_0
    2 Replies
    Last post by coolbuddy_0
      • Hi everybody, I have created a package which contains execution of a set of SQL Stored Procedures. I scheduled the job to run every morning at 7:00 AM. I am getting the following error: Executed as user: APD-DEV-CS517\SYSTEM. The package could not be found. The step failed. What do you think the problem is Thanks again.
  • Problem with recovering from copy database failure
    by mcnamaragio
    8 Replies
    Last post by Ekrem Önsoy
      • Hello, I was coping database from my sql server 2005 to the same server but with different name. 4 steps completed successfully but the last step failed because the computer on which sql server is running turned off unexpectedly. When the server was running again, the source database was detached. I tried to attached it but sql server is reporting error 5 (system cannot access the specified file)
  • Grouping Data for Consolidated Notification
    by Rajiv G
    3 Replies
    Last post by Rajiv G
      • We have a requirement where we need to send a single consolidated list of items belonging to a user which get active on particular date. So, for example Item 1, Item 2, Item 3 gets active. These entries are inserted as Events. Now, we need to send single notification to the user with the email as: ========================= Dear User, Your following items got active today: It
  • Having conversion issues - String to Float
    by aharuray
    6 Replies
    Last post by oj
      • I am running into some issues with conversion and would appreciate someone who can help on this. I need to roll up a column which contains numeric (float) data but it is stored in a varchar field. I was trying to do the following (please note that Activity field is varchar(50) in MyTable): SELECT CONVERT ( float , ( NULLIF ( Activity , 0 ))) from MyTable and i g
  • Where is database default location?
    by Manuel Burggraf
    8 Replies
    Last post by Tom Phillips
      • Hey, I'm trying to get the information where the databases are stored by default. With Management Studio I can look on Server Properties -> Database Settings -> Database Default locations Is there a way to read this information in TSQL Cheers, Manolo
  • Help with TSQL to combine Lastname and First Initial from Full name
    by Programmer2007
    3 Replies
    Last post by richbrownesq
      • Hello fellows, I am trying to write a query, here is the detail: I have a table of users. Table schema: FULL NAME , LOGIN example data: Anderman John, AndermaJ Williams Robin , WilliamR Foot Jay, FootJ The LOGIN field will be my resulting field after I run my query. It has a "FULL NAME" column, and a "LOGIN" column. I want to extract the first 7 characters of LAST Name from
  • extracting table schemas with nvarchar column(on 2000) from SSMS
    by Kolf
    3 Replies
    Last post by Jens K. Suessmeyer
      • Hi , when I use SSMS to extract the script for a table if the table is on a sql 2000 database and table has got nvarchar column then I will get following error message. property Ansipaddingstatus is not available for column XXXX. this property may not exist for this object,or may not be retrivable due to insufficent access rigths (microsoft.sqlserver.smo) and I am sysadmin on both server also I h
  • Ordering columns in data flow (simple?)
    by Mgale1312638
    4 Replies
    Last post by Andy Leonard
      • Hello, I am new to SSIS. I am trying to write a simple package to export data from some SQL 2005 tables and into a flat file. In my data flow, I am using the OLE-DB data source and then the flat file destination. This all works fine except that I cant get the package to write the columns out in the order I want. Even when I drive the OLE-DB source by a query, they columns are getting written to th
  • Hardware compatability
    by doublehighc
    6 Replies
    Last post by doublehighc
      • Does SQL Server Express Edition work with a Pentium M computer When I downloaded it there was a message that it wasn't the proper hardware but everything else fits the requirements for an install.
  • Accessing Custom Properties in UI
    by Carlier Lauer
    2 Replies
    Last post by Carlier Lauer
      • I am attempting to set my custom properties in the UI I have created for my custom transformation. I can access them in the ProcessInput, but if I try to assign them a new value in my UI the values dont change. I set the properties up in ProvideComponentProperties public override void ProvideComponentProperties() { // Perform component setup operations ComponentMetaData.
  • How do I edit/modify a Stored Procedure?
    by Mart&#
    2 Replies
    Last post by Martín Carreras
      • Hi, I'm from Argentina. I'm not an expert at all in SQL, I know very little about it. I've read in MSDN Library that in order to edit a stored procedure I must right-click the procedure to modify, and then click Design . I'm using SQL Server Management Studio (not Express) and I don't see any "design" option. I do see a "modify" option. I clicked there and modified just a numbe
  • OLAP processing slower with SP2
    by HappyCow
    5 Replies
    Last post by TomasLeung
      • Hi! I installed SP2 on SQL Server Standard some days ago, and unfortunately it turns out that our ETL process is now going slower than with SP1 - even OLAP processing, which suprises me a bit. The original thread in SSIS forum can be found here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1472622&SiteID=1&mode=1 OLAP processing is done using the standard Analysis
  • Granting UPDATE for only certain columns in a table
    by DanR1
    14 Replies
    Last post by DanR1
      • I have tried using the SQL statement shown below to grant UPDATE permissions for a single column in a single table to a user with db_datareader privileges. grant update (col_1 ) on trs . dbo.table_1 to calc When I then run a SQL script that has an UPDATE for col_1 on trs.dbo.table_1, I get an error message Msg 230, Level 14, State 1, Line 2100 UPDATE permission denied on c
  • The process could not bulk copy into table error
    by salah chebaro
    2 Replies
    Last post by salah chebaro
      • I have setup an 'indexed view logged' article so that I can replicate my view to a table in the destination server. I need to do transactional replication without changing the data at the destination so i used 'Keep existing object unchanged' in the article but I'm always getting 'The process could not bulk copy into table '"nnn"."musictracks1"'. any suggestions, Than
  • Removing Columns and/or Rows on Export
    by HijoDelSol
    4 Replies
    Last post by HijoDelSol
      • I have a Report I need to hide subtotals and total and include detail only when I am exporting to excel. So, is there a way to capture that it is exporting to Excel Possibly a way to capture the rs:Format=Excel
  • Connecting to Oracle on 64-bit (x64) machine
    by JoelSSIS
    14 Replies
    Last post by Sam_res03
      • Hi, Has anyone received the following error when trying to create a connection to an Oracle database using SSIS installed on a 64-bit (x64) machine "Test connection failed because of an error in initializing provider. ORA-06413: Connection not open" The reason this is funny to me is because I have the same Oracle/SSIS setup on a 32-bit (x86) machine and I can connect successfully. On both ma
  • how to get AD Id
    by gorla
    1 Replies
    Last post by larry smithmier
      • hi all, i just want to get ad id of logged in user. i have a report in which i m displaying employee list. but that should populate on the basis of logged in user. all employee which is linked with logged in user should come in this list. so please how can i get logged in users adid thanx Regards Gorla
  • multi-select dropdownlist with checkboxes
    by JIM_LANGDON
    2 Replies
    Last post by JIM_LANGDON
      • When creating a windows forms report (rdl), multi-value parameters are rendered with a nice drop down list with check boxes...including a (Select All) item. When you run this via a report server and render the report for the web, the multi-value selection shows up nicely. Can I create a similar web form dropdownlist so I can duplicate the functionality with an RDLC report Jim
  • CLR Trigger
    by Vinoth
    12 Replies
    Last post by nielsb
      • Hi,       I want to call webservice in the Trigger.  How to call the webservice from CLR Triggers .If anybody knows teh detail let me know.   And i worked out  the following Example code for CLR Trigger. using System.Data; using System.Collections.Generic; using System.Text; using System.Data.Sql; using System.Data.SqlTypes; using Syst
  • How to return a value using EXEC
    by captainsina
    3 Replies
    Last post by captainsina
      • Hi every, I am trying to write a function in SQL server to return the minimum of a specific column value. I want to pass the name of the table as an input parameter to the function. To do that I have to user string and then EXEC to run my query : set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Sina Pezeshk --
  • create endpoint fails with error 0x800704be
    by Mr Major Thorburn
    3 Replies
    Last post by Matt Neerincx
      • I am trying to create an endpoint with the code below and get the following error An error ('0x800704be') occurred while attempting to register the endpoint 'getFormsEP'. Anyone any ideas on what this error means Please help if you can. Regards, Major (that is my Christian name ;-) Code create endpoint getFormsEP state = started as http ( site='ictdwt10mt', path='/EndPoints',
  • IRR MDX Formula working in SQL2K but not in SQL2K5
    by ThinkNomade
    3 Replies
    Last post by Jeffrey Wang
      • Hi There, We previously used SQL2K and analyis Services 2K. But one calculated measure was not showing up when accessing olap cubes with Excel 2K3. So we decided to updgrade BI project to SQL2K5 platform using migration wizard. The database was updagraded successfully but not one olap cube. This olap cube performs internal rate of return IRR of a series of monthly cash-flows using
  • Vista SQL 2005 SP2 client to Windows XP SQL 2005 (non-sp2) workstation.
    by EnvisionOne
    14 Replies
    Last post by Xinwei Hong - MSFT
      • I'm trying to use SQL Management Studio to connect from a Vista SQL 2005 client w/ SP2 over to a Windows XP workstation running SQL server developer edition (non-sp2) using windows authentication. I'm already preauthenticated by network shares to the xp workstation. This worked just fine in windows xp but stop working in vista. After searching around, i found out that vista handles t
  • Management Studio question
    by Tim Mitchell
    2 Replies
    Last post by William Vaughn
      • When opening an .sdf file in SQL Management Studio, there doesn't seem to be a quick way to browse the data in a table unless I open a query and select the data. When connecting to SQL Server, I can right click the table and Open it to browse data. Is this a bug, or is it by design
  • Log reader internal
    by SQLDBAs
    14 Replies
    Last post by SQLDBAs
      • MY Current database in SIMPLE recoverey model I have set up the transactional replication. MY log reader process wakes up and runs every 5 min. Does my transactions will get deleted or they still in log file as active even it is in simple recover model. Logreader how it reads the Transaction log files . I observed today we are running some big reports. those reports uses INSERT INTO