1 of many ways...

select name from sys.databases where recovery_model = 1

NJ

Leaf level of the clustered index contains the actual data rows of the table , so moving clustered index means moving data.

Test yourself..

alter database pubs add filegroup fg_test

go

alter database pubs

add...

There are quite a few ways doing this..Here is the one..

Drop Clustered index on table in primary filegroup and recreate it in secondary filegroup...n you are good.

NJ

Use your method if you are running backup command through job. It will not change schedule.

I see some syntax mistakes. Here is the correct one try running this..

if you still get any error please post error too..

select

[Incident #],

[Urgency ID],

[Group Name],

[Open Date & Time],

[_SMDBA_.Incident_Age]...

Without expected resultset..it is difficult to develop correct query but here is one guess..

with leadtest

as

(

select ID_PRVD_ORG , ID_PRSN , DT_BGN ,

row_number() over (partition by ID_PRSN order by...

My bad...

Here is one more way you can do it..but doesn't looks elegant..

create table #t1

(

d datetime , p nvarchar(25) , text_d nvarchar(1000)

)

go

insert into #t1 exec sp_readerrorlog

go

select t.failed_login ,count(t.failed_login) as num...

In Sql Server 2005 you can use logon triggers and direct the result to temporary table. Finally query table to find out logins with more than 5 failure...

See BOL for...

This is a problem in SP2. This problem was not there in SP1..

Better script the process and schedule it to run through job.

NJ

If you are ready to do it dynamically..this would work.

declare @dbname sysname

select @dbname = name from [linked_server_name].master.dbo.sysdatabases

where...

You can not remove public role for login..you will get an error.

If you want to control access you can grant\revoke permissions to public role and hence that login..

NJ

You can also try.

Backup log tempdb with no_log

then

DBCC Shrinkfile(tempdev , 100)

This would also work..

select distinct name , id ,dept ,code = replace(

(select code as [data()] from #test t

where t.name = t1.name

for xml...

Which edition and service pack of sql server??

In no way you can update system table in sql server 2005.

NJ