captbob007 (4/13/2012)

---

I didn't think opening a database up to all users would be this hard, but I'm getting nowhere fast so I figure I'll post here.

I have a database that...

I cannot say I have seen any official guidance on revoking public's access to system procedures.

I have seen guidance related to public's server-level privileges, specifically the GRANT VIEW ANY...

I've seen mail servers reject email to distro lists unless it comes from trusted sources to prevent spammers from hitting them. Your mail was queued, but see if it was...

Please post the actual error messages.

chumphrey 12211 (4/13/2012)

---

Mea Culpa, my bad for not doing more research! I ran this new code with the "alter user" but nothing was returned. I'm guessing I had...

csoloway (4/13/2012)

---

Upgrading to a version later than SQL 2000 is not an option at this point. I simply have to get this thing moved from one data center to...

Did you install Developer Edition named instance or just quit after seeing SSIS-state during the installation process?

If you can play, I would try installing the Dev instance and see what...

SQL Server 2005 SP2a Product Samples

I would definitely try to get them onto a supportable build before starting. Is upgrading to 2008R2 running in 80 compatibility mode an option? SQL 2012 was the first version...

You can look in sys.dm_exec_sessions for running sessions. For Agent jobs the program_name column will look something like this where the binary string will be the id of your job:

SQLAgent...

What documentation on the web?

Here is the official documentation for sp_change_users_login and is states:

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature...

varchar2 ? Is this an Oracle question? This is a Microsoft SQL Server Forum.

In general it is proper practice to choose the appropriate data type from the outset. It is...

Thanks for the email. Interesting file...it appears the data provider is too clever for everyone's own good. The file is actually an Excel htm file (binary format) changed to have...

I just asked them to email it to me directly. If the PM attachments are working normally in general then it was probably just a bad upload like you said....

Just to throw another wrinkle out there, I am on a 32-bit machine and I had no trouble accessing the Instance Names key on a 64-bit Windows server running 64-bit...