No 100% sure, but i think one of the fields in the Catalog table of the Report Server database holds the owner info. You could possibly write some...
Hi everyone, I have a bit of a strange Reporting Services problem...i have a report with 3 parameters, 2 of which have default values: Parameter one:...
ok, so I'm 26, so probably fall in to the 'young people' category...when it comes to older people and computers, i find that half of them know far...
Hey Guys, Nope, the database isnt involved in replication...i think someone did add an index rebuilding job recently, but as far as i knew it was...
i think you just need to add dbo (or whoever the owner of the function is) before the funtion name: select dbo.<functionname>(columnname) from...
we have an issue where our database has suddenly started producing very large transaction logs. The log is backed up every 10 minutes, and has is...
Thanks guys...i guess i will have a look into scope_identity as an alternative. I saw that sql server v7 issue when i was hunting on Google...it is...
also has update and delete triggers, but it is definitely the insert one being fired. 'I reject your reality and substitute my own' - Adam Savage
sp is really simple...i wont post the whole thing, but it is something like this: insert into bookamt (col1, col2, col3) SElect 1, 2, 3 from...
Heya, I have an interesting issue with @@identity and was wondering if anyone can shed some light on it for me. I have a stored proc that is...
Takes 2 strings as input and returns an int saying how many characters are different between the 2 strings..i use it to pick up typos and still join,...
that last minute penalty to Italy sure was a shame!! I was sitting up at 3am watching the game and it was such a disappointment!!! But really,...
are the credentials for the datasourse saved and valid? 'I reject your reality and substitute my own' - Adam Savage
I had the same problem, and came up with a not-too elegant work around! i changed the query to include another value ("--All Branches--") that would...
Yep, the Aussies fought hard, but were beaten on the day...i think the 2-0 score line was a bit flattering to Brazil, but a draw with Croatia will...
Gotta throw in my 2 cents too! Australia: 3, Japan: 1 I believe that puts Australia on the top of group F at the moment!!! (after 1 game) Now we...
I'm going to be a good, optimistic, Australian and say Australia is going to win <img src='/community/emoticons/emotion-1.gif' alt=':-)' /> <br /><br...
Im not 100% sure the date section is causing the problems...basically it is a horrible looking procedure and i am trying anything to get it to go...
Hi Twan, 1 further question- if i do split it up into a series of IF ELSE blocks, wont i have the same problem with SQL Server generating a query...
Thanks guys, Twan, unfortunately there are a number of other parameters in addition to the dates that can also be null (there is 11 in total!) so...
Separate names with a comma.
