duplicate post .. but here's my answer again!

hi,

i think the problems is that the itemid in ( @itemids ) bit of the query is being resolved as ''a','b','c','d''....

hi,

i think the problems is that the itemid in ( @itemids ) bit of the query is being resolved as ''a','b','c','d''.

a way around this would be to...

and to kick it off , a list of users who are already over 500 ?

Paul

hi,

i created a table as follows :-

create table cpu_usage

(dt datetime, spid int, cumulative_cpu bigint, cumulative_io bigint, login_time datetime)

inserted the data from your original post and did the...

jags,

I see what you mean, it's not easy !

Paul

hi,

if you are on SQL 2000 you could declare the variable as a table datatype, and when you assign a string that it too long it returns the appropriate...

hi,

try :-

declare @postcode varchar(10), @area_code varchar(10)

select @postcode = 'GU14 7NJ'

select @area_code = substring(@postcode, 1, charindex(" ",@postcode))

print @area_code

HTH

Paul

Edited by - ripg1011 on 09/11/2003 08:25:41 AM

"Unless you recreate it, You wouldn't be able to see it. "

that's true. I always drop and re-create stored procedures for this very reason.

Paul

hi, try

declare @date datetime

select @date = "Sep 5 2003"

select name, crdate

from sysobjects

where type = "P"

and crdate > @date

order by crdate

in the database in question

HTH

Paul

hi, check out the datename function in BOL :-

select datename(month,1)

returns January and so on, just change the number ...

HTH

Paul

hi,

we had a similar problem, and I used a base date to work out the average :-

DECLARE @tt TABLE (THE_DATE SMALLDATETIME)

INSERT INTO @tt...

hi, can you temporarily remove the logins permissions in the database in question ?

or change the default database to another one ? this may make the connection fail, so you...

hi,

try allocating the users to the TargetServersRole Database role in msdb

this seems to work for us.

Paul

hi,

try :-

restore {db_name} with recovery

on the secondary database to bring it on-line and no further transaction logs will be able to be loaded....

I agree with frank, use break instead !

Paul