Viewing 15 posts - 1,006 through 1,020 (of 7,467 total)
Could not find stored procedure 'Validate_User_Token'
Indeed, at least Schema qualify all objects !
Exec [YourSchema].Validate_User_Token
Accounts can have their own default schema set !
June 11, 2015 at 7:47 am
Solved the issue !
The trick lies in Set-ClusterOwnerNode and specify a Resource !
$Res = Get-ClusterResource -Cluster cl11 -Name "SQL Server ($InstanceName)" |
where ResourceType -eq...
April 30, 2015 at 6:16 am
I have this issue on our SQL2008R2 SP2 instance.
It just didn't register any deadlock data in system_health for the last 11 days ( and counting ).
To fix it I request...
March 17, 2015 at 2:53 am
Perry Whittle (2/11/2015)
ALZDBA (2/11/2015)
- You need to know the difference between Clustering and Always-on !My stairway series details this, has been linked and is available on this site
...
and a great...
February 11, 2015 at 4:36 am
I haven't read through the whole thead, but just want to share my 2ct
- You need to know the difference between Clustering and Always-on !
- clustering: HA solution...
February 11, 2015 at 4:18 am
I don't use maintenance plans because of different issues.
I use Backup devices for all sqlserver backups ( 3 devices per database ( Full / Diff / Log ) )
Diff...
February 11, 2015 at 4:06 am
No worries ! There are more ways to skin a cat 😉
Off course an "alter database [x] set offline with rollback immediate" is the most safe way.
Seems strange:
Or the db...
February 10, 2015 at 5:58 am
I always put the target database offline ( with rollback immediate ) right before the actual restore statement, to be sure no one blocks my restore.
I have incorporated it all...
February 10, 2015 at 5:21 am
did you check out Idera's SQL Permissions Extractor (freeware)?
February 10, 2015 at 1:52 am
as Gail stated it is only intended to mimic sql server behaviour of an older level.
It is supposed to be used for a "short" time to be able to move...
February 10, 2015 at 1:49 am
double check the file isn't used by an other database than the one you are trying to restore.
February 10, 2015 at 1:41 am
haven't seen any remarks about concatenated ( meaningfull ) keys yet.
Recently had to tune a query full of substrings because pos 2 to 4 had a originating status code and...
February 10, 2015 at 12:21 am
February 9, 2015 at 6:05 am
if this is a migration project, did you consider SQL Server Upgrade Assistant for msaccess ( MS freeware ! ) ?
http://www.microsoft.com/en-us/download/details.aspx?id=42656
February 9, 2015 at 6:01 am
FYI you are missing out the COALESCE function, which you can consider a recursive ISNULL.
Personally I prefer Isnull and Coalesce over a Case expression to accomplish the same functionality.
February 2, 2015 at 12:02 am
Viewing 15 posts - 1,006 through 1,020 (of 7,467 total)