Great script - Thank you very much!

Couple of suggestions:

1. In List Backup Set Details it seems to be reporting databases that were deleted as well as those that are currently...

bross 52202 (5/24/2010)

---

The issue seems to be that the FROM statement wants a TABLE type variable but the declaration is varchar, but I don't want to declare a TABLE. Is...

Among Russian programmers there was a phrase that I can translate as “licking the code”. Just like cat or dog lick themselves in order to get clean, programmers lick their...

All good stuff is in Enterprise...

This is better link to answer the question (I think):

http://msdn.microsoft.com/en-us/library/cc645993.aspx

--Vadim.

I'm a bit confused. Several of you suggested using "fully qualified names". But this usually refers to using all 4 parts: Server.Database.Schema.Object.

Is that what you suggest we should use everywhere...

Here is MSDN article that shows processing order for SELECT:

http://msdn.microsoft.com/en-us/library/ms189499.aspx

Good script - Thank you.

But it only runs for the server I’m currently connected to. Did I misunderstand your sentence about iterating thru servers?

--Vadim.

There were plenty of postings about object search:

http://www.sqlservercentral.com/search/?q=search+objects+for+text&t=s

I also use SQL Search - still free from RedGate:

http://www.red-gate.com/products/SQL_Search/index.htm

--Vadim.

You can also try STUFF function. Here is an example:

DECLARE @Tbl TABLE (Txt varchar(50));

INSERT INTO @Tbl(Txt)

SELECT 'Program SITE Location' UNION ALL

SELECT 'Program Division SITE...

I live and work in Detroit metro area, Michigan.

If specified @TargetFileSize cannot be reached your script will go into infinite loop.

--Vadim.

I thought the question was about Report Parameters but it’s obviously about Query Parameters.

What is SSRS report prompt?

--Vadim.

Nice script - Thank you.

One more problem: how to exclude OffLine databases? I've added

AND ISNULL(version, 0) > 0

and it seem to work with 2005 but...

I've got that error too. When pasted in Notepad++ it looks like this:

select????distinct

????????@SearchCriteria as ZoekCriteria

????????, 'in code' as Classification

????????, b.type_desc

????????, object_name(a.id) "ObjectName"

????????, b.modify_date

from????syscomments a

inner????join sys.objects b

on????????a.id = b.object_id

where????a.encrypted...

SanjayAttray (9/14/2009)

---

Simple basic question.

http://en.wikipedia.org/wiki/Data_Manipulation_Language%5B/quote%5D

And that article says (bolds are mine):

The purely read-only SELECT query statement is classed with the 'SQL-data' statements and so is considered by the standard...