Viewing 15 posts - 16 through 30 (of 147 total)
Jeff Moden (7/1/2012)
WHY are we making a trip to Powershell for this property???
Multi-instance and multi-server would have been my guess. Without a CMS in place, it would make sense to...
July 2, 2012 at 6:03 am
This should get you what you want using SMO:
param (
[string] $server,
[string] $database
)
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") |
Out-Null
$sql_server = New-Object ("Microsoft.SqlServer.Management.Smo.Server") $server
$db = $sql_server.Databases.Item($database)
$db_owner = $db.Owner
Write-Host "$database Owner: $db_owner"
Save this as a script file and...
July 1, 2012 at 7:28 pm
What exactly does the job do?
June 26, 2012 at 8:48 pm
Please define what you mean by "trail". Do you mean auditing?
June 25, 2012 at 9:07 pm
As long as you aren't too concerned with connecting to SSAS/SSIS/SSRS or using SQL Server Agent, you shouldn't have any major issues (there are still a handful of things you...
June 25, 2012 at 7:16 pm
I'd say the first verification test is to double-check your indexes and if they are unique:
select
name,
is_unique,
is_unique_constraint
from sys.indexes
where name in
(
'YourIndexName1',
'YourIndexName2',
'YourIndexName3'
);
June 25, 2012 at 10:33 am
The -m startup option will start an instance in single user mode. But this is not a requirement in order to get a list of all databases.
June 24, 2012 at 6:09 pm
Can you connect to the instance that the package is hitting with SSMS?
June 22, 2012 at 6:56 pm
No, an index reorganization does not update statistics.
June 21, 2012 at 8:53 am
No, you cannot change who the default owner is of a job. When you create a SQL Server Agent job, the msdb.dbo.sp_add_job stored procedure is what is called. ...
June 20, 2012 at 8:40 pm
Michael Valentine Jones (6/20/2012)
execute sp_updatestats
sp_updatestats (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms173804(v=sql.105).aspx
"...sp_updatestats updates only the statistics that require updating based on the rowmodctr...
June 20, 2012 at 7:04 pm
Eugene Elutin (6/18/2012)
Thomas Stringer (6/17/2012)
CELKO (6/17/2012)
Why use all this code to fake arrays or magnetic tapes? Just write five UPDATE STATISTICS commands and run the script.
The OP wants to update...
June 18, 2012 at 10:17 am
CELKO (6/17/2012)
Why use all this code to fake arrays or magnetic tapes? Just write five UPDATE STATISTICS commands and run the script.
The OP wants to update stats on 5 databases.
June 17, 2012 at 9:13 pm
Viewing 15 posts - 16 through 30 (of 147 total)