Viewing 15 posts - 706 through 720 (of 789 total)
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...
June 24, 2003 at 3:45 pm
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...
June 24, 2003 at 3:34 pm
Fix: Uninstall SQL Server. Install Oracle.
(I like these easy ones)
June 24, 2003 at 5:47 am
Fix: Uninstall SQL Server. Install Oracle.
(I like these easy ones)
June 24, 2003 at 3:15 am
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...
June 24, 2003 at 3:00 am
Preview
if your server is case insensitive (the default), you could make the WHERE criterion:
BINARY_CHECKSUM(Streetname) <> BINARY_CHECKSUM(UPPER(Streetname))
June 24, 2003 at 2:37 am
Sounds like you didn't uninstall SQL Client Utilities. Try uninstalling everything, then installing SQl200 and its client utilities.
June 24, 2003 at 2:28 am
Did you try SQL 7 SP4 as you proposed? What about uninstalling/reinstalling xp_smtp?
June 23, 2003 at 7:57 pm
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...
June 23, 2003 at 3:09 pm
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...
June 22, 2003 at 3:37 pm
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...
June 22, 2003 at 4:48 am
Another option is to use EXECUTE:
create procedure myrenamer
as
execute ('use otherdb exec sp_rename ''thetable.[colname]'', ''newcolname'', ''COLUMN''')
June 22, 2003 at 4:26 am
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...
June 19, 2003 at 5:58 pm
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,...
June 19, 2003 at 5:38 pm
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...
June 19, 2003 at 5:25 pm
Viewing 15 posts - 706 through 720 (of 789 total)