Thanks...that explains it, as we upgradded the SQL server to the most current release level a few weeks ago.

I like it when I solve my own problems.....

the execute has to have () around the sql and it works...

execute(@checkSQL)

***************

Wasnt that straight forward

here is an easier way to test....

declare @checkSQL varchar(500)

set @checkSQL = 'select name from master..sysdatabases'

print @checkSQL

execute @checkSQL

***************** returns the following and error ********************

select name from master..sysdatabases

Server: Msg 911, Level...

more research has uncovered the following which answers my questions on what causes aborts.....  While my example is catching STATEMENT errors, the BATCH errors are causing the procedures to fail.   Looks...

I like wz700's answer. 

BUt it sounds like to me an application issue.  Before it is entered in, have the app do a check.

Also you may want to consider...

Ok, my Oracle architecture is a bit old, so someone correct me if new features have corrected my statements here.

First the physical architectures for the storage of data is...

Lots of things can be causing this.

1) Physical pages have limited space, but will "fill in the gaps" when a new record is inserted.  SQL Server writes a row...

Use this script....it will kill all connections and take the database off line before anyone can re-attach to it.  

Have Fun

Eric

Declare @tblConnectedUsers Table ( SPID  int)

Declare @vcSQLText  varchar(200), @iSPID   int

--Get the currently connected users

Insert...

Use this script....it will kill all connections and take the database off line before anyone can re-attach to it.  

Have Fun

Eric

Declare @tblConnectedUsers Table ( SPID  int  &nbsp

Declare...

This problem is almost always incured when you have multiple people or processes going against a KEY_DEF type table.  

1) Consider using an Identity for the column that has the...

Can you take a page out of the data warehousing book.

create a new table that looks like this:

Create table Summary_table ( areaID int, cat int, type int, sum_count int)

then put in a trigger to maintain...

Both options work very well...but the second option of coping the files and attaching a new database will be faster than a restore. 

Have fun

Eric

Is your SQL Server agent started?

Scheduled tasks wont run without this service started.

Just an idea, let us know the resolution

Eric 

The above suggestions are good, but it is is an existing application, after you cleanup the data, make the cleanup a trigger.   Regardless of  how ever it comes in, it will be...

My co-worker had the same issue.

When he was shrinking the database, he was shrinking the database without having the "Move pages to beginning of file" option checked.  When the...