SSC-Dedicated, thanks for the reply. I agree ... perhaps it should be removed if it isn't really used.

When I read the article from SQL Server Central a lot of it did sound kind of "deja' vu". However, many articles and posts regarding SQL Server functions, processes,...

There needs to be a disclaimer or note on this script/article stating that this applies to backups handled under certain conditions. The way it is currently written it is...

I have modified the script to avoid sp_configure and cursors.

;

WITH cteConfigValues AS

(

SELECT

ConfigurationName = [name]

,[Description]

,CurrentValue =

CASE [value_in_use]

WHEN 0 THEN 0

ELSE 1

END

,[value_in_use]

FROM

[master].sys.configurations

WHERE

[name] IN

(

'affinity64 mask'

,'affinity I/O mask'

,'affinity64 I/O mask'

,'lightweight pooling'

,'priority boost'

,'max worker...

If you have fields that contain values and not numbers then the following should work to hide columns that have only NULL values for each row in the column.

Place this...

Simply go back to the SSMS query and execute it despite the fact that the connection icon is still GREYED OUT. The query should get reconnected and finish! ...

--BUILD LIST OF Captured SQL Agent Jobs from Profiler GUIDs

--ASSUMES THAT YOU HAVE A PROFILER TRACE TABLE "xxProfilerTraceTablexx"

--ALSO ASSUMES "xxProfilerTraceTablexx" IS ON SAME TABLE AS SQL Agent Jobs

IF EXISTS

(

SELECT *...

I am running SQL2008 Express Edition. As it turns out, apparently all I needed to do to resolve this issue was to fix my firewall settings and turn on...

So I thought that using the Microsoft OLE DB Provider for SQL Server (SQLOLEDB) would make a difference. It did not. As a matter of fact, the error...

I am having a very similiar problem. I could create the linked server to the SQL2008 box from the SSMS2005 interface just fine, without any errors. I am...