Ramji29 (1/19/2010)

---

try this.

USE master

EXEC sp_configure 'show advanced option', '1'

go

RECONFIGURE WITH OVERRIDE

go

EXEC sp_configure 'allow updates', '1'

go

RECONFIGURE WITH OVERRIDE

go

--Now update the table u wanna update

begin tran

update master.sys.sysdatabases set status = 16 where...

Stupidity

Oh, there is a way to update the system tables in SQL Server 2005, here's how. Let us know if it works for you. No warning about NOT...

Best suggestion, tail-log backup, then restore the database.

I have to question updating the system tables to begin with. This isn't something that should be done without a lot of thought and testing. The fact that...

It would help to see all the code, not just a snippet. Based on the snippet alone, hard to say as there are variables being used in the INSERT...

First, and most importantly, do you have current backups? Was the log file on the same drive? If not, you may want to do a tail log backup....

Who decides what is right (or better, when it is right), the developer or the client/stakeholder/user?

How many XML indexes can you have on a table with no XML columns?

To be honest, when asked about number of indexes, unless specifically asked about FTI and XML indexes,...

No, you cannot update system tables.

I can't really figure out what you want. Please take your sample data and show me what the correct output would be. Also, include any additional info based...

amitabhssinha (1/19/2010)

---

Hi There All,

I have a table with DateTime field with millions of record. Now I want to retrieve records based on search criteria of DateTime field.

I have...

Try this:

ROUND(Col1 * Col2, 8)

Krasavita (1/19/2010)

---

I can't re name table, I need to leave 200 million records and that table and I need to delete 190 millions records.

I created store procedure:

BEGIN

SET ROWCOUNT 1000000;

...

itsmeman (1/18/2010)

---

No cursors were used. 150,000+ records took an hour to change, yup, bad, bad, bad. Those 150,000 could have had many more charges associated with the records. Both tables...