ok,

this is a very big topic

it really depends on who you are, what you are doing, how much risk you are prepared to take.

In any decent environment your...

i've seen a few similar issues posted, and microsoft allege that is as a result of an incomplete or failed service pack or hotfix installation

try reinstalling the last service pack/hotfix,...

have you coded an sql account and password into the data source of the report, or are you relying on the execution account.

i suggest creating a SQL account and convert...

apologies - misread the question - saw the rowcount and assumed it was a while loop - ignore me - i need more coffee:-D

the first may give you more problems - since the total duration of the loop is potentially very long, you may update records that have been modified since you started...

ok - so you are using either dynamic sql (a bad thing) or you are building your sql string in your app(a bad thing)

i can't tell which from the post

but...

this is easily done in enterprise manager/management studio

note - you are moving the table between "filegroup" and not file

a file is a member of filegroup and all tables in...

On an asside...

My experience of this is that if you keep putting off the tasks that require a lot of testing and require some guts, then you will eventually run...

what are you trying to achieve, what is the error message?

i suspect this may be your like clause

_ is a wildcard in "like"

try NOT LIKE '%sp[_]%'

it's possible that ourprocs are actually erroring at some point rather than timing out - and our web app isn't handling the error correctly and just lazily displying a timout...

from experience RPC starting is required if the Command timeout occurs and the command is killed before any results (even the 1st row) is returned.

Most of my monitoring for timouts...

as i said you need RPC starting as well -

if you know this is going to be a stored proc then you can remove batch starting and t-sql starting...

please ignore my posts - i didn't read the code correctly

michael vessey (4/28/2009)

---

wannabe dba (4/28/2009)

---

I have created a procedure which will create backups of all the databases on the server for a SQL SERVER express instance when called from OSQL.Here...