Thanks for those suggestions.

One thing that has happened is that SQL 2K Standard has been replaced by SQL 2k Developer Edition on the laptop, and now the web based app running...

Hi,

I take it your admin skills are fine so the actual administration of the database is fairly straightforward.

That is a bit vague.

It depends a lot on what the database is...

Hi,

You could create a function within SQL and just use that in your select statement fro your asp page.

The function could be something like

CREATE FUNCTION dbo.funcProgramming(@CandidID int)

RETURNS nvarchar(500)

AS

BEGIN

 declare

Thanks for all those suggestions guys.

This site is a great resource.

Graeme

You could try the following

ISNUMERIC returns an integer so...

  If isnumeric(@SPID) = 1

     Begin

 PRINT 'Select all'

        select SPID, KPID, cpu, physical_io, cmd, nt_username, memusage, WAITTIME, LASTWAITTYPE, hostname, program_name, login_time,open_tran, status...

Hi,

DR is a big subject and a plan can become complicated if you are not careful.

There are many resources on the web on producing DR plans, but if you are...

Justin,

Thanks for that!

Yeah, that's what we are going to try.

I think that will be the least time consuming.

Thanks again..Graeme

Hi,

Instead of renaming the table, why not create a second table to store the copied data.

So you would copy the data first, truncate the original table and then let the...

Yeah, I agree with Grasshopper,

I usually run the following:

DBCC SHRINKFILE(DBLOG)

BACKUP LOG DB_LOG

WITH TRUNCATE_ONLY

THEN DBCC SHRINKFILE(DBLOG) and his does the job

If you have replication running you may have to run sp_repldone...

Having investigated this I have to agree with you.

Nice one,

I shall remember that.

I stopped/started the service and the database came back on line.

Fortunately this was only a test environment but it is certainly worth going through the options.

Thanks again...

Yeah, we tried that.

Sysdatabases was not showing the database as suspect although Enterprise Manager IS showing the suspect tag.

Trying the Stop/Start, detach/attach route now.

Thanks for that.

Graeme

I have discovered the problem.

A rather discrete duplication in one of the minor tables.

Many Thanks for your input

Regards

Graeme

That was my thought but....

This query is being run directly in Query Analyser.

If I select a set for a particular person, the results are correct, but if I run the...

Well,

Like I said Person A has the following RoleIDs

2

10

1316

But having made the extra joins and using the appropriate criteria, the RoleIDs appear as

2

13

I can't understand where the 13 is coming...