Answer Questions

• mekab Mirror of master, msdb, tempdb, or model databases.

  Hi Guys, Since, You cannot mirror the master , msdb , tempdb , or model databases.What will happen if i create new login,change existing security profile and new jobs,change of existing job on princicpal db. how these will be mirrored to other server and in case failover, how it will treat. Thaks Mirroring works at the database level only. dts/ssis packages, jobs etc are not mirrored. Database users are mirrored but not their corresponding SQL Server login. You need to keep a copy of dts/ssis packages, jobs etc on the mirror server and whatever changes you make to them on the principal server, you will also have to make on the mirror server if you want to keep the servers exactly in sync. hope thi ...Show All

• stallion_alpa Column Chart Y-axis Values Not Rendering

  I'm trying to create a column chart and am having trouble with the y-axis values. I want to chart sales dollars by month, with the dollars on the y-axis. The datasource is a datatable object with 2 columns, Month & Amount. I dragged the Month column into the category area, and the Amount column into the data fields area The resulting chart shows a column for each month, but all months have a value of '1' rather than the actual values in the table. For testing, I dropped a table control on the page and the amount values show correctly ( =Fields!Amount.Value). Is the chart showing a count, perhaps Any help is appreciated. Thanks, Robert. That was it. Maybe th ...Show All

• BilalShouman Error On Clicking Calculation Tab from BIDS (In any Analysis Service Project)

  Hi all ... * Installed SQL Server 2005 Developer Edition and learning SSAS 2005 * While clicking on Calculation Tab, the designer surface shows error: Unexpected error occured: error in application My Machine has following Software Installed (In the same order of listing): Windows 2000 Server Microsft .Net Framework 2.0 SQL Server 2005 Express SQL Server 2005 Developer Found a post on same topic on the forum, but it was NOT concluded with a solution. Can anyone help Piyush Hi all ... The problem is solved..... Sorry to bother. The problem is solved on the same line of the solution provided by the previous post. Though it was NOT because of the OFFICE 2007 TR, the ...Show All

• Toni Greco Error 1418 and Good Basic Setup Guide

  Hi, I'm new to DB Mirroring, and I am trying to get it going in a test enviroment between two SQL 2005 Dev Servers. I have followed documentation that I have found but cannot get past a 1418 error when establishing a connection between the servers initially. Does anyone know of any good step by step guides that I could look at, in case I have missed something stupid. Thanks in advance Stupots Hello, Please follow this steps..You can find sample codes and it is very useful http://msdn2.microsoft.com/en-us/library/ms191140.aspx Regards... Tarkan G. GTA Great, thanks for that, I'm sure it's something simple that is stopping it working properly! I'll have another play. It doesn't seem to ma ...Show All

• CJF Can't create a full-text index or catalogue on my sql table.

  I am trying to run an SELECT statement with a CONTAINS statement from a aspx.net solution built using Visual Web Developer 2005 express edition. When I try to run the thing it throws an error saying "Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'JournalArticle' because it is not full-text indexed.". I don't have access to the SQL Express server, I interface through Server Management Studio Express. There is an option to create a full-text index from the menu, but it is greyed out, presumably because there is no full-text catalogue. This is my real question, How do I create a full-text catalogue using Server Management Studio Express The help function only provides examples of sql code, which I assu ...Show All

• Denvas dynamic Instead of update trigger problem

  Hello, I am trying to use an instead of update trigger to alter a lastupdated field in the table when any of the other fields are modified by an update. I want to do this as I can't rely on the applications updating the date when they alter other data. The trigger looks something like this. CREATE TRIGGER [noidentitytableinsteadupdate] ON [dbo].[noidentitytable] INSTEAD OF UPDATE AS if(not update(updatedat)) begin update noidentitytable set text = inserted.text, state = 'updated', updatedat = GetDate() from noidentitytable INNER JOIN inserted ON (noidentitytable.id = inserted.id) end else update noidentitytable set text = inserted.text, state = 'updated', updatedat = inserted.update ...Show All

• RGravity How do set send mail task?

  Hi There, I have a task to send mail when the source file contains null values against id column. I have set conditional split to split the null value rows to the different destination.Please help me how do i achieve this task when the source file contains null values against id column . Thanks in Advance. Hi Andy, Many thanks for your response.Its really helped me to head start to the mail task.I have set variable for rowcount and i kept the expression as @[User::NullRowCount] > 0 in send mail task i tried evaluate this but it was false please let me know whats the problem with this. Thanks in advance. Hi Savera, I'm not sure I understand what you're trying to accomplish but ...Show All

• Daffodils Sum 5 minute data by hour

  I have a table that data gets stored in every 5 mins in intervals marked as 5,10,15,20...2350,2355,2400,5,10, etc. based on the current time rounded to the nearest 5 min interval. Now, with this data, I'm trying to make a query that can be ran to show the sum or average of the 5 min data for every hour interval. So, 100 would sum intervals 5-100 and 2400 would sum intervals 2305-2400. I just figured out how to use the DataGridView controls in the 2.0 frameworks but now I'm not stuck on this query. Thanks! I figured it out after searching through the T-SQL online language reference, which is pretty nice I must say...if you know what your looking for or get lucky like I did.  Anyways, here's the q ...Show All

• allison_h XML Problem when scheduling SSIS package

  I am getting an error when I try to schedule a package. I can run the package with no problems from BIDS. For some reason it is throwing an error when I try to schedule the package using SQL Server Agent. Information on how to resove this would be greatly appreciated. Executed as user: MACHINE\SYSTEM. ...n 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:41:55 PM Error: 2007-02-19 17:41:56.01 Code: 0xC0011007 Source: {48427B5A-10F6-4054-B7EB-F0F19B90F334} Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error Error: 2007-02-19 17:41:56.01 Code: 0xC0011002 Source: {48427B5A-10F6-4054 ...Show All

• kforrey Problem connecting from other PC in network

  Hello all I am new with SQL server express 2005 and i dont know what i am doing wrong. I have an MS access database want to migrate to the SQL server. Wizard upsize looks okay so it works on my local machine in the network. The application stays in MS Access but the data goes to the SQL server. On my server i enabled tcp/ip and pipes and i opened the firewall for SQLSERV and SQLBROWSER. I installed the SQL Native Client and not SDK on the other computer in the network. When i try to make a connection with the native client in the ODBC manager it goes wrong. I dont know what i do wrong. Patrick Could you give the exact error message Mike Hello I switched off Firelwall and reinstalled SQL s ...Show All

• GG71 Installation Issue - Access to path denied on service start

  Hi, I have a generally well working silent installer of SQL Server sp1, that installs a named of SQL Express then runs some create database scripts on it. I have a customer for whom this fails. It appears that the SQL server service does not start. When I tell the client (non-computer literate!) to start it manually through Admin Tools>Service, a message appears saying "Access to the path denied", and seemingly doesn't specify the path of the denial. Has anyone encountered this, or is anyone able to hazard a guess as to the cause of this issue. Many thanks, Chris Hi, make ssure that the service accoutn which is runninghte SQL Server service has access to the paths of the master and temp data ...Show All

• hdp203 formatting issues for excel

  hi, I have a column of numbers which export fine to excel when i use the formatting '$0'. If any of the values in the column = 0 i dont want them to show so i added this line to the value =iif(Fields!Budget.Value = 0, "", Fields!Budget.Value). This works fine except when i export to excel it now doesnt read them as values and you have to convert all the cells individually. I guess this is becuase i have substituted the string "" when the data = 0 and excel does the formatting for the whole column not each cell individually. What should i do so it exports to excel correctly Is there another way to show nothing in a cell and it still registers as a number geoff WHat about N ...Show All

• Tadwick Invalid column name 'rowguid'

  I'm trying to set up a merge publication in MSSQL 2005 SP1. I have a database which I have successfully made into a merge publication.  When I run the snapshot agent, several articles are processed successfully, then I encounter an error with the following: Invalid column name 'rowguid' Note that none of the tables contain 'rowguid' columns before this process - I let MSSQL automatically create these as needed. The replication monitor details the following error: Error messages: ·           Message: Invalid column name 'rowguid'. Command Text: sp_MSpublicationview Parameters:    @publication = RelMS Publication Stack:    at Microsoft.SqlServe ...Show All

• Pete Orologas SSIS Partition Processing Data Flow Item

  Does anyone have a helpful link for using the partition processing data flow task in SSIS I am trying to process a monthly partition from within my package and am getting the following error: Error: 0xC113000A Errors in the high-level relational engine. Pipeline processing can only reference a single table in the data source view. If anyone has used this before and could point me in the right direction, I would appreciate it. Thanks, Nick What is the "partition processing data flow task" I think he is referring to the Partition Processing destination in the Data Flow. Used for sending data into and processing an Analysis Services Cube Partition. Other than what it is ...Show All

• ChitownDotNet Page Break Before subreport

  hi all i m using two subreport in my report. i want to show each subreport in different page. pls suggest me how i can implement this. thanks in advance If the subreport object does not have the "page break before" option in it's properties page then you could drop the subreport into a rectangle which does have the option. ...Show All