Robert Davis (5/20/2012)

---

I really like the way you demonstrated the difference in times in the restore process. I'm sure smeone will point out that you can skip zeroing out the...

keep it easy.

Just ad a column to manage the user status.

enabled/disabled/suspended/blocked

This way your "check non-active 3days" application only has to put the column to the value that goes for blocked...

Have a look at:

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

- http://sqlblog.com/blogs/allen_white/archive/2008/12/07/loading-smo-assemblies-into-powershell.aspx

- http://www.mssqltips.com/sqlservertip/1745/using-powershell-with-sql-server-management-objects-smo/

## load SMO assemblies

## use $null to prevent display of assembly load information

$null = [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoExtended")

$null = [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")

did you try to execute your package from Powershell_ISE , PowerGUI or PowerSE (which are all free tools)

Which version of powershell / SQLserver are you using ?

Apparently you didn't load...

Details on the error(s) do matter !

Did you have a look at :

- http://www.codeproject.com/Articles/110908/SQL-DB-Restore-using-PowerShell

or

- http://www.sswug.org/articles/viewarticle.aspx?id=44909

or

- http://poshcode.org/2531

That is a way to test if your backups work.

Keep in mind, you cannot restore a higher version backup to a lower version instance !

Also keep in mind, if you...

Did anybody notice SSC passed 1,500,000 members ?

Great job and thank you for the learning opportunities this wonderful resource provides. :kiss:

the reason why I always start coding the where clause when typing an update query.

That's indeed what it is supposed to be.

- Keep in mind , your domain administrator account doesn't automatically have SQLServer administrator privileges !

- did you try changing the default database for DomainName\Administrator ?

for those interested, you can still download the free ebook The Art of XSD By Jacob Sebastian at the Redgate books section:

http://www.red-gate.com/community/books/art-of-xsd

1) please post some ddl of all involved objects and their indexes

2) please post an execution plan

3) I guess your MessageTimeStamp column has been declare char(23) and it...

-

to lower the impact of your trigger, involve the trigger objects inserted/deleted.

In your case, this may be one of your queries ...

UPDATE B2

SET ...

can you work our an alternative ?

e.g; bcp out the wanted query to a file and send that file attached to a dbmail ?