Hi Megha,

Sorry can't see a link

R.P.Rozema thanks very much for the response, this is exactly what I was after. I kind of new the gist of it but having a "list" to refer to will...

Not sure i fully understand what you want acheive, You can query different database on the same server using the three part name SELECT * FROM dbname.schame.tablename etc if the...

I wouldn't recommend autogrow, you have no control when file expands, resize manually and set it to the size you need. I would recommend scheduling it at an off peak...

I'm not an expert in replication but I'd say that this is achievable.

if replication is what your after then i'd say Transactional replication is what you need. after...

Not sure about CLR resources but for SSIS Brian Knight has produced some excellent books...

Professional SQL Server 2005 Integration Services by Brian Knight. I think it's published by Wroxs

Hope this...

Hi,

The "Subject" of SQL Server is rather vast, so it would help if you could specify the areas you which wanted to research...SSIS SSAS Backups Restores Performance Tuning etc.

Check out this link...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=631415&SiteID=1

also, bit random i know but if the database was restored to time before the views were created then the changes would be missing

Simple answer - Yes it does. It holds all Job and Maintenacne plans and any DTS packages that were stored on the server too. If you need this data then...

I think also using AWE will mean that the memory setting configured will be allocated to SQL so total memory will be whatever you set it to 6GB i think...

You need to enable traceflag, 3226, this URL may help:

http://blogs.msdn.com/sqlserverstorageengine/archive/2007/10/30/when-is-too-much-success-a-bad-thing.aspx

Try this artilce...

http://www.microsoft.com/downloads/details.aspx?familyid=3D5E96D9-0074-46C4-BD4F-C3EB2ABF4B66&displaylang=en

Have you run the Upgrade Advisor against your current setup?

Also if all your db's are VLDB's then you we need a lot of physical disk space...

Have you configured the new 2005 for "Mixed Authentication" If your new server is configued for Windows authenication you will get this message.

It is also worth remmebering that the mode you chose and the backup strategy you implement will affects how often checkpoints are issued. Which can affect how long SQL Server...