I'd use TABLOCK as specified in BOL(http://msdn.microsoft.com/en-us/library/ms174335(v=sql.90).aspx)

Sure, I had column that delimited values in it and I wanted to split that column so that it created on row for each value. The original table was...

ANy chance you can use backup compression? That should speed up the time backups take.

Sounds like a pretty common environment to me. Almost everywhere I've worked we've had multiple versions of visual studio installed. I currently have 2008 and 2010 installed. ...

Not at the same time. A connection is to one server. If you want to query multiple servers in a single query you'd need to setup linked servers...

If you know the query, then you have the tables where the data is being modified so you can query sys.triggers to see if any of those tables have triggers...

YOu could provide a locking hint on the insert statement to lock the table, thus blocking any other process accessing the table until the transaction is complete.

I think this article, http://www.sqlservercentral.com/articles/T-SQL/68467/, has what you need. You'll need to tweak it to work with what you want but it provides the concepts you need.

YOu can create a query or queries that use sys.database_files and the FILEPROPERTY function to determine space available. Something like this:

SELECT

...

Proper indexes can also help with this issue as you can get more granular locking which increases concurrency.

How is the web application connecting to SQL Server? IF it is using a shared login (very common) then you need to get the user name from the web...

I agree with Grant.

The only issue with Extended Events on 2008 is that there are some key events that aren't available in Extended Events vs. Trace Events.

If you...

First of all, with the way this trigger is written you should add:

IF @@ROWCOUNT > 1

BEGIN;

RAISERROR("This trigger does...

What version of SSMS are you using?

If you close and re-open SSMS does it work then?

Have you tried using the generate script button instead of clicking OK on the job?

hemanthnightmoon (7/9/2012)

---

Thanks Both,

What i did is

select getdate() AS runtime, SUM (user_object_reserved_page_count)*8 as usr_obj_kb,

SUM (internal_object_reserved_page_count)*8 as internal_obj_kb,

SUM (version_store_reserved_page_count)*8 as version_store_kb,

SUM (unallocated_extent_page_count)*8 as freespace_kb,

SUM (mixed_extent_page_count)*8 as mixedextent_kb

FROM sys.dm_db_file_space_usage

...