A silly question if u may say. for 2005 to 2008 upgrade, should i run 2008 upgrade advisor on the 2005 server?

Does the advisor has to be downloaded (only way?)...

ok i would run

Integrity check

dbcc updateusage

sp_updatestats

90 to 100

Is that all?

Its windows 2008, 64 bit

Reconfirming... so i can give max memory 2147483647 even though i have 4gb memory only. SQL would get memory pressure and page out only if it exceeds 2147483647. Is this...

Yes i would be using upgrade advisor. Apart from that is there any list which gives the features, funcationalities, objects deprecated in SQL 2008, like an cheatsheet.

Thanks Gazareth, thanks all.

Okie, users come with database. But they would be orphaned is it not?. Then how to use change users login procedure to fix all orphaned users? Do you have any...

Georege, gazareth, correct. any below options are futile. I was under the impression, that scriptingo out logins which also has password, would work. But that is not the case.

scripting...

absolutely right. SSIS just creates a copy of the login, but the password is not copied. whats the purpose then to just copy login only. I treid scripting out logins,...

08/17/2009 in mm/dd/yyyy format. If you see the query, i filter out invalid dates, which are nulls, blanks etc

what about using ssis to move logins

or

using management studio to script out logins and users (but it comes with default disable login option)

Cadavre

Your query works. Is it the same as the one

select (major_id),OBJECT_NAME(major_id),grantee_principal_id,permission_name,state_desc from sys.database_permissions

where grantee_principal_id=0

1. If i had to move a table from a filegroup in drive A back to paimary in drive B, what should i do?

2. A table and its clustered index...

If i had to move back a table from a filegorup in diff drive to primary, which is also in diffrnt drive, then what should be done?

Guys, any help to get over this would be great.