The backup runs for about two hours and gets to about 80% when the log file starts to grow as described above. This has happened twice on consecutive attempts to...

Well I am not sure what "code" I could show as I am using SSMS to run the backup. Is there something particular you would like me to post up...

Not sure what your pasting into Grasshopper, code block I copy, pastes well formed for me in NOTEPAD, NOTEPAD2 and into a query pane.

I am experiencing this too. I run Profiler 9.00.3042.00 on MSSQL 2005 and PerfMon on Server 2003 SP2. Once out of about 6 attempts did the Import Performance Data option...

In step 1 the fourth code block I believe you omitted the "s" in the FROM line for the ALIAS "so"

I changed the code to "from sys.objects so...

In Step 1 code block three is:

Create Function Uf_GetIndexSize

(@index_id int,@tableid int)

Returns float

AS

BEGIN

return (select cast(reserved as float*8192)/(1024) from sysindexes

where indid=@index_id and id=@tableid)

End

I get:

Msg 102, Level 15, State 1, Procedure Uf_GetIndexSize, Line...

You have the right document from MSDN, it clearly states the upgrade path from eval to Standard or Enterprise, even says Express can be upgraded.

I have done the upgrade from...

Where does this SP need to be created, I created it in Master and it only returns result from the dbo or sys schema's.

I also got one row with NULL, so I did not see much use for this SQL.

but Russel Bell, this is useful, thanks.

😀

Sometime the topic just gets you looking in...

The way I find out what stored procedures are in a database is in Management Studio, to drill into the Programmability | Stored Procedures | System Stored Procedure. Here you...

Jeff, as I read your article I worked through it and saw the improvement your change made; and then Hugo sample worked great too. To read the comment that good...

When I ran the SELECT statement by itself I see that this is a function that exists, what is the change you are making to the default Function?

I changed the...

Service Packs=Yes

Even though I will implement the weekly fixes and mostly without testing, as there is never enough time or resources. We have grown comfortable with our DR methods to...