Display: Cloud | List
Most Popular Tags
Results (44 total) All > database (x)
$theRuns = Get-WmiObject -Class MIIS_RunHistory -Namespace root/MicrosoftIdentityIntegrationServerforeach ($_ in $theRuns){ $displayString = $( $_.MaName + "." + $_.RunProfile) Write-Host $displayString.PadRight(40) -ForegroundColor Blue Write-Host "Duration:".PadRight(12) ([datetime]$_.RunEndTime - [datetime]$_.RunStartTime) Write-Host "Run Start:".PadRight(12) $
Last modified by Craig Martin on 12/30/2009 11:35:44 PM
Correction (An Overview of the New Database Project Wizard)
In the Project Properties section,The default value for the "Project organization" is by schema.The default value for the "Include schema names in the file name" option is No.
Last modified by Hossein.A on 10/13/2011 9:27:26 PM
Tags:  database  project  wizard
Script table definitions (Database.Tables Property (Microsoft.SqlServer.Management.Smo))
The userdefined tables in a given database can be scripted out traversing the Tables collection and using the ScriptionOptions Class.An example in PowerShell that gives some basics: $SqlServerName = '(local)'$DbName = 'AdventureWorks'$SqlBatchSeperator = 'GO'[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.Smo') | Out-Null$Server = New-Object Microsoft.SqlServer.Management.S
Last modified by Niels Grove-Rasmussen on 9/27/2011 1:05:55 PM
Tags:  database  powershell  script  server  smo  sql  table
Script Database (Server.Databases Property (Microsoft.SqlServer.Management.Smo))
Instead if using the Item() method as in the article, you can use the square bracket index.In this example to script the database definition. [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.Smo') | Out-Null$Server = New-Object Microsoft.SqlServer.Management.Smo.Server '.' $DbName = 'AdventureWorks'$Server.Databases[$DbName].Script() The variable for the databasename ca
Last modified by Niels Grove-Rasmussen on 9/27/2011 12:46:58 PM
Management Studio template (sp_change_users_login (Transact-SQL))
EXECUTE [master].[dbo].[sp_change_users_login]@Action = '<Action,varchar(10),Update_One>',@UserNamePattern = N'<UserName,sysname,>',@LoginName = N'<LoginName,sysname,>',@Password = NULL;
Last modified by Niels Grove-Rasmussen on 3/28/2011 10:28:34 AM
Tags:  database  login  orphan  template  user
Using Contained Database (Migrate to a Partially Contained Database)
Check How to create Contained Database and more at http://www.sqlsuperfast.com
Last modified by AmolRajmane on 3/5/2011 5:51:17 PM
Tags:  contained  database
sql 2008 cluster permisions (Moving System Databases)
You can add the cluster service permissions to the new directory with ICACLS, the service accounts do not show in the GUI.egicacls mssql /grant "NT SERVICE\MSSQLSERVER":(F)
Last modified by sql jac on 3/3/2009 3:56:32 PM
Tags:  database  moving  system
Understanding DatabasesThis section provides the information required to understand database concepts and understand how files, filegroups, and transactions logs are used in SQL Server. TopicDescription Database BasicsExplains database concepts. System DatabasesDescribes the system databases used in SQL Server. Understanding Files and FilegroupsExplains file and filegroup concepts. Introduct
Last modified by Microsoft on 10/1/2010 10:21:37 PM
Tags:  basics  database
Developing a Database PlanThe first step in creating a database is creating a plan that serves both as a guide to be used when implementing the database and as a functional specification for the database after it has been implemented. The complexity and detail of a database design is dictated by the complexity and size of the database application and also the user population.The nature and complex
Last modified by Microsoft on 10/1/2010 10:21:37 PM
Tags:  basics  database  design  plan
Last modified by Mike McKeown (expired MS and LPL subscriptions) on 10/7/2010 7:30:58 AM
Page view tracker