mapped drives are a pain in scripts...avoid them anytime you can... 😀

The simplest way to do this is create a backup of the db and restore it to the staging db. You can set this up as a script and...

This is best done using a multi value parameter.. This is available in ssrs 2005 and above.

I'm thinking check the collation settings for the database. Beware though, turning on collation for a database adds a lot of overhead. Even with doing that, I'm not...

This is a difference between Staff and Line employees...DBAs are staff and are paid a large percentage of the time to keep things running. Line employees, like sales, ceo's...

Microsoft SQL Server 2000 - 8.00.2050 (Intel X86) Mar 7 2008 21:29:56 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2...

Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000 (KB960083)

This patch is specifically for sp4. Technically since you don't have service pack 4, you don't need...

Do you mind posting your solution? 🙂

Check the release dates. The security patch needs to be applied after sp4 is applied

Awesome...let me know how you like it...

Sadly there are cases where trust can never be established. Sometimes the consequences of our actions sever trust forever take murder for example....

I would probably change the query to produce something other than null that you can use your iif statement on...also you could set the null processing or unknown member settings...

I'm in the middle of a great book on trust:

http://www.amazon.com/SPEED-Trust-Thing-Changes-Everything/dp/074329730X

The Speed of Trust by Steven Covey. He actually quantifies trust and gives examples of how it can...

The ssis package maybe running as a userid that doesn't have permissions on the file. Use the security audit log of the server/pc holding the file. It will...

sp 4 is the latest for sql 2000

http://support.microsoft.com/kb/290211

select @@version

it's a very long result with the service pack info at the end....