Hi,

This post here takes you through how to do it:

http://stackoverflow.com/questions/13200511/how-to-generate-scripts-for-all-triggers-in-database-using-microsoft-sql-server

But I doubt you can do it without scripting out the tables themselves without the use of a 3rd party tool...

Looking at BOL there isn't a style no. for your date format. You'll have to do some string manipulation with LEFT() and RIGHT() to sort it out.

Thanks,

Simon

Ok so at what point does it fail, trying to create the checkpoint file, or trying to read it?

Sounds like a permissions issue to me. Does the credential the proxy account uses have access to the path where the checkpoint file is?

Thanks,

Simon

Post what you have so far so we can see what you're doing.

Hi,

Perhaps this will help... there are 4 parts to it.

http://www.mssqltips.com/sqlservertip/1687/install-sql-server-2008-on-a-windows-server-2008-cluster-part-1/[/url]

Thanks,

Simon

Sorry - Update statistics is not required for Index Rebuild, automatically it will be updated. Please refer the below link. I have pasted the specific content below:

http://msdn.microsoft.com/en-us/library/ms190397.aspx

After Maintenance...

Transactions continue to commit on the principal.

Read this: http://msdn.microsoft.com/en-us/library/ms179344(v=sql.105).aspx

Thanks,

Simon

Hi,

How are you identifying the "different order". There is no default "order by" in SQL Server. If you've got a clustered index on the table then the data is logically...

Follow Andy on Twitter, he tweets when new...

Hi,

Given the limitations of Web edition, i.e. no mirroring etc. I'd say the best way to keep downtime to a minimum is setup your new server and configure log shipping...

I believe since 2008R2 you can have the nodes in separate subnets alleviating the need for a stretch VLAN. But yes you'd need some sort of storage replication going on.

Glad...

Hi,

If you run the following query:

select * from sysmessages where description like '%mirror%'

You'll get a list of error messages that relate to mirroring. Looks like error 1454 will be fired...

Hi,

Always On Failover Clustering in standard edition is simply failover clustering. It does not offer you read only replicas that is an enterprise only feature so offloading reporting would have...

Great! Glad you got it sorted.