Yes, you can partition a table based on a datetime field. You'll need to create a partition function that accepts a datetime value for the input parameter. Create a partition...

SELECT [ROUTINE_NAME] AS [StoredProc]

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%YourPackageName%'

AND ROUTINE_TYPE = 'procedure'

Due to budget constraints etc we've had to set up new database servers with 8 disk's (although I argued for more). I set them up as follows:

2 Disks on RAID1...

Is it data you need to compare, or database structure? Check out RedGates tool belt, you can get a 14day trial version.

A simple web search will provide this. Google is your friend. As is BOL

My understanding was that [sp_who2 'active'] only shows active (and not dormant) processes, including system ones. Whereas PerfMon UserConnections shows just that, user connections. Although im not 100% on how...

Next time you see your query placed in a suspended state, check the "wait type" value for that process. You can see that in Activity Monitor. The "wait type" should...

There is no way to restore a SQL Server 2008 backup ".bak" file to SQL Server 2005. Scripting objects and importing data is your best option

Thanks for the reply, very usefull. It is currently the only monitoring tool im experimenting with and at present is only running on one of our VM test servers, but...

Looks like you haven't installed "client tools". Try installing them, you need these for SSMS

Hi, as gilamonster says, its a permissions issue. Make sure there are R+W permissions on the restore directory too, not just the location where the logs are copied to, IE...

When you requested SQL backup and restore the db's did you specify where they are to be restored to?

Thanks guys that worked a treat. I created the sp's needed for the sp_help_revlogin and was able to generate the logins to apply on the secondary server while the DBs...

Thank you. Will try that first thing and report on the outcome. Again, muchas gracias.

I don't know of a way to get SQL Server to generate the XML in a format that conforms to your XSD automatically. What you may need to do is...