Please read the first article linked in my signature line and find out how to post to get the best answer from the forums.

We need:

1) Table scripts

2) Sample data

3) Expected...

jared-709193 (9/26/2011)

---

How are Views stored in SQL Server? The obvious answer will be "they are saved queries," yet somehow this is not really the case. For example, you can use...

You could use dynamic sql to build the UNPIVOT/PIVOT trick based on your actual...

You're catching the error in the...

You code works only if strategy key is ever-increasing.

This should work regardless of that:

DECLARE @dim_strategy TABLE (

Strategy_id char(9),

efct_start_dt datetime,

efct_end_dt datetime,

strategy_key int

)

INSERT INTO @dim_strategy VALUES ('GT-537791', '2011-01-21 03:11:27.000', '2011-07-02...

This should do:

SELECT TOP(1) *

FROM publish.dim_strategy

WHERE strategy_id = 'gt-537791'

ORDER BY efct_end_dt DESC

Try this:

DECLARE @srvname varchar(100)

DECLARE @getDatabase CURSOR

declare @sql varchar(200)

SET @getDatabase = CURSOR FOR

SELECT srvname -- << No need for a variable here, let the cursor fetch it

FROM

master.dbo.sysservers

OPEN @getDatabase

FETCH NEXT

FROM @getDatabase...

You could also capture the error in the inner CATCH block and throw it again with RAISERROR:

BEGIN TRY

BEGIN TRY

EXECUTE usp_ExampleProc

END TRY

BEGIN CATCH

--SELECT ERROR_NUMBER() AS ErrorNumber

-- , ERROR_SEVERITY() AS ErrorSeverity;

RAISERROR(ERROR_MESSAGE(),ERROR_SEVERITY(), ERROR_STATE());

END...

In order to start a job, the user must be granted one of the fixed SQLAgent roles in msdb.

See here for more info:

http://msdn.microsoft.com/en-us/library/ms188283.aspx?ppud=4

Based on Gail's suggestion, this should do:

SELECT cntr_value

FROM sys.dm_os_performance_counters

WHERE counter_name =...

GilaMonster (9/23/2011)

---

Gianluca Sartori (9/23/2011)

---

I always feel safer when I set up a SQL_SERVICE user on my laptop with no special permissions. Maybe I'm paranoid, but that's just how I feel....

Elvis? 🙂

Ninja's_RGR'us (9/23/2011)

---

montyismobile (9/23/2011)

---

Hi Gianluca Sartori,

I would like to thank you for all your help with this cursor issue. When tested against the same data set your query produced identical...

montyismobile (9/23/2011)

---

Hi Gianluca Sartori,

I would like to thank you for all your help with this cursor issue. When tested against the same data set your query produced identical results...

GilaMonster (9/23/2011)

---

Yes, it's not a bug (not really)

I could plug Jonathan Kehayias's upcoming book that...