Firstly, Can you check if dbmail is enable in sys.configurations.

BOL: "Execute permissions for sp_send_dbmail default to all members of the DatabaseMailUser database role in the msdb database. However, when the...

Correct me if I am wrong here.. looks like you are trying to archive data.

How big is the data size in the table?

If the data size is significantly big,...

2.0

Thanks for your suggestions. will edit my script to use that cmdlet instead of my send-email function.

Thanks again!

Thank your for appreciating my code!!

Your suggestions for using sp_dbmail can only work if I open a new connection to SQL. I have written something which will avoid it. Here...

Thank you Johnathan. Extended Events was my biggest take away from Devconnections conference last week. Will implement that.

Thanks again

Jagan K

Per my understanding, partitioning column should either be part of the clustered index or the Primary key and it should not be null. Else, it will reside left most partition....

jvkondapalli (1/24/2012)

---

Revenant,

....

Hello gurus,

I need your comments on the table partitioning we implemented in our environment.

we have a pk column (INT), Partitioning column(Datetime), fkcolumn (INT), few other varchar columns

We...

Revenant,

....

Hello gurus,

I need your comments on the table partitioning we implemented in our environment.

we have a pk column (INT), Partitioning column(Datetime), fkcolumn (INT), few other varchar columns

We created...

This should Help!

/* THIS SCRIPT IWLL GENERATE THE LOGINS AND DATABASE USER INFORMATION.

SCRIPT CAN BE USED TO GATHER DATABASE USER INFORMATION PRIOR TO DATA REFRESH.

This script will generate the...

Where is the job hosted on?

Can you also post the connection properties of the linked Server

Column1 is varchar?

can you tell a bit more about the necessity of running delete statement over the linked server?

Thanks

Jagan K

Column1 is varchar?

can you tell a bit more about the necessity of running delete statement over the linked server?

Thanks

Jagan K

I can re-initialize the subscriptions. But, in theory this should not be the case right?

Another update is that we tried Insert Tocken and that cleared the issue.

Eventhough the issue...

May be SP matters. I had the same issue with 2005 and 2008. installing latest SP on 2005 resolved my issue.