If disk space is limited, I will try and defrag indexes in a selective fashion. Pick a handful here or there and then schedule those for specific nights. ...

Not in a loooooong time.

A switch can possibly work as well.

Example:

=SWITCH(

IsNothing(Fields!Field1.Value),...

Well, maybe they are fixing it currently and will get...

From reading it, I agree that it appears to be a custom error. It also appears that from the error - the file being loaded had an XML attribute...

We migrated several SQL servers (2000 and up) via P2V that involved replication and service broker. Doing it cold, when we brought up the Virtual machine we had 0...

An iif expression in the visibility property should work.

=IIF( param.Value = False, "somepic.jpg", "")

gary.p.heath (3/22/2012)

---

I have used that key to ascertain instances of SQL Server installed on the PC, mine just says "SQLEXPRESS" & "MSSQL10_50.SQLEXPRESS" as the Value Data. Maybe I am getting...

You might want to read this:

http://www.brentozar.com/archive/2008/08/sql-p2v-what-really-killed-the-dinosaurs/

You are welcome

To reclaim that space to the OS, you would...

Glad it is fixed and glad to see how to fix it.

CREATE TABLE [dbo].[FragList](

[ObjectName] [nvarchar](255) NULL,

[ObjectId] [int] NULL,

[IndexName] [nvarchar](255) NULL,

[IndexId] [int] NULL,

[Lvl] [int] NULL,

[CountPages] [int] NULL,

[CountRows] [int] NULL,

[MinRecSize] [int] NULL,

[MaxRecSize] [int] NULL,

[AvgRecSize] [int] NULL,

[ForRecCount] [int] NULL,

[Extents] [int] NULL,

[ExtentSwitches] [int] NULL,

[AvgFreeBytes] [int]...

Will you provide the code you are using to create fraglist?

Recap:

Browser service is running

No Active Directory

Can connect via IP address but not by name

This is a named instance

All SQL Instances were completely reinstalled

Is the firewall turned on? Is there...