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...

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 is the...

is it instant? or is it several minutes later that the related data is removed

just thinking you might have a sql server agent job that purges related data

it can only...

if you set up a profiler trace then you should be able to capture this

just remember to set "RPC/statement/batch starting" and RPC complete events in the trace - if you...

another thought - although i may be barking up the wrong tree here..

how does SQL 2005/2008 know if there has never been a backup? if it's the MSDB backup history...

also before you run these tests make sure you clear the buffer cache and make sure they are both compiled - otherwise you will skew your results

I've experienced similar - i think this is to do with your UDF

try creating a temp table (for test purposes) and insert into the test table the data returned from...