I don't know are you sure the value in the parameter @cFileName is correct?

The trigger works?

This Looks a little funky

if (SELECT TOP 1 accountno FROM deleted) in (SELECT  accountno from Contact1)

try

if exists (select * from Contact1 join deleted on Contact1.accountno = deleted.accountno)

Begin

     ...

I'm a little confused on what your trying to do here.

*** Select items

SELECT DISCONTINUEDDATE,Q1,Q2,Q3,Q4,

Is this how your final query needs to look?

*** CREATE A FIELD CALLED SUNSET...

About the only thing I can think of is an open transaction.

shrinkfile pertains to the log also.

the shrinking of the log file usually only takes the "Free" contiguous pages at...

tough to say.

Are you in the correct database when you manually execute statement

select object_Name(750065858)

Are you the dbo in the database, or SA on the server, it could be possible the...

Don't know what the event is specifically addressing, but the duration is just the time.

If the event is NOT taking server resources such as disk io, or CPU then I...

Without your code, tables and data scenarios that do not work it will be difficult to help you.

its probably a data scenario that your code does not account for.

http://www.aspfaq.com/etiquette.asp?id=5006

If you want to transactional replicate that table, you have to have a primary key defined. you cannot replicate with a unique constraint although symantically the same, sql server requires...

if you run

select object_name (750065858)

and you get null, then there is no object with an id of 750065858

to find the object id of a table use

OBJECT_ID('Tablename')

Input for is a string

if you do dbcc showcontig (objectowner.tablename) you get an error. But if you do

dbcc showcontig ('objectowner.tablename') it should work.

or you can do

declare @TableID int

select...

The table is the lowest level. To avoind granting access directly thru a table permissions can be granted to stored procedures which can limit the amount of data viewed.

Check it...

that is an update from clause

some thing like this

this will update every row in empower. Do you have more criteria to limit the # of rows to update?

update A

set fedref...

Sql server does not move 1 row from each page it does what is called a page split. It will move roughly half the rows on the first page to...

See books online about shrinking databases

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_462b.asp

look in books online for

dbcc shrinkdatabase

or

dbcc shrinkfile

you have to formulate your if statement into something that returns a boolean true false

declare @ageYear varchar(10)

set @ageYear = '44'

if(isnumeric(@AgeYear) = 1)

select 'true'

else

select 'false'