Viewing 15 posts - 421 through 435 (of 4,477 total)
No other ideas...I can't remember seeing that particular error message before. Even an ORA error number/message would give a better idea. Is that really the full, exact error message?
Sue
July 22, 2019 at 6:42 pm
Not entirely true, Leo... I've shrunk the files for TempDB just like any other file (although the last time I did so was way back in SS 2012). Contrary...
July 22, 2019 at 5:46 pm
You could try using alter table..rebuild. With heaps, empty pages aren't automatically deallocated when doing a delete:
SQLskills SQL101: Why does my heap have a bunch of empty pages?
Sue
July 22, 2019 at 4:43 pm
Not sure if you ever figured this out or how the refresh process works but I've seen similar things that ended up being related to data skew. So that would...
July 19, 2019 at 5:21 pm
If D$ is an admin share, try using a normal non-admin share.
Sue
July 19, 2019 at 5:01 pm
My guess is they could roll back the policy but they can't set the permissions back to how they were originally. You could change the accounts using SQL Server Configuration...
July 19, 2019 at 4:47 pm
I've always gotten it from Oracle media or their download site for clients but most of those client tools are available to download through OTN (Oracle Technology Network). You can...
July 18, 2019 at 11:18 pm
SQL Server doesn't support the rename when it's involved in replication. You would need to remove the replication, do the rename and add the replication back again using the new...
July 18, 2019 at 6:47 pm
Thanks for posting back. Yeah that is something weird with however they updated the layouts -glad you got it fixed though.
Sue
July 18, 2019 at 6:34 pm
Sounds like something isn't right in the oracle home configuration which is what you would have run after the client install - in the Oracle Net Configuration Assistant. Check the...
July 18, 2019 at 6:29 pm
The changes with the data/time are logged to the error log and the default trace file. You'd need to check those if they are still available from when the changes...
July 18, 2019 at 6:09 pm
If it's just the layout themselves, not likely. If you have implemented a new layout design, which it sounds like you have when referencing old page layouts, you would typically...
July 18, 2019 at 5:39 pm
It's not stored in any of the DMVs. There is no reliable way to get that information unless you are monitoring, capturing it and saving it off somewhere. Some places...
July 18, 2019 at 5:31 pm
I've seen related errors with Analysis Services before - you may want to check if they are connecting to Analysis Services or Database Engine.
Sue
July 18, 2019 at 5:17 pm
Could be related- that's typically something you would want to test before enabling. There are different page output cache settings in different areas. Go to the top level in Site...
July 18, 2019 at 5:13 pm
Viewing 15 posts - 421 through 435 (of 4,477 total)