A reference for those interested in FORFILES command:

http://technet2.microsoft.com/windowsserver/en/library/9660fea1-65c7-48cf-b466-204ba159381e1033.mspx?mfr=true

Naivete to the side, here's an old saw:

There's never time to do it right the first time, but there's always time to do it over.

Well, that was the brute force solution...

What kind of connection? Towards what end? Are you shipping data in either direction? replicating? trying to execute a multi-server query? Pls give us some...

Jon (12/31/2007)

---

... when I initially configured the database, I had assigned the following rights to the application role 'boxi':

- db_datareader

- db_datawriter

- db_ddladmin

- public - it was already checked and...

For what it's worth, I also experienced severe challenges trying to get Named Pipes to work, following the 'best' MS advice. In the end, connecting from SS2k5 Standard Edition...

OK... I'm a newbie returning after a several months absence... here's the scenario: Express Edition (Compact ed?) does not support scheduling regular backups, so the goal is to use...

Rejith -

1. Welcome to the forums!

2. IF this is a SQL 2000 problem, you may have more luck with responses in the SQL 2000 administration forum, rather than...

How frequently are statistics updated? Have you forced a recompile of the procedure since early May (date of last documented change in this fragment - which year was it...

Along the lines of your 'rant' portion: IF this is an adhoc query, and IF you want to pay your client for the amount of time and effort they...

And we wish you would have pointed exactly which aspect of SQL Server you wanted to focus on first.

There are no quick fixes. SS2k5 is an involved, complicated software...

da - when you catch up to this thread this evening, some suggestions - to make your notational use clear, and hopefully allow us to respond to you more accurately...

This is where they will tweak their numbers and then want to overlay what they've done with the latest and greatest? or will they want to keep their various...

Are you saying that the vendor is insisting that you maintain compatibility 80 so their software will work? All that means is that you are unable to take advantage...

try executing the following and report back please.

select * from msdb.dbo.sysjobs_view