Analysis Services (SSAS)

RE: SQLServer Agent Stopping

• by Clark-Cruz

• Database Journal

• Reply

How many DBs are log shipped? SQL Agent failed on the primay server, the failover server, or the monitor? When did SQL Agent fail? And what does the Windows event log say before it stops Agent?

2003-06-23

RE: Trigger Problem

• by jcool

• SQL Server Performance

• Reply

Look like you ran into a loop. Trigger triggers itself until 32-level nesting limit is exceeeded. Have a look at "TRIGGER_NESTLEVEL" in BOL, check out the sample and set trigger to return if nesting > 1.

2003-06-23

1 reads

RE: Create second instance on Active/Passive Clustor

• by Brian Kelley

• Microsoft MSDN

• Reply

Right. Install the second instance just as you did the first. You'll need the name, the IP address, and the instance name. Read the article cited and you should be in good stead. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

2003-06-20

RE: Create second instance on Active/Passive Clustor

• by SQLBill

• SearchSQLServer

• Reply

Install SQL Server (pretend you are doing a new install). You will get to a window where you can set the instance name. There will be an option for the Default (which should be grayed out) and an option to input a new instance name. That's basically it. The new instance will need a new […]

2003-06-20

2 reads

RE: eliminating duplicates from stored procedure joins

• by Dave

• Database Journal

• Reply

There's more... Try the performance if this (remember the execution plan will be saved for this query in proc). SELECT DISTINCT a.* FROM ( SELECT Case30.Case_no#, Case30.Last_name, Case30.[First Name], Case30.Determination, Case30.Sender, Case30.[Case Type], Case30.Date, Case30.[Qwik Due], Case30.[Qwik sent date], Case30.[Final due], Case30.[Final sent date], Case30.[on hold code], tblFileNames.reportid, tblFileNames.type, userviewed.viewid FROM tblFileNames Left Outer Join […]

2003-06-20

RE: eliminating duplicates from stored procedure joins

• by Dave

• Database Journal

• Reply

What duplicates are you getting, from one of the selects or when they are combined. If when combined then you could try select distinct a.* from (select... union select...) a

2003-06-20

RE: Master server vs. Target server

• by Arun-Modasra

• MSSQLTips.com

• Reply

Steve, Thanks very much..... Before I wacked the jobs from MSDB using QA, I really wanted to find out why. When I looked at the jobs, the originating server with sysjobs was not on our network thereby SQL server was confused and did not know what to do. as for the other, both servers are […]

2003-06-19

1 reads

RE: interbase vs sql server

• by crosspatch

• SQLServerCentral

• Reply

I'm always wary of things that "start small" It's been my, sometimes painful, experience that a succesful "small" application grows exponentially. As users discover it works and produces results they want to use it and grow it more and more. If you don't want to be the victim of your own success buy into something […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-19

1 reads

RE: database logs

• by neder

• SQLServerCentral.com

• Reply

quote: Is there a way to check what happened to a specific database at a particular time? Are there any logs? I got complaints about db hiccups at specific time and lost some records. I dont see any in server logs. Any help greatly appreciated. you may want to put a trace to see what […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-18

1 reads

RE: How much do you earn?

• by James Travis

• Database Journal

• Reply

I will say less than $60,000 but am looking to fix that. But for my area I am on the 25% portion of the pay scale. I have seen jobs for as much as $130,000 but most want you to know about 40 languages (programming) and be able to walk on water all at a […]

2003-06-18