Looks like the report's page setup is different that the printer's page setup. You should check each on to see what setting are and adjust accordingly.

Hope this helps 🙂

Nicely done!

I have a question, is the order of the scripts the order of execution?

Thanks,

Rudy

Hello Everyone,

Just looking over the article again and thought I would make a stored procedure which automatically gets the path and log name used by the default trace. This way...

Excellent work!

Thanks for sharing with us 🙂

Nicely done! I like the graph too.

I was looking at the graph and thought shouldn't it reset back to left side of the "Duration Timeline" once the the next...

Hello,

Congrats on the great script. Very useful!

I have added below a script that would be a great addition to your code. It produces the IP address of the workstation connected....

Hello everyone,

Here is the code that will also scan SQL 2008 servers

--SQL 2000/2005/2008 Version

set nocount on

go

DECLARE @SqlPort Nvarchar(10)

DECLARE @instance_name Nvarchar(30)

DECLARE @reg_key Nvarchar(500)

Declare @value_name Nvarchar(20)

if left(CAST(SERVERPROPERTY('ProductVersion')AS sysname),2) = '10'

BEGIN

select @instance_name =...

Nice code. Any idea where to fine the port number for SQL 2008?

Thanks EdVassie for the information and links regarding memory.

It seems to me that this is an area the needs to be looked at a system by systems basis. Not all...

This really should be in SQL 2010 🙂 Nicely done!!

Yup that's it. When I copied and pasted into SSMS there seems to be no problem, but when I pasted the script into NotePad++ it all showed up. Once I...

Thanks for updating the file. Unfortunately I'm still having issues with the creation of the sp. I've copied and pasted the script and change the ALTER command to CREATE but...

No error message just Microsoft does not have an option for unattended installation for Service Packs. I talked to them and there is no immediate future for this function.

Rudy

Hello,

Nicely done! Unfortunately I'm having a problem executing on a SQL 2005 server. Do you have an updated script I could use?

I think everyone should have this script including MS!

Rudy

Hello, sorry fro the delay but no. Not able to do an unattended install of any service packs.

Wish you had the option so that you could completed automate the entire...