hi,

look in Book s Online (BOL) for DBCC DBREINDEX. This should help.

Paul

hi,

  in my experience it is usual to have system databases set to simple recovery, with a daily full backup. 

Paul

Hi, you need to read Books Online (BOL) for an explanation of recovery modes. You cannot backup the transaction log of a database with simple recovery mode as the transaction log...

change the " to ', or change your set quoted identifier setting !

rob,

see my reply above !

Paul

hi again, the following works :-

i created a table my_table

(id int, day varchar(10))

and inserted the following rows :-

insert into my_table values(1, 'monday')

insert into my_table values(2, 'tuesday')

insert into my_table values(3,...

I see, it's the other way around. maybe case will work. I'll have a  play around and let you know

Paul

hi, you need the LIKE clause :-

select *

from daysoftheweek

where day like '%Friday%'

and if case is an issue use lower (or upper)

select *

from daysoftheweek

where lower(day) like '%friday%'

Hope this helps

Paul

hi ben,

  no, no issues using a permanent table (as long as you remember to truncate it)

Paul

hi,

i usually use a 2 stage process , firstly execute the following in query analyser

select "select count (*) '" + name + "' from " + name

from sysobjects

where...

hi steve,

it appears if you use sp_helpdb. However be aware on sql 2000 collation orders can be set at the database, table and column level.

hope this helps

Paul

hi, ben

whenever i come across this problem, i create a table that has an identity columns and then select the data into that, as follows :-

create table add_unique_identity

(unique_identifier int...

hi,

you can try the following :-

create table #test

(name varchar(100), rows int, reserved varchar(50), data varchar(50), index_size varchar(50), unused varchar(50))

insert

into #test

exec ( "sp_MSforeachtable 'sp_spaceused ''?'''")

select * from #test

this works,...

hi,  i think that if you don't specify a time 00:00:00 is appended to it, that's why in case 1) the 8th March row is returned. 

another solution would be...

hi, the following article might help :-

http://www.sqlservercentral.com/columnists/sjones/outerjointrouble.asp

paul