You will need to script out a logic and then use the script to upload data in destination. Through SSIS i see no such features available for you.

You have the row_number() function in SQL 2005 that can be used for your rowid. If you want more information just read the link given below.

http://www.databasejournal.com/features/mssql/article.php/3572301

SQL Anywhere is a SYBASE EDM. sp_spaceused is not support there and has been replaced. Read the link given below to know what has got changed in syabase.

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1000/en/pdf/dbwnen10.pdf

No. with sa you can have control of all objects in the server. So you need not worry about creating a user and giving owner permission for a particular database.

Script the object level permissions for the first user and then in the script replace the first user with the user tht you have created and run against the database....

Good that you have taken the initial step to secure the server. At first change the password for the sa account and kept it confidential within you and some high...

Good that you have atlast your sql running.BTW whenever you do a upgrade perform to check the protocols and connection information.

You have installed SP4 which requires a reboot. Ok now you give a static port for your sql server other than the default 1433 and check if you are able...

Did you do a mock restoartion and check if the backup file is correct. If so why do you worry about the size of the database backup file.

Since you say that you have enabled remote connections few checks from our side.

from the machine where you face this problem try using SSMS to connect to the SQL Server...

Have you rebooted the server post SP4 installation.

Syed, You mean to say that you do a reindex and then backup the file and the size increases after that i does not. OK can you check if the...

Just restart the SQL Server services you will have all space occupied by tempdb released to disk but before that check what is the initial size that is given for...

I hope sqlcmd can take a input file as a parameter. put your query into the file adn call the file containing the sql code in the sqlcmd statement.

From the GUI i meant diuble click the exe that you have for your sql server SP4. it will take you up to a wizard and from there.