SQL Server

Page 5303




  • Topics
    Replies
    Last post
  • Communication between two service brokers
    by Fahad
    2 Replies
    Last post by Fahad
      • I am trying to setup an alert system for our new application. Idea is to create triggers on the tables that we need updates about. When a table changes trigger will be fired and that will send a change data message to a service on a different sql server. That service will process the message and create an event in the notification services database. Notification service will later send an email
  • Getting column data in rows
    by SK362007
    2 Replies
    Last post by Manivannan.D.Sekaran
      • I have table structure with name value pair. Is it posible to get the data in row format. Example: My table has following columns: CustomerID PropertyName PropertyValue 1 Name MyCustomerName 1 Status Active 2 Name MyCustomerName2 2 Status Active CustomerID and PropertyName has the unique key And I woul
  • File Allocation Unit size
    by ffe_bob
    12 Replies
    Last post by Arnie Rowland
      • This is a question that has always intrigued me: what is the ideal File Allocation Unit Size for a disk holding only data or index pages on a server running SQL Server It seems to me that 8,192 would be the ideal size as it would enable the system to gobble up an entire page in one go. Any ideas
  • Problem with SQL (Job cannot run, Job status not updated)
    by Felix Adhitya
    2 Replies
    Last post by Felix Adhitya
      • Hi All, I would need your help please. I just installed a new fresh SQL server under Windows 2000 Advanced server SP 4 1. Firstly i tried to run normal database backup to a folder by select backup database then run manually and it ran very well. Then i tried to run it with schedule as sql backup job to the same folder. After the job was showed in the sql jobs list, i tried to
  • RIGHT OUTER JOIN
    by hrubesh
    5 Replies
    Last post by hrubesh
      • Hi, i need an equivalent code to RIGHT OUTER JOIN i do not want to use that. ex, SELECT dbo.Test1.a, dbo.Test1.b, dbo.Test1.c, dbo.Test.t FROM dbo.Test RIGHT OUTER JOIN dbo.Test1 ON dbo.Test.a = dbo.Test1.a thanks
  • Data retrieval is much slower in RS than in management studio
    by buckenn
    11 Replies
    Last post by jamvir
      • A call to a stored procedure completes in 13 seconds when ran from within SQL Server Management Studio. A report whose data source uses the same stored procedure can take as long as 10 minutes to run. The same parameter values are used in both the direct call and the report. The execution log says almost all of that time is spent on data retrieval. How could that be What might be the cause
  • Error: "EXECUTE permission denied on object..."
    by SPECIALK_BC
    2 Replies
    Last post by Brent T
      • I get this error when I try to preview a report that uses a stored procedure. The stored procedure does not exist in the database, but in the directory I run the report from. The stored procedure declares which database to use, and to create the temp table I want. Do I require special permissions on the sql db I am using to be able to create temp tables Any help would be great, thanks!
  • automated installation of Service Pack 2
    by Nath_UTSA
    4 Replies
    Last post by Sam Lester - MSFT
      • I was wondering if there is a way to automate the installation of service pack 2 for SQL Server 2005. Thanks, Nath
  • Repeat on each "page"
    by sparkymark75
    3 Replies
    Last post by sparkymark75
      • After finally overcoming a number of hurdles with LisaNicholls help, I've got one hurdle left that I can't seem to get around. A system I'm updating currently outputs attendance registers in HTML which is built using some complex ASP.NET code. To make this more manageable, I decided to try and handle this output in Reporting Services. Whilst the output looks fairly inocious and simple, in t
  • SP2 Upgrade Failure - 11032 - Unable to install Windows Installer MSP file
    by dkurak
    4 Replies
    Last post by dkurak
      • SQL Server 2005 x64 Developer Edition Log output from the SP2 installation... ------------------------------------------------------------------------------------------------ Product : Database Services (MSSQLSERVER) Product Version (Previous): 2221 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG
  • Not present on the Subscriber.
    by davidmgray_de
    5 Replies
    Last post by Raymond Mak
      • Hi all, Publisher SQL 2000 Snapshot publication timed to run at 23:00 daily All tables & views are published articles. Snapshot agent runs and creates a snapshot of all articles. Subscriber SQL 2005 Pull subscription set to run continuously Manually run the SQL agent job and I get the following error... 2006-12-11 15:04:35.687 Agent message code 20164. Unable to replicate a view or
  • How to connect to the June Katmai CTP?
    by Lars-Inge T&&a
    2 Replies
    Last post by Aleks K
      • Hi all, I'm new to the Katmai SQL Server. I have just installed the June CTP x64 developer edition on a Win2003 Server AMD x64 bit. I installed everything. The install went fine. My question: How do I connect to the Katmai There where no Management Studio in the install package. The SQL Server 2005 Management Studio will not connect. It says that it can only connect to SQL
  • Upgrade from 2000 > 2005 - cannot create Publication
    by Gavin Lilley
    2 Replies
    Last post by Gavin Lilley
      • have upgraded to SQL Server 2005 from 2000 ( to 9.0.1399). The database seems to be functioning in order, however - I am unable to crerate a publication in order to replciate the database. I am using the New Publication Wizard and see the follwoing error: TITLE: New Publication Wizard ------------------------------ New Publication Wizard encountered one or more errors while
  • To find parameter names
    by JIM.H.
    1 Replies
    Last post by Teo Lachev
      • To find parameter names In ASP.Net 2.0, how can I get what parameters defined in an rdl report file I know the report name and the report is deployed to a server.
  • Connectivity Issue
    by lamont_23
    5 Replies
    Last post by Jens K. Suessmeyer
      • I recently posted a few columns on how to connect. I figured a way, through a mapped network drive. Although this has to be temporary for the extreme nature of connecting this way. It will have to do for now. But, I couldn't get around the issue of connecting my Access 2003 to SQL Server 05. My new question is this: What do I need to do in order for the tables I created on the server side to s
  • Data validation for datetime parameter in SSRS
    by deepcr
    2 Replies
    Last post by deepcr
      • Hi, I wanted to know more about validation of SSRS parameters. I have a simple report which has a parameter called startdate of DateTime datatype. The datetime parameter in SSRS takes manual input as well. So, the user can enter any junk value. I want to ensure that the input parameter is in correct format and I want to display an error msg when the format is incorrect. My report has the fo
  • Custom Rollup formula and All Member Formula property
    by bl22
    3 Replies
    Last post by bl22
      • For SSAS 2000 ,to specify a custom rollup formula in any level except the All Level, the Custom Rollup Formula property of the level has to be used. Then to specify it for the All Level the All Member Formula property of the dimension has to be used. But at SSAS 2005, to specify it for the All Level , I dont know where is the All Member Formula property of the dimension . Anyone k
  • Ho to filter dimension in BIDS
    by Upulp
    1 Replies
    Last post by Bryan C. Smith
      • Hi, I have 2 cubes, Cube_A and Cube_B, and a common dimension, Dim_C. When I browse Cube_A I don't want to see dimension members that have some values (for example some name members that begin with caracter "A" or "Z"). How can I do this using calculation tab of "Business Intelligence Development Studion" (BIDS) (I don't want to define role on dimension) thanks
  • SQLAgent - TSQL jobs hangs (SQL Server 2005)
    by Jerid
    2 Replies
    Last post by Manivannan.D.Sekaran
      • I have two tables t_DTM_DATA_STAGING around 2 million records t_DTM_DATA around 251 million records The below SQL statement looks for records in the t_DTM_DATA_STAGING table that are not in the t_DTM_DATA table and adds them to a 3rd table. (t_DTM_DATA_STAGING2) This statement has been running fine for weeks, but now it seems to get hung every day. I ran sp_Who2 and it says the status is run
  • Is SQL Compact Edition save to use in ASP.NET Web Apps - Multi-Threading?
    by Tim F. Fischer
    3 Replies
    Last post by Brian Squibb
      • I have a question: Is SQL Compact Edition safe to use in ASP.NET WebApps And second if so, should i use transation isolation level or row locking hints to assure data quality during iniserts E.g. i want to assure that there is only one record named user2@domain2 and thus i want to make sure that my code will not fail in a mutli-theaded scenario and insert second one or
  • Select statement with dynamic columns based on data content
    by Jerry Langley
    4 Replies
    Last post by Pawel.Gr
      • What you want is a cross-tab.  If you can't embed the IDs, you'll have to use dynamic SQL for this.   See the following link:   http://www.aspfaq.com/show.asp id=2462   -- Adam Machanic SQL Server MVP http://www.datamanipulation.net --     <Jerry Langley@discussions.microsoft.com > wrote in message news:58e59fd5-61fa-4676-a
  • genetics data as cubes
    by nshs
    3 Replies
    Last post by David Beavonn
      • Dear all, Has anyone used Analysis Services on Genetics Data I would like to communicate with someone who is implementing or has implemented analysis services on this kind of data. Thanks Ashish  
  • Can't add a sibling or child to a member in a dimension
    by adandreamohr
    2 Replies
    Last post by adandreamohr
      • Following the Foodmart tutorial, I get to a point where I create a parent-child dimension and I browse data. Then I have to add a sibling or a child by right-clicking a member and selecting "New member" (all in the Dimension Editor). However, nothing happens on my right-clicking, no context menu at all. Could it be a versioning issue I'm using SQL Server 2000 Standard edition. I already
  • SSRS not responding ASSERT: Assertion failed
    by Hari Ganeshan
    8 Replies
    Last post by Robert Bruckner MSFT
      • Hi all I am facing this prob with SSRS. please sugges any solution. Problem : I have a few reports deployed on the report server. When I click them I get the following error An internal error occurred on the report server. See the error log for more details. (rsInternalError) Checking the log file has the following entries w
  • Foreach endless loop
    by thames
    14 Replies
    Last post by thames
      • I'm having a problem where I'm using a Execute SQL Task to retrieve a dataset and storing that in an object variable. Then on success of that execute sql task I use a foreach loop task to go through the dataset and do 2 tasks inside the foreach loop. When I execute this package I have ~12 records in the dataset however when I get to the foreach loop in the 2nd iteration it keeps repeating it. It a