select name from sys.triggers where parentid = object_id('yourtable')

you could run the following query into a temp table and then loop through it disabling the triggers one at a time

select name,parent_id from sys.triggers where name like '%GLPAudit%'

From the...

whats the datatype and length of @v_sql?

disable trigger "full name of trigger"

on "object" --this can be a table/database/server etc

you can also disable a DML trigger using the following

alter table "your table"

disable trigger...

Yes i agree with you coastliner. 4gb is the way to go, leave the memory setting as it is and sql will use 2gb max.

Ignore all the 3gb boot.ini...

jim.powers (5/13/2008)

---

You will need Integration Services if you create maintenance plans in SSMS since they use SSIS. SSIS is also used to transfering data in and out if you need...

coastliner (5/13/2008)

---

I monitored with sysinternal Process Explorer and discovered that , apart the Main SQL Service, the other does not take as much memory, and I think I could disable...

Coastliner, are you actually using all the services? or have they been installed by someone who clicked every available option on the install and then just left them running?...

If its a new installation its probably because by default sql express (and dev) doesnt allow remote connections. to change this go to the surface area configuration tool and...

Thanks for the response, i thought they may well fall under the middleware/multi-plexing and read this MS article http://www.microsoft.com/sql/howtobuy/multiplexing.mspx which was clear as mud 🙂

Firstly they say... "A...

this problem seems to be solved. I rebooted again today and now its magically all working again :w00t:

It is also probably worth noting that i just ran a quick test against another server using the waitfor test and that also timed out after 10 minutes.

So my conclusion...

in profiler you should add the deadlock graph and lock: deadlock chain events in the Locks object. This will produce a graph that will show what processes locked up...

Chandrachurh Ghosh (5/2/2008)

---

Can you provide us the following details -

1> r u using a network drive or a tape drive to save?

2> have you saved it as your backup device?

3>...

In this case it is not disk space, that was...