Did you also apply SP2 for your client tools on the workstation?

Do you get the same error if you work directly on the server instead of connecting through a workstation?

I'm not sure but I think it will generate an overhead similar to Windows Performance Monitor. But it can also depend on the number of alerts that are generated.

You can also copy the table to another database (or with another name within the database). That will save you time if you have to roll back. The copy of...

You should have created a baseline (by use of counters) for you servers and database. By checking periodically the workload on the server you can notice if everything is working...

And I keep on learning new stuff 😉

The solution Seth has provided works fine. You can alter it a bit by moving the CASE from 'Colorder' to the ORDER BY if you don't want to see this...

Hi Steve,

Thanks for pointing that out. But I created this sample to only simulate my data. The UNITS value...

Hi Anzio,

I have work out your solution. Maybe others can benefit from this code.

As you allready mentioned, this solution is more generic. The TALLY table now only contains the number...

Hi Anzio,

Allthough the provided solution fits my current needs, I'm interested in...

Thanks Mark, it works like a charm.

I knew a TALLY table could bring me the solution 😀

What about this approach...

- create and (re-)fill a table with your data using the scheduled job

- link the Excel-sheet with the correct template to the table

- (automatically) refresh the data...

Install the SQL-2005 Workstation components and be sure to include the Management Tools. SQL Profiler is part of this.

To correctly let SQL 'know' and display the changed servername you have to run the following code to update the system metadata (sys.servers and @@ServerName):

sp_dropserver {old_name}

GO

sp_addserver {new_name}, local

GO

See the article...

I agree with Barry. Just create a trace, to only select the textdata of statements (SP and T-SQL). Filter this on the databasename and "%TabelName% %ColumnName%" and you only get...

Yes, you can change the name of a server running SQL Server. I did it last month regularly when setting up a new development environment. Every time without any issue....