Try this

EXECUTE sp_msforeachdb

'select getdate() as Date,

@@servername as Server,

''?'' as databaseName,

name as FileName,

type_desc as Type,

physical_name as PhysicalName,

size * 8 / 1024 as MB -- size is in 8KB pages

from [?].sys.database_files'

To shed a little different light on the conversation and shy away from the easily bashable healthcare disaster.

Military data could jeopardize lives. Time tables, personnel schedules, artillery coordinates, munitions locations,...

postulate

GSquared (9/9/2011)

---

ChrisM@Work (9/9/2011)

---

I don't know.

I think scritching...

Ray K (9/8/2011)

---

Ray K (9/6/2011)

---

My bold prediction: whomever plays the Tigers in the ALDS (hope it's the Red Sox -- Calvo: :-P) gets knocked out right away. Reason: two...

There is no such thing as a "parameterized view" in SQL Server.

You cannot create a parameterized view in SQL Server. A Table-Valued Function (TVF) would probably be your best bet.

something like this,

CREATE FUNCTION dbo.fxnExample (@Parameter1 int)

RETURNS @Results...

I'm sorry to hear that you had issues in upgrading to SP1. I can't give you a solid reason as to why it might have happened, but there's a...

what the heck man!

I go away for a long weekend...

I can't help you with analyzing the error, but I can tell you that Ms. Shaw is the go-to lady for this stuff.

She usually says:

GilaMonster

---

Please run the following and...

I google'd your error and found it's a litespeed backup job?

This link explains it a little.

see if that Quest link answers your question.

What makes you think this is an error message for a failed backup? It says it is informational only.

I get this message when we do vulnerability scans doing port scans, as Roy mentioned.

I've also received this message when trying to telnet to the SQL box.

IMHO, It's a...

That is impressive.

They got a big jump in the HRs, RBIs, and runs scored stats department.

Geez, how do you let that happen to you. I didn't watch the game...

Three minutes too slow on a Friday morning.

Tony,

A great way to troubleshoot dynamic SQL related errors is to print the statement instead of trying to execute it.

Change exec (@testquery) to...