I would put intermediate results in a temp table and them filter by another query.

Doug,

There are usually 2 reasons for Invalid Object Name when you are sure the object really exists

1. You are in the wrong database. If you don't specify the database name...

Steve,

don't misunderstand me, I never say I did something when someone else did it. In many cases I even credit other people with something I suggested first. So let's talk theoretically:

-...

Michelle,

You will thank yourself many times after you spend this time writing scripts and figure out how to do it.

There is a quick help for you:

http://www.microsoft.com/technet/scriptcenter/tools/wmimatic.mspx

Scriptomatic Tool By...

"Is it wrong to hire someone to do your work?..." Do you repair your plumbing yourself or you call the company? Do you grow your own grains for bread or...

Michelle,

You may store the number of attempts in a file and read from file when the job runs. You may store pair of values: server name - number of unsuccessful...

You have to check the security log for the exact time the Null Login happens. I re-created the problem by logging locally on one server and trying to connect using...

Hi,

what you are trying to get? The actual data or just to assure that the server is up an running and SQL Server is up on database server?

I have...

I just answered this question on SQL Server 2005/Administration forum for the topic on DBCC Shrinkfile.

see

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=256050

Detaching /attaching to get a nice new log worked in SQL Server 7 for...

Hello,

I too had this problem when we were running on SQL Server 7 with one of my databases. I did not touch production, but when I needed to get copies...

@@servername function returns the computer's name that is running SQL Server

SERVERPROPERTY('servername') function returns SQL Server's name

I answered correctly, but the answers about the account not having Delete rights are valid too. Create Files / Write Data , Delete and Delete Subfolders and Files are 3 different advanced...

Totally Agree with Linda. I had to restore databases because developers deleted tables, databases, imported bad data, generated SQL Script with default options (with Drop Table statement)and then accidentally ran...

I sometimes keep data and log on the same drive if I have only one logical drive. This is OK. They say that log writing is mostly sequential writes and...

I found it a couple of days ago myself and did some experimenting yesterday. This thing, Maintenance Cleanup Task has checkboxes for the directory name and file extension. I was...