Answer Questions

• Kiron Bondale SQL 2005 Mirroring with Sharepoint 2007

  Hi, iam from Mexico, somebody has installed SQL 2005 with mirroring and sharepoint 2007 regards. thanks Mark, I opened a call with Microsoft a couple of weeks ago and it turns out that SPS 2007 does not have any support for automatic failover to the mirror server. Microsoft suggested using a SQL Alias or the following approach: The approach for failover is O If the SQL server falls over, use the stsadm command RenameServer to change the db server name, then stop & restart IIS & the timer service. O If a single db other than configdb falls over, detach & reattach the db using the UI or via stsadm commands. O If configdb falls over, the admin must use PSConfig.exe’s configdb command, or t ...Show All

• H.Saber CASE Returning NULL

  Hello, I have a query that contains six derived columns; FirstPerYr; The current year FirstPerMo; The current month FirstPeriodRevenue; CASE the current year, use the CurrentYearSalesTable (CY). CASE the current month, match the correct column (JanRev, FebRev, etc) of the CurrentYearSalesTable to get the correct data. FirstPeriodYrAnnum; Last year FirstPeriodMoAnnum; The current month, last year FirstPeriodAnnumRev; Same as FirstPeriodRevenue, but from the year and month before. In the following query, I get the correct FirstPeriodRev value, but FirstPeriodAnnumRev comes up NULL. I know I have data for January 2006. The query is as follows; --************************** DECLARE @FirstPerYr Int DECLARE @FirstPerMo Int DECLARE ...Show All

• BarrySumpter Subreport throwing an exception when placed in a group footer

  I ran into this a few weeks ago and found that several others had as well, but no one had yet found an answer. I found the answer (at least one of the answers) this weekend and wanted to share it. I had recently added a subreport to a group footer in a table and started getting an error. Depending on the data, the error wasn't always present. I didn't have a problem when I moved the subreport to any other area in the report. Here is the error I was getting: An error occurred during local report processing An internal error occurred on the report server. See the error log for more details. It was a local report (rdlc), so naturally, there was no error log <g>. I added an event handler for ReportError and collected this inf ...Show All

• osamaT How to justify text

  Hi, How can I fully justify text against both left and right edges of text box in SSRS 2005 The full justify icon doesn't seem to work. Thanks. Alan Robert, Will it be implemented There is already an icon for it on format toolbar. Do you know of any third-party controls that would do it I already have a table column with the text and RTF codes.to populate the control. Thanks. Alan Alan Sorry, "full justify" is not a supported option in RS 2005. -- Robert ...Show All

• Neno Question about paging?

  - where running a server 4GB of RAM - set to use a min 2.5GB and max of 3.9GB - AWE is not enable -- the problem is that microsoft sql server 2000 is only using 1.6GB and is paging a lot The /3GB switch is used to tell SQL Server to take advantage of 3GB out of the base 4GB of RAM that Windows 2000 supports natively. If you don't specify this option, then SQL Server will only take advantage of 2GB of the first 4GB of RAM in the server, essentially wasting 1GB of RAM. Use AWE or the /3gb switch to get the memory support you desire via your min/max buffer pool settings. Good articles I always references for sql memory config issues: http://www.sql-server-performance.com/awe_m ...Show All

• KjeZ Scripting Task and VBA Macros

  How do I run Office macros by using Automation from the Scripting Task in SQL Server Integrated Services I talked to some other super smart people and they advised me against making any changes to the GAC. They seem to think that it may interfere with other code, and that I may unknowingly screw things up. What do you folks think Ok here is an article that I tried but couldn’t get it to work. http://support.microsoft.com/kb/306682/EN-US/ The problem is when I tried to add a Microsoft Excel library reference I couldn’t find the COM Tab. Without the library reference the VB.Net in SSIS doesn’t recognize any of the commands the article ab ...Show All

• NoEgo SQL Mobile support for CE 4.2

  An update was supposed to be released for SQL Server Mobile which enabled support for CE 4.2. This was supposed to be released around the time of CF 2.0 sp1. SP1 came out over a month ago and there is still no sign of the SQL Mobile update. Does anyone have any information on a release date Thanks for the info. I really need SQL mobile for a project I'm working on and the slipping release date is getting me worried. Does anyone have more information now on when SQL Mobile for Windows CE 4.2 will be available. Supposedly it is now available, according to this blog: http://blogs.msdn.com/sqlservereverywhere/archive/2006/09/14/754057.aspx H ...Show All

• JCJCJC Query Or Stored procedure

  Should I use query or stored procedure to get results fast. Stored Procedures are best.Check out this Link http://www.sql-server-performance.com/stored_procedures.asp Regards Raj Deep.A Your question is very unspecific. Usually the majority of the query time will be returning large volumes of data. Having a stored procedure is usefull for complex data retrieval or if you want to perform other actions such as logging and for having a precompiled query execution plan. Personally I prefer to just wrap up my report query in a view to keep the logic out of the report and to make updates via SQL. I see no harm in using a stored proc though. ...Show All

• Wicket Association Rules algorithm [support,confidence]

  In assotiation rules each rule has a [support, confidence] part. In Microsoft Association Rules there is a [probability,importance] measure in each rule and importance can be greater that 1. I found the following in msdn but i'm not sure if i understood correctly. MINIMUM_PROBABILITY: Specifies the minimum probability that a rule is true. For example, setting this value to 0.5 specifies that no rule with less than fifty percent probability is generated. The default is 0.4. MAXIMUM_SUPPORT: Specifies the maximum number of cases in which an itemset can have support. If this value is less than 1, the value represents a percentage of the total cases. Values greater than 1 represent the absolute number of cases that can contain the items ...Show All

• jminond Schedule Job Keep on failing!

  Hi, Actually i saved a SSIS package into a SQL Server 2005, then scheduled to run a job from SQL Agent, but, the job keep on failing and no error message was returned in order for me to toubleshoot. After the job failed, i restart the job again, and it actually continue to run, but unfortunately, it stopped again after some time. And, before i sheduled the job, i actually tried to run the package itself in SQL Server Business Intelligent, it runs suceessfully. In the package, i actually set the ProtectionLevel to DontSaveSensitive. Another option that I used to run the pakage was using dtexex.exe: dtexec.exe /FILE "E:\Package.dtsx" /MAXCONCURRENT " -1 " But, the error message returned also not so u ...Show All

• justom Login Properties: Deny, Disable, Lock Out? Which do I use?

  Hey again! I have a SQL login, and I want to prevent the login from logging into SQL Server. From SSMS, I connect to the Database Engine, expand Security, Logins. I right-click the login in question and select Properties. I select the Status page. So I see I can deny, disable and lock out this login. What is the difference between these three options Also, shouldn't the checkbox "Login is locked out" be checkable Currently, it's unchecked/disabled and I cannot alter this value. Thank you for the help, Joe it was very usefull information. Denied: sys.syslogins WHERE hasaccess = 0 Disabled: sys.server_principals WHERE is_disabled = 1 Locked: sys.sys ...Show All

• IraMaster Import Legacy DTS Packages into SQL Server 2005 using SMO

  I was hoping someone can point me to a resource for SMO and importing legacy DTS packages from SQL Server 2000. We are getting ready to upgrade our SQL Servers from 2000 to 2005. We have a lot of DTS packages that we plan on continuing to use in 2005. I found a script I used to export all of the old DTS packages out of our 2000 servers; DECLARE @TARGETDIR varchar ( 1000 ) SET @TARGETDIR = 'C:\DTSTest\' SELECT distinct 'DTSRUN.EXE /S ' + CONVERT ( varchar ( 200 ), SERVERPROPERTY ( 'servername' )) + ' /E ' + ' /N ' + '"' + name + '"' + ' /F ' + '"' + @TARGE ...Show All

• Claudia Alvarado Calling a stored procedure or function from another stored procedure

  Hello people, When I am trying to call a function I made from a stored procedure of my creation as well I am getting: Running [dbo].[DeleteSetByTime]. Cannot find either column "dbo" or the user-defined function or aggregate "dbo.TTLValue", or the name is ambiguous. No rows affected. (0 row(s) returned) @RETURN_VALUE = Finished running [dbo].[DeleteSetByTime]. This is my function: ALTER FUNCTION dbo.TTLValue ( ) RETURNS TABLE AS RETURN SELECT Settings.TTL FROM Settings WHERE Enabled= 'true' This is my stored procedure: ALTER PROCEDURE dbo.DeleteSetByTime AS BEGIN SET NOCOUNT ON DECLARE @TTL int SET @TTL = dbo.TTLValue() ...Show All

• Bill Foust-DAI sqlcmd with trusted connection and IP address or fully qualified hostname

  The command sqlcmd seems to fail when using trusted connection and an IP address or a fully qualified hostname. For example: sqlcmd -E -S nnn.nnn.nnn.nnn where nnn.nnn.nnn.nnn is the real IP address of the machine, or sqlcmd -E -S hostname.domain.com where hostname.domain.com is the fully qualified hostname of the machine, gives the error: Msg 18452, Level 14, State 1, Server 380GX280B05, Line 1 Login failed for user ''. The user is not associated with a trusted SQL Server c onnection. On the other hand, sqlcmd -E -S 127.0.0.1 works, and so does sqlcmd -E -S hostname, or sqlcmd -E -S tcp:hostname,1433. This is on a clean machine, with SQL Server 2005 freshly installed as Administrator with mixed authentication, and t ...Show All

• RLovelett Cube not refreshing?

  AS and RS 2005 My cube is built on views both for dimensions and the fact table. I am using reporting services and the report i have designed works fine except it does not update when i change the data. I can see the change in a select from the view so it is definitly there. It does refresh if i reprocess the cube. This happens in rolap as well as molap. Any Ideas Thanks, Jules Most chances it is Reporting services problem. You can try and browse your AS cube using cube browser built-in in SQL Management studio to see if new numbers are avaliable. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. Moving to Reporti ...Show All