the problem is not about cleaning system views; it's that the old views can now give you inaccurate information; using the newer correct views will solve the issue.

the trouble is...

i thought this was interesting; from what i read on the Wikipedia you have to create a plain text attachment, with specific tags/formats inside that file, and the name of...

it depends on the format of the julian date; here's a couple of examples, but post back how your data is formatted;

DECLARE @sdate int

SET @sdate = 109252

--in AS400/DB2 date is...

can you show us the real trigger instead of pseudocode?

it's running too long because there's an issue, but translating the real trigger to pseudo masks the real problem.

Gianluca Sartori here on SSC posted the code below in another thread, and i really like how well it works. this might help you with what you were after...it...

how would you get the CLR to write the...

maybe he was doing a select * from BillionRowTable so he could see the column names, and the error threw him off.

He may not be familiar with sp_help [TableName] yet.

i would consider leaving the transaction table alone, with one row per transaction, and add a payments table with a FK to the transaction.

that way you can have one to...

i'm guessing that tud.value is stored as a varchar instead of an actual datetime field?

could it be one or more values are in that column , say, english date...

i'm not a network expert, but if you have two different domains, the login mydomain\Lowell has no priviledges, and vice versa: the login yourdomain\AK1516 has no rights to anything on...

unless you have a trust set up between the two domains, you'll have to set up the linked server using a SQL login. you would not be able to pass...

note that even if the table with a billion rows had two columns, an ID and a varchar(30) for a name or something(38 bytes of data per row), you'd need...

RPSql (11/3/2010)

---

Select * from a table with one billion rows failing with following error (SQL 2005 SP3 HF11)

An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException'...

what about this?:

you need to drop(or delete/truncate)

in the FK hierarchy...

there is a suite of views in the msdb database that you want to look at:

take a look at these:

select * from dbo.sysmail_allitems

select * from dbo.sysmail_faileditems

select * from dbo.sysmail_sentitems

select *...