Thank you to everyone who replied. I will definitely look into creating a calendar table and rewok the functions to be inline. I was building on some previously...

GSquared,

Here they are:)

CREATE FUNCTION [Perf].[udf_GenerateTimeSeries](

@periodStart SMALLDATETIME,

@periodEnd SMALLDATETIME,

@interval VARCHAR(2)

)

RETURNS @tbl TABLE

(

ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

Begin_Date SMALLDATETIME,

End_Date SMALLDATETIME

)

AS

BEGIN

DECLARE @start SMALLDATETIME,

@end SMALLDATETIME

IF @interval ='d'

BEGIN

INSERT INTO @tbl

SELECT a.dte Begin_Date,...

Thanks for the reply Grant,

udf_GenerateTimeSeries is a multi-statement function, and udf_Portfolio_Indicators is an inline function that has nested function calls. There doesn't seem to be anything out of...

np 😎

Thank you, you've been very helpful.

~Jeff

Awesome! And you had no problems running 2 servers connected to the same data and log files? Did you restore and detach/attach the system db's? ...

If its possible in your situation, restart the server and everything should clear up. I've run into instances where restarting the SQL Server Service has cleared things up and...

Thanks!

That all seems perfectly reasonable as well. I'm assuming that you didn't run into any significant problems?

~Jeff:D

Hi,

Is the process showing up as in a KILLED/ROLLBACK state?

First thing you want to do is check the status of the process you killed by running KILL {spid...

Great! Thanks for your help.

Alternatively, use EM.  Right click the server instance, select Properties.  Look at "Product version" on the General Tab.

~Jeff

Cool, Thanks for the help.

We are using Transactional Replication with push subscriptions, not updateable by the subscibers.

Thanks!