Have you read the articles, here[/url] and here[/url], and tried implementing some of the suggestions there?

Are you only getting the error when you add the % column? What have you tried to troubleshoot the problem?

DBCC REINDEX is a blocking operation. From BOL:

This...

If emp is a table you will get exactly what you asked for, 10 for as many rows as are in emp.

I'd use SSIS to do it.

Howard has provided a pretty good explanation. Use ISNULL when you only have 2 option, COALESCE with more than 2. They also handle data types and lengths differently....

Slick84 (12/11/2009)

I'm running SQL Server 2008. Shouldn't I be able to see the objects...

Is the value coming across as a string or an integer?

I'd do string manipulation. If it is an integer convert to string, then use the substring function to parse...

What happens if you run the Reporting Services Configuration Manager? I'd be sure to run it directly on the Reporting Services server.

As far as I know all that affects is the ability to use Kerberos to authenticate. This will cause issues if you have processes that have multiple hops.

Sounds like the problem is more likely IIS server performance than SQL Server performance.

I'd also recommend checking the PerfMon counters under SQL Server:Locks object like Lock Waits/Sec, Lock...

You'd use Move-Item to move the files. Like this:

get-ChildItem -include *.txt -recurse | select-String -pattern "Msg","Level"|Move-Item -destination [path]

I don't know how to email the files in PowerShell, but...

Doesn't really matter as the the SQL Server services will start and stop gracefully. The difference is that you will get faster reboots if you don't have all the...

DMO is a method of manipulating SQL Server objects using .NET. This is pre-SQL Server 2005. You would need to determine what is being done by the application...

I have not yet used the CLR. As Grant mentioned I would bet more people on 2008 are if you include the Spatial and Hierarchy data types which are...