I can give view Definition permissions but my question is:

Are these permissions are not enough to view objects ?

USE [ABCDEV]

GO

CREATE ROLE [abc_usr_rl] AUTHORIZATION [dbo]

GO

GRANT DELETE ON SCHEMA::[abc] TO [abc_usr_rl]

GO

GRANT EXECUTE...

thanks for your quick reply. But I am wondering that whether the OLD disk have some configurations attached with SQL SERVER ENgine. IS there any better plan this mine one...

Hey guys,

I also have same problem.This is regarding sql 2005 std ed.

I want to disable all sqlserver agent jobs with checking the status. If job is running, the script will...

thanks for your kind suggestions.

AKP

Give me more details about the precaustions.

Actually I need to generate a report about All server names, All Dbs, IP address, All Instances and other server related informations. SO I need some scripting idea from where...

TO make sure the Normalization rule, there must be primary key in a table. If there is no PK then how can you stop data redundancy in a table. PK...

Actually, other guy wrote those views, but I am working as query optimizer. Thanks for your kind suggestions.

 I remove that and try, it works faster with same output .

THanks

AKP

This is the result of SET STATISTICS IO ON

(12 row(s) affected)

Table 'areas'. Scan count 275, logical reads 560, physical reads 0, read-ahead reads 0.

Table 'Worktable'. Scan count 384307, logical reads...

view v_rpt:

SELECT     dbo.r_boffice.r_path, dbo.r_boffice.d_id, dbo.r_boffice.r_date, dbo.r_boffice.r_type_id,

                      dbo.l_r_boffice.r_name, dbo.r_boffice.r_id, dbo.l_r_boffice.r_title, dbo.l_r_boffice.display,

                      dbo.l_r_boffice.l_id, dbo.l_r_boffice.c_id, dbo.div.ex_id, CONVERT(varchar(32),

                      dbo.r_boffice.r_date, 1) AS rp_date_display, dbo.r_boffice.r_time,

                      dbo.v_div_All.Div_Dep AS div, dbo.areas.a_id, dbo.areas.reg_id,

                     ...

We need to take full workload to use SQL profiler. If we need to do in production database, it will be problemmatic. If there is any script which can find the...

When I create a index including all columns of where clause, it shows bookmark Lookups with index seek. But this also becomes costly for query execution. What can I do...

Can you give me some samples, how can i use for these above queries ?

Thanks

AKP

Thats true but w_id is primary key, is there any possibilities of getting more than one row.

Thanks.

AKP

Fields "ob_t_id ,s_id and comp" are in obj table which is a biggest table in our database.

Actually can you tell me how can i replace <> with other saragable operators.

Send...