It's not a bug. It's a warning that your table's too wide. The max size of a row in SQL server is 8060...

An inline function only allows a single select statement as the function body. When run, the optimiser will treat it like a subquery.

multi-statement functions allow a number of statements...

Are you seeing queries running longer than they should? Are you seeing blocking? If the queries have high wait times, what are they waiting on?

My preference is to set the max memory and let SQL manage the rest.

michael vessey (10/15/2008)

---

you'll also have to alter master..sysdatabases - one of the columns in here - Status if i remmember correctly determines if the database is marked for replication- you'll...

That's kinda what I thought it would return.

You have two options at this point

1) Restore a backup of the database or replace it with the copy.

2) Script out the schema,...

billross (10/15/2008)

---

What I find exasperating in dealing with T-SQL is that it can't do this:

UPDATE myTable

SET

[my field] = table2.[my field]

and it can't even do this:

UPDATE myTable

SET

[my field] = (select [my...

Or (M, Y). It won't make a difference with this query, since it's an equality.

That's why we ask for the table schema.

Assuming that the relationship between product_id and product_name is a 1-to-1, this should work

SELECT table.uniquekey, table.product_id, table.product_name, sub.last_purchase_date

FROM table INNER JOIN

(Select

...

I would suggest that you rename the corrupt DB, then restore the clean backup along side it. Run CheckDB to make sure there's no corruption. If it's clean, then see...

Have you done a stats update on all tables after the move to 2005?

What do you want to know about them?

Don't try directly updating/copying the sysindexes table. It;s a system table and if you mess with it you could end up with a worse problem than you currently have.

Please run...

May Anne Duran (10/15/2008)

---

I've been deleting .ldf files whenever it's size is way too big and eterprises manager simply creates a new one. and the issue is not the log...

I've heard of that. I want to get it, just to see how they've done it. I know a lot of the MVPs are getting it for that reason.