Viewing 15 posts - 391 through 405 (of 4,477 total)
Hey Kal - Things will run fine for now but if you hit a disaster of some type in production, then you may have some things to work on. When...
August 5, 2019 at 10:51 pm
Suspend moves services and applications off the node but not the cluster resources. Your question was about moving all resources.
August 5, 2019 at 10:27 pm
It only pauses the node and isn't suppose to trigger a failover. So you'd want to still do the move.
Sue
August 5, 2019 at 10:03 pm
Thanks for posting back - I was wondering about the other alternatives. My thought was about the adding another password but from another post of yours it looked like you...
August 5, 2019 at 9:53 pm
To all, I apologize for the bad example in the CASE Statement and it was not a trick question. Yes, it should have been the following:
CASE my_field ...
This was...
August 5, 2019 at 6:54 pm
The process is similar in SSRS. Take a look at the following article that walks through the process of a bell curve in SSRS. Most of what you are looking...
August 5, 2019 at 6:51 pm
There is a default trace that runs. It's enabled by default and if you didn't know about it, it likely is still enabled. The Schema Changes History report queries the...
August 1, 2019 at 8:08 pm
Setup the linked server security so that it does not use that users security context. Map the users to some other account that has access to the server/database and select...
August 1, 2019 at 7:25 pm
If the trace hasn't rolled over from when it happened, you could query the trace files or just do the Schema Changes History report for the database.
Sue
August 1, 2019 at 7:05 pm
Try using sys.login_token and sys.user_token to find all the tokens associated with that account. It can pick up universal groups as well as nested groups which can be missed using...
August 1, 2019 at 6:58 pm
There are quite a few Powerbuilder decompilers available if you do a search. I'd be careful about the downloads though...no doubt some of those are just to infect PCs.
Sue
August 1, 2019 at 6:00 pm
You likely were running in an older compatibility mode which is no longer supported. The old join syntax would have needed to be changed a long, long, long time ago....
August 1, 2019 at 5:33 pm
Right click on the Replication folder in SSMS and select Generate Scripts. Select the options if you want to include distributor properties and replication jobs, select the publications and subscriptions,...
August 1, 2019 at 5:16 pm
Check for more information in the error log and the Windows event logs. It could also be some storage issues going on.
Sue
August 1, 2019 at 3:08 pm
It's a setting just on the report properties.
Sue
August 1, 2019 at 3:06 pm
Viewing 15 posts - 391 through 405 (of 4,477 total)