Sorry, I gave bad sample data.  Try the following data:

insert into #temp values ('abc','123')

insert into #temp values ('abc','123')

insert into #temp values ('mno','123')

insert into #temp values ('xyz','123')

insert into #temp values ('mno','123')

insert...

Thanks for the replies.

First, I posted here because I usually get a better response in this forum than in a specialized forum.

Second, J Wright, I appreciate your help but the...

Thanks, I checked that box but it was set to allow me to see the system objects.  I am the system admin so I can see everything.

The strange thing was,...

First, I was logged into the server as the proxy user that I have setup to run as when a non-sysadmin runs xp_cmdshell.  I ran it from a command line...

When I ran the command from the command line, I was logged in as the proxy user.  (I had to log out and back in just to make sure.)

Thanks for the reply.  I can definitely see a use for it in the future.

I got your response while I was working on another solution.  I saved the script as...

I know this is way after the fact but I have also been looking for more info about what is going on under the hood in the maintenance plans.

I just...

OK, I got it working somewhat but I don't really understand how it works.  The following are two examples of queries I was able to get working based on some...

You can have more than 5 databases on MSDE.  There are the 4 system databases, five small databases supplied by the application, and two databases I have installed.  One is...

Never mind.  If I would just wait five minutes whenever I think I might need to post a question, I will probably figure it out.

Somehow it had something to do...

Thanks everyone.  This is what I thought but I had to due my "due diligence".

Pardon my ignorance, I've seen it a lot on the boards but I don't know what...

Sorry, didn't realize it only works in IE.  I was just having a little fun.

There are a million conversion sites on the web, I figure it could be converted in...

Convert my signature by using this website:

http://www.theskull.com/javascript/ascii-binary.html

Santa got me a DVD writer!  Thanks, Santa!

The SSC get together was a great time.  Thanks for all the hard work putting it together!

hawg

I understand, and I agree, that a SAN would be the best route.  However, we currently have a NAS solution in house and with the introduction of iSCSI, that is...