SQL Server

Page 1980




  • Topics
    Replies
    Last post
  • Partitioning tables and filegroup stuff
    by enric vives
    2 Replies
    Last post by enric vives
      • Hi everyone,   Primary platform is 64-bit on A-P cluster.   Our needs are on yearly basis and on monthly basis. We're forced to keep up five years for the majority of the production tables. In terms of years, I see three ways:   1.Create all the ranges for a FILEGROUP with a only NDF   2004, 2005, 2006 => FG1 =>   ONE
  • Distriubtion Error on Stored Procedure
    by Linda Cornerstone
    6 Replies
    Last post by Linda Cornerstone
      • Setting up Transactional Replication. Log Reader Agent successfull. Snapshot Agent successfull. Distribution Agent Error (Replication is failing because of this error. I don't know what is wrong with the stored procedure that causes it not to replicate): Date 1/19/2007 10:28:13 AM Log Job History (IS36-MMS_20061213-MMSRepTest-IS4-30) Step ID 2 Server IS4 Job Name IS36-MMS_20061213-M
  • DB mail is not working
    by sanoj_av
    4 Replies
    Last post by Amit Banerjee - MSFT
      • Can anybody help me to find out w hat is wrong with the following code I was trying to configure DB mail in SQL SEREVR 2005 developer Edition. I am getting a message 'Mail queued.',But No message is being sent to receipient. My dataBase is running on Windows 2000 with SP4 and I am using the 'sa' database user account. -- Create a Database Mail account EXECUTE msdb . dbo . sysmail_add_
  • Return Duplicate Rows
    by Tryin2Bgood
    14 Replies
    Last post by Tryin2Bgood
      • I want to select all my columns that have the same number twice....but i dont know how....I tried doit it this way   Select Distinct sti . parent_topic_id , st . description_short , sti . sort_order , count ( st . description_short ) From sam_topic_items sti Inner Join sam_topic st On sti . topic_id = st . id Where st . type = 'Topic' Group By sti .
  • help?
    by textman
    6 Replies
    Last post by c blunt
      • I need a little help to get me going. I have built a web app in visual web developer and made and inserted an sql db into the site with multiple .aspx pages. It all compiles and seems great. Info from the db is displayed,however when it comes to edit,  insert or delete it bombs out "   incorrect syntax near'nvarchar'  or on delete........'int'   some thi
  • Help With a Calculated Member Calculation
    by donnie100
    1 Replies
    Last post by Jeffrey Wang
      • Hello, I have a fact file that includes a measure called Credit Hours. I also have a dimension called DimTerm what includes time data for two terms: 05Fall and 06Fall. My goal is to get a number change between 05 and 06 terms. So I created a calculated member with the logic below but my percentage change is always %0.00. Maybe someone knows a way of doing this through MDX which would allow me t
  • how to set permission for a database
    by sridhar_msd
    4 Replies
    Last post by Raul Garcia - MS
      • hi, I need to do a security setup in SQL server 2000. the scenario is as follows: In a team, only one person(Team Leader) should access the particular DB (through Enterprise Manager and rest of the persons in the Team(developers) should access through code. How to do this. Thanks and Regards
  • creating dynamic translation
    by eyalso
    1 Replies
    Last post by Adrian Dumitrascu
      • hi is there a way to create a dynamic translation for a cube i have another table that translate words and i want to that the cube dimensions names and the measures name will translate by the table i have is there a way i can do it Thanks Eyal
  • How to define the periodicity_Hint value
    by Helen999888
    5 Replies
    Last post by Helen999888
      • Hi, all experts here, I am having a question on defining the value of Periodicity_hint. e.g, I wanna predict the monthly sales amont of a product, and assume the data follows monthly patterns, then in this case, what value should we set for the periodicity_hint parametre Thanks a lot for your kind attention and I am looking forward to hearing from you shortly. With best regar
  • Show groups with empty data
    by Zoz
    5 Replies
    Last post by JacekS
      • Hello everybody, I have a matric that looks like this : SALES RETURNS Client1 100 50 Client2 40 0 But when there is no returns in the month, the column returns isn't displayed. So I get this: SALES Client1 100 Client2 40 How can I show this column even with empty data Thanks in advance for your help. Zoz
  • Number of Reads in Profiler
    by Babu P P
    4 Replies
    Last post by Madhu K Nair
      • Hi, Can any of can explain, what the "Reads" column in Profiler exactly mean I'm not comfortable with the explanation given in BOL. "The number of read operations on the logical disk that are performed by the server on behalf of the event. These read operations include all reads from tables and buffers during the statement's execution" For the same procedu
  • MDX Calculated Member to Use in Excel
    by David_Lindley
    14 Replies
    Last post by David_Lindley
      • Hi, I have a calculated member defined in AS2005 as follows: ( parallelperiod ([Time].[StartTime].[StartYear],1, [Time].[StartTime]. CurrentMember ),Measures.Profit) I am then using this in a Excel 2003 pivottable, with the [StartTime] hierarchy as a page field. This works fine when I am selecting a single member i.e. 1 quarter, 1 month, 1 week etc. My problem arises when
  • need help on adding and deleting rows?
    by Stabilos
    9 Replies
    Last post by Stabilos
      • Hi, i am trying to create a statement that would add the values together for Hong Kong and China and then delete the Hong Kong road. (this is a example what i am trying to acheive) anyone know how to do this. Name Area Population China 54546554 545845110 Hong Kong 1222 1212 United K
  • Gap between header and Body
    by Raj Deep
    3 Replies
    Last post by Techquest
      • Hello every body, I am facing a smal formatting issue. the issue i have 7 text boxes attached with each other in the header to show the week days ,i.e Sunday,Monday,Tuesday,Wednesday,Thursay,Friday and Saturday In Body,i have a matrix which will extend to have 7 columns for the weekdays. Every thing is fine,Except a small gap between header and footer where i want the 7 text boxes to act
  • AcquireConnection returns null value
    by Reni Merceline
    2 Replies
    Last post by Reni Merceline
      • I have the following code in my custom source component's AcquireConnection method - if (ComponentMetaData.RuntimeConnectionCollection[0].ConnectionManager != null) { ConnectionManager cm = Microsoft.SqlServer.Dts.Runtime.DtsConvert.ToConnectionManager(ComponentMetaData.RuntimeConnectionCollection[0].ConnectionManager); ConnectionManagerAdoNet cmado = cm.InnerObject as ConnectionManage
  • DatabaseDefaults Policy (not working?)
    by SteveBouff
    3 Replies
    Last post by SteveBouff
      • I created the following policy. It's a basic policy for enforcing database settings. I then created a database in violation of the policy and didn't generate an error. I also altered the database to violate the policy and still didn't get any policy errors. alter database test2 set auto_close on < xml version="1.0" encoding="utf-8" >
  • Database error messages
    by Night2Dark2
    1 Replies
    Last post by Night2Dark2
      • Hello I keep getting Various database connections in MSMSE. The error is Micorosoft SQL server management studio express error TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&LinkId
  • Designing category system
    by Kapalic
    2 Replies
    Last post by Kapalic
      • Hi, I am trying to design tables for managing category system. In my inventory management system, I have a receive form, where I have to enter a product from a subcategory of a category. I can't figuire out how should i design my tables. Am I correct with these tables - Products Table - ProdID, ProdName, CatID, SCatID Category Table - CatID, CatName SubCategory Table - SCatID, SCa
  • SQL Server Management Studio Express - Cannot show requested dialog - Could not load the DLL xpstar90.dll
    by janid1967
    1 Replies
    Last post by Mike Wachal - MSFT
      • Hello all Major problem with my SQL Server Management Studio Express installation on XP Pro edition SP2. My problem is that I can't use "functions" in Object Browser, for instance right-click -> Properties, at a object. Some problem with Create Login, Create Database, Create whatever ... Error message with following text popup. ------------------------- TITLE
  • Number of reads in Profiler is not the same when running the same SP on different PCs
    by ALEXTT
    5 Replies
    Last post by ALEXTT
      • I'm running the same query on two different PCs and tracing results in Profiler on my PC. When executing the query on PC1 - the total number of reads is 200000. When executing the same query on PC2 - the toal number of reads is 13000. It is almost 15 times more reads when executing query on PC2. The executed query is same on PC1 and PC2. Any reason for this I'm trying to analyse that query
  • Urgent Help! Error while installing MSSQL2000 Personel sp3
    by extrodamus
    5 Replies
    Last post by Jens K. Suessmeyer
      • I cound't install the service pack msde2ksp3en to my MSSQL2000 Personel edition. An error box has been occured while i install service pack ( "the instance name specified is invalid" ). How can I solve this problem and install the service pack. I attempted to install service pack 4 but I had taken that error page again. Help me please. Thanx...
  • CurrentMember and a set
    by John Hennesey
    6 Replies
    Last post by JohnHennesey
      • I have an excel sheet that people are using with pivot tables. The users want to be able to select a set of dates, and get a current year measure, along with the corresponding last year measures on a day to day comparison (not day of year, or date vs. date, but a "monday this year vs. monday last year", which is 364 days ago). They want to be able to pick and choose which days go into th
  • Simple Question - Control Flow Related
    by MA2005
    4 Replies
    Last post by Jamie Thomson
      • Hi Everyone: I have a For Each Loop container, and inside the container, I have a SQL Execute task, which runs first, and then I need to kick off 5 Data Flow Tasks. Do I need to connect the 5 DFTs to each other using the Green(Pipelines). How would you usually do this Thx.
  • Report Server
    by Dale A. Young
    0 Replies
    Last post by Dale A. Young
      • For some reason the Report Services did not register in XP. I attempt to reinstall and the installation process states the the 9 version of Report Services is installed however in the Add/Remove program in Windows there is nothing show. When I attempt to access the Reporting Services I receive the following message: The version of the report server database is either in a format that is not val
  • My first Trigger_Delete field
    by tsys563062
    5 Replies
    Last post by Arnie Rowland
      • Table name: EUDF Field name: endateend When a person is terminated, the system automatically puts the current date in the endateend field and someone manually deletes it, well most of the time. The problem is if they do not remove the date, it causes major problems. We do not have the ability to change the current code, and was told we can submit a trigger. Any help would be appreciate