A screenshot may help

so there's no weird groups under Home -> Properties -> Security?

not just the Report Folder (if any), Home is the parent folder and children folders by default...

Do you mean REPLACE all single quote with nothing (i.e. REMOVE all single quote)?

Quick and dumb way is to copy the line 70 times

Maybe generate UPDATE script via SSMS to...

I dont think TINYINT is a new data type

http://msdn.microsoft.com/en-us/library/ms187745.aspx

But my guesses are either BIT or TINYINT

Thanks for the great tip

Something to keep in mind for future FILESTREAM implementation

I am curious to know too

Would guess NO though

Even if you create a view that XQuery the elements as a column

I don't know if you can SCHEMABIND it and create...

We download our production data in house, then auto-restore them to Staging/Report Server

That's the easiest way

For backup and clean up, you can use the built in 2005/2008 Maintenance Plan/Wizard

You can specify WHICH DB's to backup, and how long to keep them

As for compression, 3rd party...

how about a Computed Column that "computes" i.Quantity * i.Price

http://www.sqlservercentral.com/articles/User-Defined+functions/complexcomputedcolumns/2397/[/url]

Prasad (9/25/2008)

---

Thanks for your help.

I have restored the database in another machine an the copied the row into the original table.

It worked.

But my worry is in case of multiple rows...

Haven't had time to reply to all

but do want to ask, is the upgrade plan to SQL Server 2008 Enterprise, or Standard?

A lot of features you mentioned are only available...

Pretty certain it's NO, it is not backward compatible

You can restore 2005 backup in 2008

not restore 2008 backup to 2005

However, now I do wonder, if you use 3rd party tool...

Probably a partial reason for SPARSE column in SQL 2008

It's meant to be used for a column where MOST values are NULL

SPARSE column, NULL will not take up any space

I am very curious as we are planning to move to Windows 2008 for IIS 7 and SQL 2008

Is there a proven performance gain?

I have already seen firsthand the "fun"...

We have moved Production a few times

Backup-and-Restore: you can almost have no down time as we just copy the new records into the NEW server after

Detach-copy-Attach: down time for sure,...

TRUNCATE_ONLY will be gone soon too

It is gone in SQL 2008

http://www.sqlskills.com/blogs/paul/2007/10/12/BACKUPLOGWITHNOLOGUseAbuseAndUndocumentedTraceFlagsToStopIt.aspx