If there's a lot of jobs to be scripted, right-click on JOBS in the EM tree and then 'All Tasks' then Generate SQL Scripts. You can manually edit out...

Maybe your post presents a case for a new SQLServerCentral forum: "Stuff we'd like to see in future SQL Server versions". I know there's a bunch of things I...

Fix: Uninstall SQL Server. Install Oracle.

(I like these easy ones)

Fix: Uninstall SQL Server. Install Oracle.

(I like these easy ones)

Sounds like you're trying to create "permanent" tables in TempDB, so you need to do:

use tempdb

grant create table to public

But, because it's TempDB, this permission will disappear upon SQL Server...

Preview

if your server is case insensitive (the default), you could make the WHERE criterion:

BINARY_CHECKSUM(Streetname) <> BINARY_CHECKSUM(UPPER(Streetname))

Sounds like you didn't uninstall SQL Client Utilities. Try uninstalling everything, then installing SQl200 and its client utilities.

Did you try SQL 7 SP4 as you proposed? What about uninstalling/reinstalling xp_smtp?

Sorry, but I can't agree. Both of the following first 2 examples use an INDEX SEEK to resolve the NOT EXISTS. The 3rd example can use the data...

NOT EXISTS can be fast, but depends on your indexing. If the NOT EXISTS subquery can exploit an index then yes, it will be quick. Display the Estimated...

Without researching it too much... I can tell that SQL2K loves having a clustered index. On my test machine I had the same table scan results as you, but...

Another option is to use EXECUTE:

create procedure myrenamer

as

execute ('use otherdb exec sp_rename ''thetable.[colname]'', ''newcolname'', ''COLUMN''')

Apologies... I could have assisted in the re-creation of the PUBLIC permissions. But I got too tied up in the intrigue as to how they were lost in the...

You only need to allow access the the user db, and optionally place them in a user-defined role. For the SP in that db that creates a temp table,...

Be careful of assigning db_ddladmin for the purposes you've described. It will give the users permission to manipulate object definitions (tables/views/SPs), but not the execute permissions you require.

Unfortunately SQL...