I gather that the data is read only and the end users cannot modify it. Is that correct?

You cant call it in a select statement not can you pass column names . You will have to define column name as a params or hard code the column...

sysobjects is a system table and sys.sysobjects and sys.objects are views. Question mentions sysobjects.

Here's a different approach that i try for complex functions. I create a stored procedure with same code as that of the function. Most of the time this is easily...

vaseem (8/26/2009)

If I take full backup of Master database along with other user database then I restore user database backups along with master database then should I have all logins/users...

Are you facing any performance problems.

I haven't used SQLCMD but i got this from BOL.

"h headers

Specifies the number of rows to print between the column headings. The default is to print headings one time...

Real data type is a approximate data types, it stores approximate values rather than the exact value. Generally this shouldn't be noticeable for small values. If you want to...

Can u explain the varbinary thing.

To add to what Grant has said..

When you rebuild your indexes temp db is used extensively.

If your temp db size is not set to 9gb initial size then you...

Are you going to put all the 200 databases in a signle sql server instance?

My 2 cents...

First have proper backups or have the old server in running condition so that you can fall back on it in case something goes wrong while moving your...

That's a good point about having staging tables in a database with simple recovery model. Thanks

A 20 page report is useless to the customer but what if the user wants...

Is the "qryCycleTimesBR_6" the final result set that you want and the other queries are written just to get the final (qryCycleTimesBR_6) result.

Viji

Typically a data dictionary contains info regarding tables, fkeys, indexes and also information regarding hard coded values in columns if any. Other than this it contains info regarding stored...