Just curious if it were the rows that were being affected by the deadlock and I didn't see anything out there on it. But not critical.

have good night and...

Hey Gail,

Forgot about joining up to partitions, thanks for the quick response, didn't i read you live in So Africa? has to be late there.

Any idea what CleanCnt...

yeah those were supposed to be mb i was just typing it out

stunned -

dbcc shrinkfile (1, 1)

ALTER DATABASE tempdb MODIFY FILE

(NAME=N'tempdev' ,

SIZE = 128MB,

FILEGROWTH = 0)

Stop SQL

Start SQL...

Very well said Lynn it comes back to me like a sledge hammer.

Guys thanks for the responses Andrew I like your idea of Union into a table var and...

Thanks Ramesh -

I worked it out must have had a typo earlier in my replace. For those of you who are interested here's my code

REPLACE ("D:\\DataMart_Reports\\Today\\" + @[User::AppName]...

Something to play with - I ran into a similiar situation when during a rollback the client couldn't wait and told operation to reboot the server on a 6.5 database,...

Perhaps you could grab a query plan and evaluate at night what you plan on pulling over. Sounds wierd but i agree more info would be helpful.

Still having issues my environment is Visual Studio 2008 version 9.0.30729.1 SP

[Execute SQL Task] Error: Executing the query "SELECT APPName

FROM ...

Try either

Jzachark@win.ml.com or

john_zacharkan@ml.com

Yessir

Under Connection Manager expression for my csv i have "D:\\DataMart_Reports\\Today\\" + @[User::APP_Name] + ".CSV"

my issue is populating the variable...

Thanks Ira - I'll take a look see.

Thanks man, trying to avoid touching replication.

Would it make a difference if it the PK wasn't a cluster index?

My intention was to just drop them but wanted to point out the cluster indexes prior to execution.

Loweel thanks for the collation part of the script I haven't had a...

If restoring to a similiar build eleviated the problem then look to competing resources on the prod box.

Based on the database being used for a website I'm assuming most...